Claude Desktop · MCP

Add PostgreSQL to Claude Desktop

Let Claude run read-only queries against your Postgres database.

Files & dataNo key neededSource repo

Your config

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

›Replace the connection string with your own. Access is read-only by design.

How to add it

01

Open Claude Desktop → Settings → Developer → Edit Config.

02

Paste the block below into claude_desktop_config.json (merge it into "mcpServers" if you already have some).

03

Fill in any placeholder values (paths, API keys).

04

Fully quit and reopen Claude Desktop. The server’s tools appear in the 🔌 menu.

The linked repo is the source of truth — if the package name ever changes, it’ll be current there.

Want a whole automation, not just one tool? Grab a working workflow template.