Postgres MCP Pro
Postgres MCP Pro, from Crystal DBA, is an open-source MCP server for PostgreSQL that goes beyond running queries.
What it does
Postgres MCP Pro, from Crystal DBA, is an open-source MCP server for PostgreSQL that goes beyond running queries. Besides listing schemas and objects and executing SQL, it checks database health (indexes, connections, cache, vacuum, sequences, replication), reports the slowest queries from pg_stat_statements, shows query plans with hypothetical indexes, and recommends indexes for a workload or a set of queries. It runs locally from Docker or Python over stdio, or as a shared SSE server. A connection URI is passed in an environment variable, and an access mode switches between full read-write access and a restricted mode with read-only transactions and time limits.
Capabilities
- Run SQL on a PostgreSQL database, read-only in restricted mode
- Check index, vacuum, connection and replication health
- Report the slowest queries from pg_stat_statements
- Show query plans, including with hypothetical indexes
- Recommend indexes for a workload or specific queries
Install
- Run this to add it to Any client:
pipx install postgres-mcp
Details
| Fact | Value | Source |
|---|---|---|
| Type | MCP server | |
| Tool | PostgreSQL | |
| Publisher | Crystal DBA | source |
| Official status | Community (not published by the tool's vendor) | source |
| Connection | Local (runs on your computer) | source |
| Can change data | Yes | source |
| Needs an API key or sign-in | Yes | source |
| Platforms | Not stated in its documentation | |
| AI clients | Claude Desktop, Cursor, Devin Desktop, Cline | source |
| Licence | MIT | source |
| Pricing | Not stated in its documentation | |
| Activity | Last commit Aug 17, 20263,467 GitHub starsDownload data not available (not on npm or PyPI) | source |
| Links | Repository |
Badge for your README
Maintain this project? Add a badge that links to this page.
[](https://kitbay.app/servers/crystaldba-postgres-mcp/)
Sources
- README (README.md)github.com/crystaldba/postgres-mcp · Backs: AI clients, Can change data, Connection, Needs an API key or sign-inNov 12, 2026
- Licence file (LICENSE)github.com/crystaldba/postgres-mcp · Backs: LicenceNov 12, 2026
- GitHub repositorygithub.com/crystaldba/postgres-mcp · Backs: Official status, Publisher, Activity, LicenceNov 11, 2026
- GitHub API recordgithub.com/crystaldba/postgres-mcpNov 10, 2026