DATABASE DIAGNOSTICS / Crystal DBA
Postgres MCP Pro
Combines PostgreSQL schema and SQL access with health checks, query plans and index-analysis tools.
“Postgres MCP Pro does much more than wrap a database connection.”
01 / THE REASONING
Why this made the selection.
- Provides database-health and query-plan tools in addition to generic SQL access.
- The restricted access mode is implemented separately from unrestricted execution.
02 / THE REVIEW RECORD
What we actually inspected.
Source review has boundaries.
A clear record is more useful than a “safe” badge.
Material inspected
- README.md (installation, capability and permission sections)
- pyproject.toml
- src/postgres_mcp/server.py
- LICENSE
Our findings
- The entrypoint defaults to unrestricted mode; the command below explicitly selects the documented restricted replacement.
- Restricted execution uses a separate SQL driver and timeout; no query execution or isolation test was performed here.
Not established by this review
- Server startup, authentication and tool execution were not tested.
The review applies to the material and revision named here. A newer upstream release can change its behavior.
03 / PUT IT TO WORK
Connect a server deliberately.
DOCUMENTED COMMAND
uvx postgres-mcp --access-mode=restrictedCopying does not execute this command. It may retrieve a newer version than the reviewed source.
- Configure DATABASE_URI through the client’s secret mechanism.
- Keep restricted mode and use a database role limited to the intended schemas; enable diagnostic extensions only when needed.
Before you start
- uv/Python and a reachable PostgreSQL database.
04 / FOLLOW THE EVIDENCE
The source trail.
Our notes are separate from the original resource.
Check upstream before adopting a new version.
- Official documentation ↗Checked
https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/README.md
Supports: summary, whySelected, bestFor, limitations, install, access, compatibility, transports
- Applicable source licence ↗Checked
https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/LICENSE
Supports: license
https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/pyproject.toml
Supports: language, review
https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/src/postgres_mcp/server.py
Supports: language, review