Show HN: MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops)

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