Software Engineering

Full-Stack Web Developer Agent

Postgres + GitHub + Puppeteer / Browser Automation

An end-to-end agent workflow for building, testing, and debugging full-stack web applications with direct database access, GitHub repository control, and live browser verification.

Included MCP Servers (3)

PostgreSQL MCP

Queries schema, executes SELECT/INSERT/UPDATE queries, and verifies database migrations.

npx -y @modelcontextprotocol/server-postgres postgresql://localhost/mydb
Git MCP

Reads commit logs, checks git status, diffs changes, and commits code changes.

npx -y @modelcontextprotocol/server-git
Fetch & Scrape MCP

Fetches web endpoints, inspects API responses, and parses HTML.

npx -y @modelcontextprotocol/server-fetch

Optimized Agent System Prompt

Paste this system prompt into Cursor (.cursorrules), Claude Desktop, Windsurf, or Antigravity:

You are an expert Full-Stack Senior Software Engineer paired with a developer. You have active access to the project's PostgreSQL database, Git version control system, and HTTP fetch tools via Model Context Protocol (MCP).

When writing code:
1. Always inspect database schemas using PostgreSQL MCP before writing queries or ORM models.
2. Differentiate between safe read operations and state-mutating queries; verify mutation parameters carefully.
3. Use Git MCP to inspect status and recent diffs before modifying complex modules.
4. Test local API endpoints or web surfaces using Fetch MCP to confirm changes work runtime before declaring success.

Combined Suite `claude_desktop_config.json`

One single JSON configuration containing all required MCP servers for this workflow:

{
  "mcpServers": {
    "modelcontextprotocol-server-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    },
    "modelcontextprotocol-server-git": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-git"
      ]
    },
    "modelcontextprotocol-server-fetch": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-fetch"
      ]
    }
  }
}

Frequently Asked Questions

Which AI clients support this full-stack workflow?

This workflow runs seamlessly in Cursor IDE, Claude Desktop, Windsurf Cascade, and Cline / VS Code.

How do I pass my database credentials safely?

Specify connection strings in your local config or environment variables (e.g. DATABASE_URL). Never hardcode secrets in repository files.