crystaldba/postgres-mcp

Health v2 · maintenance only

Adoption not part of the score

3226 stars · 370 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

Postgres MCP Pro is an open-source Model Context Protocol (MCP) server that gives AI agents and developers safe, configurable read/write access to PostgreSQL databases. It goes beyond a simple connection wrapper with index tuning, EXPLAIN plan analysis, database health checks, and schema-aware SQL generation.

Use cases

• let AI agents safely query and analyze my postgres database
• tune database indexes for my workload automatically
• analyze slow queries with explain plans and hypothetical indexes
• check postgres health like vacuum, replication lag, and connection usage
• give cursor or claude read-only access to a production database
• generate schema-aware SQL with an AI coding assistant
• fix slow ORM queries in an AI-generated app

When to choose

• you use AI coding agents (Cursor, Claude, etc.) with a PostgreSQL database
• you need safe, configurable SQL execution including read-only mode for production
• you want automated index tuning and query plan analysis
• you need database health diagnostics alongside AI access

When to avoid

• you use MySQL, SQLite, or another non-Postgres database
• you need a general-purpose MCP server unrelated to databases
• you want a GUI database client rather than an MCP server for agents

Facets

service · maturity active

mcp database monitoring benchmarking search-engine databases developer-tools large-language-models performance python self-hosted cli postgres mcp-server index-tuning explain-plans database-health sql-execution ai-agents docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="crystaldba/postgres-mcp")