Pgbot

Overview

pgbot is a lightweight Go command line tool for PostgreSQL observability and diagnostics. It reads PostgreSQL statistics in read only mode to identify health issues, slow or regressed queries, unused indexes, vacuum problems, replication lag and other signals. It stores local baselines to detect changes over time and can expose its deterministic diagnostics through MCP so AI agents can inspect databases without write access.

Key features

• PostgreSQL health diagnostics
• Read only database inspection
• Query and index analysis
• MCP support for AI agents