Postgres MCP Pro

At a glance

Most database servers stop at running SQL. Postgres MCP Pro adds the things a DBA would check: explain plans, slow queries from pg_stat_statements, index recommendations, and health checks for vacuum, bloat and connections.

It has an access-mode switch. Restricted mode keeps it to read-only transactions with time limits, which is where to start on any database that matters.

Made by

Crystal DBA

Licence

MIT

Latest version

0.3.0 (16 May 2025)

PyPI package

postgres-mcp

GitHub stars

3.4K

Downloads

147K a week

Last commit

17 Aug 2026

Tools

9

Runs on

Your computer

Our check: We ran this exact config on 26 Oct 2026: it started and answered with 9 tools. The npm package called "postgres-mcp" is a different project (llm-graph/postgres-mcp). Crystal DBA publishes this server to PyPI and Docker Hub. In October 2026 "uvx postgres-mcp" falls back to an old 0.1.0 release that crashes, because 0.3.0 pins a pglast version PyPI no longer has, so we publish the Docker image instead.

What's in the pod: its tools

We found 9 tools when we started it on 26 Oct 2026. 4 only read. The rest can change things, so keep your app's "ask before each tool call" setting on for them.

How we tested it: Started with the published Docker config against a local Postgres 16 database. The older "uvx postgres-mcp" config crashed on start (it resolves to release 0.1.0).

Grouped and described by us. The README on GitHub lists the inputs each tool takes.

Set it up

Pick your app for the exact snippet and where it goes.

{
  "mcpServers": {
    "postgres-mcp-pro": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=restricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

claude mcp add-json postgres-mcp-pro '{"command":"docker","args":["run","-i","--rm","-e","DATABASE_URI","crystaldba/postgres-mcp","--access-mode=restricted"],"env":{"DATABASE_URI":"postgresql://user:password@localhost:5432/dbname"}}'

{
  "mcpServers": {
    "postgres-mcp-pro": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=restricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

{
  "servers": {
    "postgres-mcp-pro": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=restricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

{
  "mcpServers": {
    "postgres-mcp-pro": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=restricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://user:password@localhost:5432/dbname"
      }
    }
  }
}

The image rewrites localhost in the connection string so it reaches a database on your own machine. Swap restricted for unrestricted only on a database you can afford to change.

New to this? See the setup guides for Claude Code, Cursor, Claude Desktop and ChatGPT.

Settings

Names are exactly as the project spells them. Required ones are marked.

What it can touch

Safer setup: Use --access-mode=restricted for anything that matters, and connect with a database role that has read-only rights as a second guard.

Before you start

• Docker
• A Postgres connection string

If it does not work

Index advice or top queries are empty

Install pg_stat_statements and hypopg. Self-managed Postgres also needs pg_stat_statements added to shared_preload_libraries and a restart.

Docker cannot reach the database

The image already maps localhost to your machine. For a database elsewhere, check the host in DATABASE_URI is reachable from inside Docker.

Python install has dependency errors

It needs Python 3.12 or newer. The project recommends Docker to avoid these issues.

Peas in a pod: similar servers

How Postgres MCP Pro lines up against other databases and data servers on the shelf.

Questions

Something wrong on this page? Tell us.