MCP-PostgreSQL-Ops

Was er kann

A community MCP server for watching and diagnosing a PostgreSQL server, covering versions 12 to 18. Instead of running arbitrary SQL, it maps questions to a fixed set of read-only queries about active and blocked sessions, slow queries, table bloat, vacuum and autovacuum, unused indexes, replication, WAL, checkpoints, database size and I/O, and it can draw schema relationships. Core tools need no extensions; pg_stat_statements or pg_stat_monitor add query statistics. It runs locally over stdio, as a Claude Desktop extension or with uvx, or as a Streamable HTTP server in Docker for OpenWebUI. The author advises a least-privilege monitoring role.

Funktionen

Details