{"repo":"call518/MCP-PostgreSQL-Ops","free":true,"listed":false,"github":"https://github.com/call518/MCP-PostgreSQL-Ops","clone":"git clone https://github.com/call518/MCP-PostgreSQL-Ops.git","description":"🐘 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.","language":"Python","stars":159,"topics":["llm","mcp","mcp-server","monitoring","openwebui","postgresql","database","management","ai","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"MCP Server for PostgreSQL Operations and Monitoring --- Architecture & Internal (DeepWiki) --- Overview MCP-PostgreSQL-Ops is a professional MCP server for PostgreSQL database operations, monitoring, and management. Supports PostgreSQL 12-18 with comprehensive database analysis, performance monitoring, and intelligent maintenance recommendations through natural language queries. Most features work independently, but advanced query analysis capabilities are enhanced when pg stat statements and (optionally) pg stat monitor extensions are installed. --- 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 pg stat statements and pg stat monitor for advanced query analytics. - ✅ Comprehensive Database Monitoring : Performance analysis, bloat detection, and maintenance recommendations. - ✅ Smart Query Analysis : Slow query identification with pg stat statements and pg stat monitor integration. - ✅ Schema & Relationship Discovery : Database structure exploration with detailed relationship mapping. - ✅ VACUUM & Autovacuum Intelligence : Real-time maintenance monitoring and effectiveness analysis. - ✅ Multi-Database Operations : Seamless cross-database analysis and monitoring. - ✅ Enterprise-Ready : Safe read-","default_branch":null,"files":null,"tree":[],"storefront":"/r/call518","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/call518/MCP-PostgreSQL-Ops/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}