---
title: "Postgres MCP Pro: review, setup & limitations · Undominated.ai"
canonical: https://undominated.ai/mcp-servers/postgres/
description: "Combines PostgreSQL schema and SQL access with health checks, query plans and index-analysis tools."
---

# Postgres MCP Pro: review, setup & limitations · Undominated.ai

> Combines PostgreSQL schema and SQL access with health checks, query plans and index-analysis tools.

[← Explore all mcp servers](/mcp-servers/)

DATABASE DIAGNOSTICS / Crystal DBA

# Postgres MCP Pro

Combines PostgreSQL schema and SQL access with health checks, query plans and index-analysis tools.

 [See setup guidance ↓](#setup)[Original source ↗](https://github.com/crystaldba/postgres-mcp)

SOURCE REVIEW

 Reviewed 2026-10-14
 Evidence 4 linked sources
 Publisher Crystal DBA
 Licence [MIT ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/LICENSE)
 Revision 15c8e3335354
 [Read what was—and wasn’t—checked ↓](#review)

“Postgres MCP Pro does much more than wrap a database connection.”

 [Crystal DBA · upstream description ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/README.md) Our analysis follows below.

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.
- The pinned README adds index tuning, explain plans, and health checks on top of a Postgres connection, with an explicit restricted mode for production.
- Restricted mode is not a database role: it parses SQL and rejects commit or rollback so a read-only transaction cannot be left.

### A good fit for

 - Investigating slow SQL with schema inspection and execution-plan evidence before changing an index.
- Comparing hypothetical index options with hypopg, then having a database owner review the actual migration.
- Inspecting a Postgres database with read-only SQL, explain plans, and health checks
- Development databases where unrestricted schema changes are acceptable

### Weigh up before choosing

 - The default access mode is unrestricted and allows data/schema changes.
- Restricted mode is not a substitute for PostgreSQL grants, and advanced diagnostics may need optional extensions.
- Restricted mode combines read-only transactions, SQL parsing and execution-time limits. The README identifies unsafe stored-procedure languages as a possible bypass; isolation was not tested.
- Index recommendations need workload evidence. Hypothetical planner estimates do not prove that creating the index improves production performance.
- Unsafe stored-procedure languages can circumvent the read-only parser.
- Index tuning by LLM needs an OpenAI API key, and hypopg may need a separate install.
- The server exposes tools only, not MCP resources.
- A pin does not verify transitive dependencies.
- This review did not execute the resource.
- Restricted mode limits execution time, but this review does not establish CPU, memory or I/O resource isolation.

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 setup, configuration and operating-limit sections at 15c8e33353546148acc2d8bd784551cf3905d1e2
- LICENSE at the same revision
- pyproject.toml
- src/postgres_mcp/server.py
- README.md
- LICENSE
- Round 2 reread of acquired publisher setup and permission evidence; see immutable wave review.

### Our findings

 - The entrypoint defaults to unrestricted mode, so the example explicitly selects restricted.
- The README distinguishes pg_stat_statements workload statistics from hypopg hypothetical indexes and requires Python >=3.12 for the Python path.
- Restricted mode limits the agent to read-only transactions and, at present, an execution-time cap, while unrestricted mode allows data and schema changes.
- The adapter README describes combining read-only transactions with pglast parsing that rejects commit or rollback statements; this is a statement about the adapter protections, not a claim that PostgreSQL lacks session defaults for read-only transactions.
- Those protections can be circumvented if unsafe stored-procedure languages are enabled, and the experimental LLM index tuner does not run without OPENAI_API_KEY.
- The README explicitly identifies unsafe stored procedure languages as a possible route around restricted-mode protections.

### Not established by this review

 - Server startup, authentication and live tool calls were not tested.
- Published package/container parity with the inspected source commit and security isolation were not tested.
- The server was not started and its tools were not called.
- A pin does not verify transitive dependencies.

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.

[Upstream setup instructions ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/README.md)

DOCUMENTED COMMAND

 pipx install postgres-mcp Copy command ↗

Copying does not execute this command. It may retrieve a newer version than the reviewed source.

 - Install with the README's pipx line (the README also gives docker pull crystaldba/postgres-mcp and uv pip install postgres-mcp). It was not run.
- Add the README's Claude Desktop block for your install method and set DATABASE_URI through the client's secret mechanism.
- Replace --access-mode=unrestricted with --access-mode=restricted, as the README says, and use a database role limited to the intended schemas; load pg_stat_statements and hypopg only when needed.

### Before you start

 - Docker, or Python 3.12 or newer with pipx or uv.
- A reachable PostgreSQL database and credentials for it.

### Documented configuration example

Use the client and authentication context described in the setup guidance. Configuration formats vary between hosts.

 {
 "mcpServers": {
 "postgres": {
 "command": "postgres-mcp",
 "args": [
 "--access-mode=unrestricted"
 ],
 "env": {
 "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
 }
 }
 }
} Copy configuration ↗

### Compatibility

An MCP client supporting stdio, SSE, Streamable HTTP. · uv/Python and a reachable PostgreSQL database.

### Implementation

Python

### Transports

stdio · SSE · Streamable HTTP

### Database diagnostics / Configured credentials or local access

 - Reads database metadata, query results and diagnostic information.
- Unrestricted mode can modify database data and schema.

### Cost model

Database hosting and diagnostic-query resource use determine cost.

04 / FOLLOW THE EVIDENCE

## The source trail.

Our notes are separate from the original resource. Check upstream before adopting a new version.

 - [Pinned upstream setup, capabilities and operating limits ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/README.md) Checked 2026-10-14 https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/README.md Supports: summary, upstreamDescription, install, configExample, access, limitations, bestFor, review
- [Licence at the reviewed revision ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/LICENSE) Checked 2026-10-14 https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/LICENSE Supports: license
- [Pinned implementation or package metadata: pyproject.toml ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/pyproject.toml) Checked 2026-10-14 https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/pyproject.toml Supports: review, install, language
- [Pinned implementation or package metadata: src/postgres_mcp/server.py ↗](https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/src/postgres_mcp/server.py) Checked 2026-10-14 https://github.com/crystaldba/postgres-mcp/blob/15c8e33353546148acc2d8bd784551cf3905d1e2/src/postgres_mcp/server.py Supports: review, install, language

KEEP COMPARING

## Other approaches to consider.

Related by category or shared topics. These are alternatives to inspect, not a measured quality order.

 [### AWS IaC MCP Server ↗ Validates CloudFormation templates, retrieves CDK/CloudFormation guidance and investigates failed deployments.](/mcp-servers/aws-iac/)[### AWS Labs OpenAPI MCP ↗ Pins the OpenAPI MCP server that builds tools from an operator-supplied spec and names stdio as the transport.](/mcp-servers/awslabs-openapi/)[### Chroma MCP ↗ Lets an assistant create and query Chroma collections through local, HTTP or Chroma Cloud database connections.](/mcp-servers/chroma/)

 [AI Tools ↗](/tools/)[Skills ↗](/skills/)[Agents ↗](/agents/)[MCP Servers ↗](/mcp-servers/)[Workflows ↗](/workflows/)

## Continue your investigation

 - [Inspect resource evidence](/tools/)
- [Choose a host](/agents/)
- [Inspect reusable workflows](/skills/)
- [Use Undominated data](/api/)
