PostgreSQL MCP Server

Read schema schemas, execute read-only queries, and inspect Postgres tables directly in Cursor and Claude.

⚡ 1-Line CLI Test Command

npx -y @modelcontextprotocol/server-postgres postgresql://user:pass@localhost:5432/db

⚙️ Claude Desktop Config (claude_desktop_config.json)

{
  "mcpServers": {
    "postgres": {
      "command": "npx",
      "args": [
        "-y",
        "@modelcontextprotocol/server-postgres",
        "postgresql://user:pass@localhost:5432/db"
      ]
    }
  }
}

🛠️ Exposed Tools

query, list_tables, describe_table