MCP Servers / database / Postgres MCP Pro

Postgres MCP Pro

JSON →
stdionone★ 2,813database

An MCP server for PostgreSQL providing index tuning, explain plans, health checks, and safe SQL execution.

github ↗
Install
How to run this server
[ { "cmd": "pip install postgres-mcp", "imports": [] } ]
server path: postgres-mcp-pro
Tools
What this server exposes
Database Health
Analyze index health, connection utilization, buffer cache, vacuum health, sequence limits, replication lag, and more.
Index Tuning
Explore thousands of possible indexes to find the best solution for your workload, using industrial-strength algorithms.
Query Plans
Validate and optimize performance by reviewing EXPLAIN plans and simulating the impact of hypothetical indexes.
Schema Intelligence
Context-aware SQL generation based on detailed understanding of the database schema.
Safe SQL Execution
Configurable access control, including support for read-only mode and safe SQL parsing, making it usable for both development and production.
Configuration
Environment & auth
authnone
envOPENAI_API_KEY
Resources
githubhttps://github.com/crystaldba/postgres-mcp ↗
Postgres MCP Pro — MCP Server · libregistry