mcpexplorer.com
mcps / postgres
MCPExplorer Verified

Postgres MCP server

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
{ "mcpServers": { "postgres": { "command": "uvx", "args": ["postgres-mcp"] } } }
07FAQ
What is Postgres MCP?

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 is Postgres for?

Developers and DBAs who want an agent that not only queries Postgres but helps optimize and maintain it.

How do I connect Postgres to my agent?

Postgres runs locally over stdio. Add it to your MCP client config: claude mcp add postgres -e DATABASE_URI=postgresql://user:pass@host:5432/db -- uvx postgres-mcp.

Does Postgres require authentication?

Yes — Postgres authenticates with Connection URI. You connect your own account, and it acts only within the scopes you grant.

How much does Postgres cost?

Free · open source.

Is Postgres verified on MCPExplorer?

Yes — Postgres is hand-checked and featured on MCPExplorer. We pull its real tool surface, required scopes, and risk labels from the live index so you can see exactly what it does before connecting.

08Similar MCPs

Other MCP servers worth a look in Database.

Supabase
Database
Postgres and project ops for agents.
Neon
Database
Serverless Postgres for agents.
ChatSEO
SEO & content
An AI SEO agent inside your MCP client.
Apex
LinkedIn & outbound
Governed LinkedIn hands for your AI agent.
09Badge

Postgres is featured on MCPExplorer. Add this badge to Postgres’s site or README — it links back to this page.

Postgres MCP — as seen on mcpexplorer.com

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

[![Postgres MCP — as seen on mcpexplorer.com](https://mcpexplorer.com/badge/postgres.svg)](https://mcpexplorer.com/mcps/postgres)
Get started

Set up Postgres and put it to work — Free · open source. Or see its full verified profile.

Visit Postgres →Full profile