How to Install PostgreSQL MCP in Windsurf

Natural language SQL queries on your PostgreSQL databases

What PostgreSQL MCP does

Let your AI agents query and manage PostgreSQL databases using natural language. Safe, sandboxed execution with read-only mode support. Features: - Natural language to SQL translation - Read-only mode for safe production use - Schema introspection - Query result formatting - Connection pooling with PgBouncer support - Query history and explain plans

postgresql

sql

database

analytics

Installation steps

1Copy the config below
2Open ~/.codeium/windsurf/mcp_config.json
3Paste inside "mcpServers": {}
4Restart Windsurf

Configuration

File location: ~/.codeium/windsurf/mcp_config.json

mcp_config.jsonjson

{
  "postgresqlMcp": {
    "command": "npx",
    "args": [
      "-y",
      "@modelcontextprotocol/server-postgres"
    ]
  }
}

Full server details Open Config Editor

Install in other clients

🤖Claude Desktop 💻Claude Code ⌨️Cursor ✨OpenAI ♊Gemini

For maintainers

If you maintain PostgreSQL MCP, add this badge to your README to show it's verified on CuratedMCP:

[![CuratedMCP Verified](https://curatedmcp.com/api/badge/postgresql-mcp)](https://curatedmcp.com/marketplace/postgresql-mcp)

Related servers

SQLite MCP Server

SQLite database queries, analysis, and memo storage for local AI workflows

Free

Notion MCP Server

Read, write, and search your Notion workspace — databases, pages, and knowledge base

Free

Supabase MCP Server

Official Supabase integration — manage tables, run queries, handle auth, and deploy edge functions

Free