{"slug":"github-com-call518-mcp-postgresql-ops","name":"MCP-PostgreSQL-Ops","description":"MCP-PostgreSQL-Ops is a professional MCP server for PostgreSQL database operations, monitoring, and management. Supports PostgreSQL 12-17 with comprehensive database analysis, performance monitoring, and intelligent maintenance recommendations through natural language queries.","category":"database","tags":[],"official":false,"stars":149,"transport":"stdio","install":[{"cmd":"uvx (Recommended)","imports":[]}],"tools":[{"name":"Show slow queries","description":"Identify slow queries using pg_stat_statements and pg_stat_monitor integration"},{"name":"Analyze table bloat","description":"Detect and analyze table bloat for maintenance recommendations"},{"name":"Database performance analysis","description":"Comprehensive database monitoring and performance analysis"},{"name":"Schema discovery","description":"Explore database structure with detailed relationship mapping"},{"name":"VACUUM monitoring","description":"Real-time maintenance monitoring and effectiveness analysis"},{"name":"Multi-database analysis","description":"Seamless cross-database analysis and monitoring"},{"name":"Connection monitoring","description":"Real-time connection and lock monitoring"},{"name":"Background process analysis","description":"Background process and checkpoint analysis"},{"name":"Replication monitoring","description":"Replication status and WAL monitoring"},{"name":"Database capacity analysis","description":"Database capacity and bloat analysis"},{"name":"Wait event analysis","description":"Wait event catalog with descriptions (PG 17+)"},{"name":"WAL summarizer monitoring","description":"WAL summarizer monitoring for incremental backups (PG 17+)"},{"name":"Async I/O monitoring","description":"Async I/O subsystem monitoring (PG 18+)"},{"name":"Per-backend I/O statistics","description":"Per-backend I/O and WAL statistics (PG 18+)"}],"env_vars":["POSTGRES_HOST","POSTGRES_PORT","FASTMCP_HOST","FASTMCP_PORT","REMOTE_SECRET_KEY"],"auth_type":"none","github":"https://github.com/call518/MCP-PostgreSQL-Ops","homepage":"","server_url":"","status":"active","source":"mcpservers.org","updated_at":"Thu May 28"}