AI product Open source
pgbot is a read-only PostgreSQL observability and health-diagnosis tool for AI agents, applications, and operators. A static binary connects to PostgreSQL, reads the database's own statistics views, and produces deterministic, findings-first health reports, including a health score, critical/warning/note findings, verified healthy subsystems, and change information from local baselines. It provides focused commands for indexes, queries, tables, and vacuum, along with versioned JSON output for agents and scripts and an MCP mode. Its optional ask and explain commands add an AI interpretation of the same findings; inspection and database queries otherwise require no model key or external service. The project is in beta and uses a read-only pg_monitor role with session-level read-only, statement, and lock timeouts as additional safeguards.
2 uses taken from transcripts — each links to the moment in the video.
Diagnoses PostgreSQL using its own statistics without installing an agent or requesting write access. It produces deterministic health findings, stores baselines, tracks changes, and exposes JSON and MCP modes.
Provides delegated PostgreSQL diagnostics for pgterm.
2 in the library.