MCP Servers / database / MCP-PostgreSQL-Ops

MCP-PostgreSQL-Ops

JSON →
stdionone★ 149database

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.

github ↗
Install
How to run this server
[ { "cmd": "uvx (Recommended)", "imports": [] } ]
server path: mcp-postgresql-ops
Tools
What this server exposes
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+)
Configuration
Environment & auth
authnone
envPOSTGRES_HOST
envPOSTGRES_PORT
envFASTMCP_HOST
envFASTMCP_PORT
envREMOTE_SECRET_KEY
Resources
githubhttps://github.com/call518/MCP-PostgreSQL-Ops ↗
MCP-PostgreSQL-Ops — MCP Server · libregistry