MCP server

Postgres MCP Pro

Postgres MCP server with index tuning, explain plans, health checks and a restricted read-only mode.

Author: Crystal DBA
Works with: Any MCP client
Documented: Oct 2, 2026

What Postgres MCP Pro is

Open source MCP server for the whole development process. It offers health analysis, index tuning, query plans, schema intelligence and safe SQL execution. The reference postgres server is archived in modelcontextprotocol/servers-archived.

What it does

Where Postgres MCP Pro runs and what it adds, from its documentation

Database health checks
Index tuning
EXPLAIN plans with hypothetical indexes
Schema-aware SQL generation
Restricted (read-only) vs unrestricted access mode

When to use it

Good fit

Performance tuning with an agent
Dev use in unrestricted mode, production in restricted mode

Not for

Unreviewed writes to production: use restricted mode
Python-less or Docker-less setups

How to install Postgres MCP Pro

You need: Docker or Python 3.12+; Postgres credentials

Have DB credentials and Docker or Python 3.12+
docker pull crystaldba/postgres-mcp, or pipx install postgres-mcp
Add the config to your MCP client with DATABASE_URI
Set --access-mode=restricted for production

Permissions and security

What it can access

Runs SQL on the configured database; restricted mode limits to read-only transactions

Security notes from the maintainers

DATABASE_URI contains credentials

Review the source before granting an agent access to credentials or production systems. We document what the maintainers state; we do not audit code.

Limitations

Restricted mode constrains only execution time among resources

Frequently asked questions

How do I make Postgres MCP Pro read-only?

Use --access-mode=restricted. source

Is Postgres MCP Pro official?

It is by Crystal DBA, not the MCP project; the reference postgres server is archived. source

How do I install Postgres MCP Pro?

docker pull crystaldba/postgres-mcp or pipx install postgres-mcp. source

Related guides

Sources and gaps

https://raw.githubusercontent.com/crystaldba/postgres-mcp/main/README.md readme, checked Oct 2, 2026
https://raw.githubusercontent.com/modelcontextprotocol/servers/main/README.md readme, checked Oct 2, 2026

Not stated by the maintainers: License not seen in the README; last_release date not visible in the checked README.