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:

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"
      ]
    },
    "modelcontextprotocol-server-git": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-git"
      ]
    },
    "modelcontextprotocol-server-fetch": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-fetch"
      ]
    }
  }
}

Frequently Asked Questions

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