blob: 74d2876309e9ac228e6ae3c0ffcdbe58ae2e29ec (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
pgbot is a single static binary that connects to a PostgreSQL server with
a read-only role, reads the server's own statistics views and prints a
findings-first health report, including what changed since the previous
run. It needs no agent, no external service and no write privilege
anywhere in the path.
Features:
- Checks connections, cache hit ratio, locks, slow and regressed queries,
unused and missing indexes, table bloat, vacuum and replication lag
- Findings are ranked by severity, with a per-database health score
- Snapshots are stored locally so consecutive runs can be diffed
- Versioned --json output with a published JSON Schema, plus SARIF output
for CI integration
- Works as an MCP server so AI agents and applications can query it
- Supports PostgreSQL 14 through 18
pgbot is the diagnostic engine behind pgterm (databases/pgterm).
|
