MCP-PostgreSQL-Ops MCP server
🐘 Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, lock/deadlock monitoring, autovacuum & schema inspection. No extensions required. PG 12-18.
What MCP-PostgreSQL-Ops does
Summarised from the project README; check the repository for the latest details.
Features
- ✅ Zero Configuration: Works with PostgreSQL 12-18 out-of-the-box with automatic version detection.
- ✅ Natural Language: Ask questions like "Show me slow queries" or "Analyze table bloat."
- ✅ Production Safe: Read-only operations, RDS/Aurora compatible with regular user permissions.
- ✅ Extension Enhanced: Optional `pgstatstatements` and `pgstatmonitor` for advanced query analytics.
- ✅ Comprehensive Database Monitoring: Performance analysis, bloat detection, and maintenance recommendations.
- ✅ Smart Query Analysis: Slow query identification with `pgstatstatements` and `pgstatmonitor` integration.
Requirements
- `pgstatstatements` is required only for slow query analysis tools.
- `pgstatmonitor` is optional and used for real-time query monitoring.
- All other tools work without these extensions.
- PostgreSQL 12+ (tested with PostgreSQL 17 and 18)
- Python 3.12
Repository: call518/MCP-PostgreSQL-Ops
Website: https://deepwiki.com/call518/MCP-PostgreSQL-Ops
Stars: ★160
Language: Python
Last updated: 2026-10-09
agentagentic-aiaiclaudedatabasedatabase-toolsdbafastmcpllmmanagementmcpmcp-servermonitoringopenwebuiperformance-monitoringpostgrespostgresqlpostgresql-diagnosticspythonsql
Website: https://deepwiki.com/call518/MCP-PostgreSQL-Ops
Stars: ★160
Language: Python
Last updated: 2026-10-09
agentagentic-aiaiclaudedatabasedatabase-toolsdbafastmcpllmmanagementmcpmcp-servermonitoringopenwebuiperformance-monitoringpostgrespostgresqlpostgresql-diagnosticspythonsql
How to install MCP-PostgreSQL-Ops
No install config was found in this README. See the repository for setup steps, then follow our guides for Claude Desktop, Cursor or VS Code.
Featured in: Best MCP servers for PostgreSQL
Listed on Socketlist – add this badge to your README:
Maintain this project? Get it featured for free during launch →
Compare with codebase-memory-mcp →
Related Databases MCP servers
codebase-memory-mcp by DeusData · ★46608
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases
High-performance code intelligence MCP server. Indexes codebases into a persistent knowledge graph — average repo in milliseconds. 158 langu
Databases
nightingale by ccfos · ★13352
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases
Open-source, self-hosted alerting for metrics, logs, and databases. Includes a built-in AI agent and MCP server.
Databases
code-graph-rag by vitali87 · ★5258
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases
The ultimate RAG for your monorepo. Query, understand, and edit multi-language codebases with the power of AI and knowledge graphs
Databases
Weekly MCP digest – new and trending MCP servers in your inbox.