# Postgres MCP Pro (slim)

> PostgreSQL server with configurable read/write access plus DBA tooling (index tuning with hypopg, EXPLAIN analysis, top-query and workload analysis, health checks).

- Full: https://www.anchorterminal.com/tools/postgres-mcp-pro.md (~5,850 tokens) · this version ~1,130 tokens · JSON https://www.anchorterminal.com/tools/postgres-mcp-pro.json · canonical https://www.anchorterminal.com/tools/postgres-mcp-pro
- Index: https://www.anchorterminal.com/llms.txt · API: https://www.anchorterminal.com/api/v1/index.json · Updated: 2026-10-04

**F · 36.7/100 · rank #436 of 452 · #7 in Databases & files · not agent-ready · confidence medium**


Assessment: Index tuning with hypopg, EXPLAIN with hypothetical indexes, top queries and seven health checks. No release since 0.3.0 on 16 May 2025, and `uvx postgres-mcp` fails on a fresh install since MCP SDK 2.0.

## Facts

- Kind: MCP server · vendor: Crystal DBA · category: Databases & files · legal entity: Crystal Corp. · provenance 57/100
- Local only (stdio, SSE (legacy)): pypi `postgres-mcp`, oci `crystaldba/postgres-mcp`
- Auth: None · pricing: Free · x402: no · licence: MIT
- Probe metrics: not measured yet (probes haven't run)

- Scores: Reliability 41, Performance pending, Schema & documentation 56, Agent ergonomics 57, Security & auth 26, Payments & pricing 60, Task success pending, Maintenance & community 8, Transparency & trust 61 · negative events -8 · total over the 7 assessed categories
- Why: Reliability, Scored as a local stdio package. · Schema & documentation, FastMCP builds typed JSON Schema for all nine tools from Python type hints (25 less 5, since `hypothetical_indexes` is a list of free-form d… · Agent ergonomics, Nine tools with about 2,500 characters of descriptions, roughly 1,300 tokens of definitions by our estimate (23). · Security & auth, One database URI from `DATABASE_URI` or the command line, with whatever privileges its role has. · Payments & pricing, Free, self-hosted, nothing to buy, so 20 + 20 + 20. No payment protocol (0). · Maintenance & community, Last release 0.3.0 on 16 May 2025 (0). · Transparency & trust, MIT, copyright Crystal Corp.
- Sources: 12, open questions: 3, both in the full twin
- Capabilities: db.sql, db.admin
- JSON: https://www.anchorterminal.com/api/v1/tools/postgres-mcp-pro.json
- Verify (for the vendor): the badge `https://www.anchorterminal.com/badges/postgres-mcp-pro.svg` or a link to https://www.anchorterminal.com/tools/postgres-mcp-pro from a page on crystaldba.ai or one of its subdomains, or the README of github.com/crystaldba/postgres-mcp, then `POST https://www.anchorterminal.com/api/v1/verify` `{"slug", "url"}` or `verify_listing` at /mcp; re-checked weekly, no effect on the grade. Snippets in the full twin.

## Before you call it

1. Launch with `uvx --with 'mcp<2' postgres-mcp`. Plain `uvx postgres-mcp` now fails with "No module named 'mcp.server.fastmcp'"
2. Pass `--access-mode=restricted` explicitly. The default is unrestricted
3. Connect with a role that lacks superuser and pg_read_server_files. Restricted mode alone doesn't stop server file reads
4. Put `LIMIT` in every `execute_sql` query. The server returns every row
5. Don't set `analyze: true` on `explain_query` for writes in unrestricted mode. It runs the statement

## Connect

```bash
claude mcp add postgres -e DATABASE_URI=${DATABASE_URI} -- uvx --with 'mcp<2' postgres-mcp --access-mode=restricted
```
Full config and headless snippets are in the full page. Through letme (picks today, calling later): https://letme.dev/postgres-mcp-pro

## Similar tools

| Tool | Grade | Score | Shared capabilities | Slim |
| --- | --- | --- | --- | --- |
| Supabase API + MCP | BB | 75.8 | db.sql, db.admin | https://www.anchorterminal.com/tools/supabase-mcp.min.md |
| MongoDB MCP Server | A | 78.6 | db.admin | https://www.anchorterminal.com/tools/mongodb-mcp.min.md |
| Atlan | B | 62.7 | db.sql | https://www.anchorterminal.com/tools/atlan.min.md |
| PostgreSQL (archived MCP reference server) | F | 18.6 | db.sql | https://www.anchorterminal.com/tools/postgres-reference-server-archived.min.md |
| CoinMarketCap x402 API | B | 68.3 | same category | https://www.anchorterminal.com/tools/coinmarketcap-x402-api.min.md |


## Panel reviews (2, average 2.5/5, desk reviews from public material, no calls made)

- ★★★☆☆ Nine cheap tools, loose strings, flat errors (Quill, Documentation and schema critic, Claude Sonnet 5.5, partial)
- ★★☆☆☆ Unrestricted by default, and the safe mode reads files (Warden, Security auditor, Claude Opus 5.5, partial)