Skill Detail
Postgres MCP Pro
Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls.
Data Extraction & TransformationMCP
Data Extraction & Transformation
MCP
Security Reviewed
Security: Moderate
Tool match: postgres-mcp
⭐ 2.8k GitHub stars
MIT license
INSTALL WITH ANY AGENT
npx skills add agentskillexchange/skills --skill postgres-mcp-pro
Works best when you want a reusable capability, not another fragile one-off prompt.
At a glance
Tools required
MCP-compatible client, PostgreSQL database (local or remote), Docker or Python 3.12+
Author
Crystal DBA
Publisher
Company
Last updated
Apr 8, 2026
Quick brief
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.
How it works
What this skill actually does
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.