Skill Detail

Postgres MCP Pro

Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls.

Data Extraction & TransformationMCP

Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls.

Data Extraction & Transformation MCP Security Reviewed Security: Moderate

INSTALL WITH ANY AGENT

npx skills add agentskillexchange/skills --skill postgres-mcp-pro Copy

View source

Tools required

MCP-compatible client, PostgreSQL database (local or remote), Docker or Python 3.12+

Author

Crystal DBA

Publisher

Company

Postgres MCP Pro is an open-source MCP server by Crystal DBA that goes beyond wrapping a database connection. It provides deep database intelligence including index tuning, EXPLAIN plan analysis, health diagnostics, and configurable access controls.

Best for

Running queries with configurable read-only or full-access modes
Diagnosing database performance problems with EXPLAIN plan analysis
Getting industrial-strength index tuning recommendations
Monitoring database health: connection utilization, buffer cache, vacuum health, replication lag

Access modes

Three modes: read-only (safe for production monitoring), restricted (allows writes with SQL parsing), and unrestricted (full access for development).

Install notes

Pull the Docker image: docker pull crystaldba/postgres-mcp. Or install via pip: pipx install postgres-mcp. Configure in your MCP client with your database URI and desired access mode. Supports both stdio and SSE transports.

Source: github.com/crystaldba/postgres-mcp