Install guide and config at curatedmcp.com

PostgreSQL MCP: Let Claude query your databases in plain English

Tired of context-switching between your IDE and database tools? PostgreSQL MCP brings your Postgres database directly into Claude, Cursor, or Windsurf—letting you write natural language queries that get translated to SQL automatically.

What It Does

PostgreSQL MCP bridges the gap between AI agents and your Postgres databases. Instead of manually writing SQL, you describe what you need in plain English. The server translates it to SQL, executes it safely, and returns formatted results—all within your AI conversation.

The server handles schema introspection automatically, so Claude understands your table structure without you manually documenting it. Want to explore a database? Ask Claude. Need analytics queries? Describe the analysis. Building a report? Let Claude write the queries.

Key safety features matter in production: read-only mode prevents accidental mutations, connection pooling with PgBouncer support handles concurrency, and sandboxed execution keeps queries isolated. Query history and EXPLAIN plans help you optimize slow queries without leaving your chat window.

How to Install

npx @modelcontextprotocol/server-postgres

Add this to your Claude Desktop config (~/Library/Application\ Support/Claude/claude_desktop_config.json on Mac):

{
  "mcpServers": {
    "postgresql-mcp": {
      "command": "npx @modelcontextprotocol/server-postgres",
      "env": {
        "DATABASE_URL": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

Restart Claude Desktop, and you're live.

Real-World Use Cases

• Debug production data issues: "Find all failed transactions from yesterday and show me the error patterns." Claude writes the query, you get instant insights.
• Generate reports inside Cursor: Chat with your codebase and database simultaneously. "Show me monthly revenue trends and help me write the SQL for our analytics dashboard."
• Explore unfamiliar schemas: Onboarding to a legacy system? Let Claude navigate the database structure, show relationships, and help you understand what data actually exists.

Full install guides for Claude Desktop, Cursor, Windsurf, and more at CuratedMCP.