PostgreSQL Operations
Provides professional, read-only operations and monitoring for PostgreSQL databases, offering performance insights, structure visibility, and configuration details.
About
MCP-PostgreSQL-Ops is a specialized, read-only server designed for comprehensive operations, monitoring, and management of PostgreSQL databases. It offers advanced performance analysis by leveraging `pg_stat_statements` and `pg_stat_monitor` extensions, providing deep insights into slow queries and index usage. Beyond performance, it facilitates structure exploration, capacity management through size analysis, and verification of PostgreSQL configuration parameters, all within a safe, read-only environment.
Key Features
- Capacity management through database and table size analysis.
- Comprehensive PostgreSQL performance analysis with pg_stat_statements and pg_stat_monitor.
- Safe, read-only operations ensuring no data modification.
- Identification of slow queries and analysis of index usage efficiency.
- 1 GitHub stars
- Detailed exploration of database, table, and user structures.
Use Cases
- Analyzing database performance to identify slow queries and optimize index usage.
- Managing database capacity by monitoring sizes and checking maintenance status.
- Conducting PostgreSQL server health checks and monitoring active connections.
Sponsored