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:
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"
]
},
"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.