3 ms·

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

6 points by call518 1y ago

MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops) <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"

call518 1y ago
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
deleted 1y ago
[deleted]

6 points by call518 1y ago

call518 1y ago

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

deleted 1y ago

[deleted]