Show HN: MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops)(github.com)
github.com
Show HN: MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops)
https://github.com/call518/MCP-PostgreSQL-Ops
2 comments
Features
Version Compatibility: Transparent PostgreSQL version support (12-17) - automatically detects your PostgreSQL version and adapts functionality accordingly with zero configuration
PostgreSQL Monitoring: Performance analysis based on pg_stat_statements and pg_stat_monitor with full backward compatibility
Structure Exploration: Database, table, and user listing with detailed schema information
Schema Analysis: Detailed table structure with columns, constraints, indexes, and relationships
Performance Analysis: Slow query identification and index usage analysis with version-aware query optimization
Capacity Management: Database and table size analysis
Bloat Analysis: Table bloat monitoring and dead tuple analysis with maintenance recommendations
VACUUM/Autovacuum Analysis: Comprehensive maintenance operation monitoring, effectiveness analysis, and real-time status tracking
Configuration Retrieval: PostgreSQL configuration parameter verification
Database Performance Statistics: Comprehensive transaction, I/O, and buffer cache analysis
I/O Performance Monitoring: Version-aware I/O statistics (comprehensive on PG16+, basic on PG12-15)
Background Process Monitoring: Version-aware checkpoint and background writer analysis (split on PG15+)
Table Statistics Monitoring: Version-aware comprehensive table usage and maintenance statistics (enhanced vacuum tracking on PG13+)
Replication Monitoring: Standby server conflict detection and replication lag analysis with version-compatible WAL status tracking
Function Performance Analysis: User-defined function execution statistics
Query Performance Analysis: Version-compatible pg_stat_statements integration (PG12: total_time mapping, PG13+: native columns)
Safe Read-Only: All operations are read-only and safe
Easy Customization: Simple and clean codebase makes it very easy to add new tools or customize existing ones
Version Compatibility: Transparent PostgreSQL version support (12-17) - automatically detects your PostgreSQL version and adapts functionality accordingly with zero configuration
PostgreSQL Monitoring: Performance analysis based on pg_stat_statements and pg_stat_monitor with full backward compatibility
Structure Exploration: Database, table, and user listing with detailed schema information
Schema Analysis: Detailed table structure with columns, constraints, indexes, and relationships
Performance Analysis: Slow query identification and index usage analysis with version-aware query optimization
Capacity Management: Database and table size analysis
Bloat Analysis: Table bloat monitoring and dead tuple analysis with maintenance recommendations
VACUUM/Autovacuum Analysis: Comprehensive maintenance operation monitoring, effectiveness analysis, and real-time status tracking
Configuration Retrieval: PostgreSQL configuration parameter verification
Database Performance Statistics: Comprehensive transaction, I/O, and buffer cache analysis
I/O Performance Monitoring: Version-aware I/O statistics (comprehensive on PG16+, basic on PG12-15)
Background Process Monitoring: Version-aware checkpoint and background writer analysis (split on PG15+)
Table Statistics Monitoring: Version-aware comprehensive table usage and maintenance statistics (enhanced vacuum tracking on PG13+)
Replication Monitoring: Standby server conflict detection and replication lag analysis with version-compatible WAL status tracking
Function Performance Analysis: User-defined function execution statistics
Query Performance Analysis: Version-compatible pg_stat_statements integration (PG12: total_time mapping, PG13+: native columns)
Safe Read-Only: All operations are read-only and safe
Easy Customization: Simple and clean codebase makes it very easy to add new tools or customize existing ones
[deleted]
<Examples Queries> "Check PostgreSQL server status" "Check PostgreSQL server version and connection status" "Verify if extensions are installed" "Show current active connection count" "Show the shared_buffers configuration" "Show PostgreSQL configuration parameter for shared_buffers" "Find all memory-related configuration settings" "Show logging configuration parameters" "Display connection-related settings" "Find all timeout configurations" "Show all PostgreSQL configuration parameters" "Show top 10 slowest queries" "Show top 20 slowest queries" "Analyze slow queries in specific database" "Find unused indexes" "Analyze recent query activity" "Check index efficiency in specific database" "Check database sizes" "Find largest tables" "Show tables that need VACUUM" "Check table sizes in specific database schema" "List tables in specific database" "Check maintenance status in specific database"