Query, analyze, and tune your Postgres database from your agent.
Databaseby Crystal DBAConnection URIFree · open source
01What it is
Postgres MCP Pro (by Crystal DBA) is a popular open-source MCP server for Postgres that goes beyond raw SQL: an agent can run queries with configurable safety modes, analyze database health (indexes, cache, vacuum, replication), tune indexes with real algorithms, and inspect query plans with hypothetical-index simulation. Connect it with a standard Postgres URI.
Who it’s for: Developers and DBAs who want an agent that not only queries Postgres but helps optimize and maintain it.
02Highlights
Query, safely
Run SQL with restricted or unrestricted access modes you control.
Health & tuning
Analyze indexes, cache, vacuum, and replication; get real index-tuning recommendations.
Plan analysis
EXPLAIN with hypothetical-index simulation to test changes before applying them.
03Add it to your agent
Local MCP server — runs on your machine via the command below.
claude mcp add postgres -e DATABASE_URI=postgresql://user:pass@host:5432/db -- uvx postgres-mcp
Postgres is featured on MCPExplorer. Add this badge to Postgres’s site or README — it links back to this page.
HTML — for your website
<a href="https://mcpexplorer.com/mcps/postgres" target="_blank" rel="noopener"><img src="https://mcpexplorer.com/badge/postgres.svg" alt="Postgres MCP — as seen on mcpexplorer.com" height="20" /></a>
Markdown — for a README
[](https://mcpexplorer.com/mcps/postgres)
Get started
Set up Postgres and put it to work — Free · open source. Or see its full verified profile.
