Show HN: MCP Server for PostgreSQL Monitoring/Operations (MCP-PostgreSQL-Ops)
3 days ago
- #Database Management
- #PostgreSQL
- #Monitoring
- Professional MCP server for PostgreSQL operations, monitoring, and management.
- Advanced performance analysis using pg_stat_statements and pg_stat_monitor extensions.
- Features include PostgreSQL monitoring, structure exploration, performance analysis, capacity management, and configuration retrieval.
- All operations are read-only and safe.
- Environment setup involves configuring PostgreSQL connection information in .env file.
- Install dependencies using uv venv and uv sync.
- Run server with scripts or direct execution for debugging.
- Various commands available for server information, active connections, configuration, database and table lists, user lists, and performance statistics.
- Supports HTTP mode for testing.
- Configuration variables include Python path, logging level, transport protocol, host, port, PostgreSQL version, and connection details.
- Requires PostgreSQL 12+, Python 3.11, network access, and read permissions.
- Quick setup involves adding pg_stat_statements to shared_preload_libraries and creating extensions.
- Example queries for server status, configuration management, performance analysis, and capacity management.
- Troubleshooting tips include checking server status, verifying connection parameters, ensuring network connectivity, and checking user permissions.
- Security features include read-only tools, sensitive information masking, no direct SQL execution, and least privilege principle.