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.

    uvx mcp-server-git --repository /path/to/your/repo
  • Fetch & Scrape MCP

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

    uvx mcp-server-fetch

Optimized Agent System Prompt

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

Code
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:

JSON Config
{
  "mcpServers": {
    "modelcontextprotocol-server-postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://localhost/mydb"
      ]
    },
    "git": {
      "command": "uvx",
      "args": [
        "mcp-server-git",
        "--repository",
        "/path/to/your/repo"
      ]
    },
    "fetch": {
      "command": "uvx",
      "args": [
        "mcp-server-fetch"
      ]
    }
  }
}

Frequently Asked Questions

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

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