Skip to content
Kitbay
Submit
MCP server

MCP-PostgreSQL-Ops

Runs locallyMITUpdated on Nov 11, 2026164GitHub starsNeeds an API key

A community MCP server for watching and diagnosing a PostgreSQL server, covering versions 12 to 18.

InstallRepository Checked on Nov 12, 2026

What it does

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.

Capabilities

  • Show active connections and blocked sessions
  • Find the queries using the most execution time
  • Detect table bloat and vacuum needs
  • Find unused or inefficient indexes
  • Check replication, WAL and checkpoint status

Other MCP servers and skills for PostgreSQL