MCP-PostgreSQL-Ops

Tools · 14

• Show slow queries Identify slow queries using pg_stat_statements and pg_stat_monitor integration
• Analyze table bloat Detect and analyze table bloat for maintenance recommendations
• Database performance analysis Comprehensive database monitoring and performance analysis
• Schema discovery Explore database structure with detailed relationship mapping
• VACUUM monitoring Real-time maintenance monitoring and effectiveness analysis
• Multi-database analysis Seamless cross-database analysis and monitoring
• Connection monitoring Real-time connection and lock monitoring
• Background process analysis Background process and checkpoint analysis
• Replication monitoring Replication status and WAL monitoring
• Database capacity analysis Database capacity and bloat analysis
• Wait event analysis Wait event catalog with descriptions (PG 17+)
• WAL summarizer monitoring WAL summarizer monitoring for incremental backups (PG 17+)
• Async I/O monitoring Async I/O subsystem monitoring (PG 18+)
• Per-backend I/O statistics Per-backend I/O and WAL statistics (PG 18+)