PostgreSQL MCP Server
PostgreSQL database health, index tuning, and schema analysis for AI agents.
Data last scanned yesterday · Reviewed today
Overview
Postgres MCP Pro facilitates database management by providing AI agents with deep insights into PostgreSQL internals. The server assists with performance optimization by offering index tuning recommendations, analyzing EXPLAIN plans, and simulating the impact of hypothetical schema changes on query performance. Beyond performance tuning, the tool provides health monitoring for production environments, including metrics for replication lag, vacuum health, and sequence limits. It supports both stdio and SSE transport protocols, allowing for flexible integration across various development and deployment workflows.
Our verdict
With a security score of 44/100, this server is classified as high risk. The rating reflects that it is community-maintained rather than vendor-official and its authentication, read-only mode, and OAuth implementations remain unreviewed. Users should exercise caution and ensure they have validated the tool's access controls before deploying it in sensitive database environments.
- Analyzes index health and database replication lag
- Provides context-aware SQL generation based on schema
- Zero direct dependencies minimize supply chain surface area
- Supports both stdio and SSE transport protocols
- Community-maintained status lacks formal vendor verification
- Authentication and read-only modes are currently unreviewed
- Repository has not received commits in over 180 days
Compatibility
No compatibility data yet.
Badge
Maintain this server? Add the live badge to your README.