mcp-postgres-server

MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.

Install Command

npx -y mcp-postgres-server

Claude Desktop Config

{
  "mcpServers": {
    "mcp-postgres-server": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-postgres-server"
      ]
    }
  }
}

mcp-postgres-server is a community MCP server that connects AI assistants like Claude to mcp server for postgresql: local, docker, rds, neon, supabase, or behind an ssh bastion. It runs locally on your machine, keeping your data private and giving you full control over the connection. This makes it easy to query and manage your data without leaving your AI assistant.

About mcp-postgres-server

Overview

MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.

Topics

mcp, mcp-server, model-context-protocol, postgres, postgresql, database, sql, ssh-tunnel, ai-agents, claude-code, llm, claude, cursor, anthropic

Who Should Use mcp-postgres-server?

1Run natural-language queries against your database without writing SQL
2Inspect schemas, tables, and relationships during development
3Automate data exports, migrations, and reporting tasks
4Let AI assistants answer questions directly from your live data

How to Install mcp-postgres-server

Before you start

You will need Node.js (v18 or later) installed on your machine — download it from nodejs.org if you haven't already.

1Open a terminal (Terminal on Mac, Command Prompt or PowerShell on Windows).
2Paste the install command above and press Enter — Node.js will download and run the server automatically.
3Add the server to your Claude Desktop config file (see the JSON snippet above) and restart Claude.

The Claude Desktop config snippet above can be copied and pasted directly into your claude_desktop_config.json file — no editing required.