- Home
- MCP servers
- Postgres MCP Pro
Postgres MCP Pro
Postgres server with health checks, index tuning and EXPLAIN plan analysis
What it is
Goes beyond running queries: it reports on database health (indexes, vacuum, connections, replication), recommends indexes for a workload, reviews EXPLAIN plans with hypothetical indexes, and offers a restricted read-only mode. For developers and DBAs tuning PostgreSQL with an assistant.
Good for
- Find slow queries and missing indexes
- Review EXPLAIN plans
- Run read-only SQL against production
Install or run
pipx install postgres-mcpCommand as given in the project README. Read the repository before you run anything on your machine.
What you need
Python (pipx/uv) or Docker; a PostgreSQL connection URI
Sources
- https://github.com/crystaldba/postgres-mcp (project README, read 10 Nov 2026)
- https://api.github.com/repos/crystaldba/postgres-mcp (GitHub API, read 13 Nov 2026)
The summary is ours, written from the README. Spotted an error? See how we work.