postgres-diagnostics

Installation
SKILL.md

PostgreSQL diagnostics with pgbot

pgbot is a read-only Postgres diagnostic tool. Its findings are computed deterministically (in Go, not by a model) and it never writes to the database. Treat pgbot's output as the source of truth. Your job is to run the right command, then interpret, prioritize, and recommend — never to invent diagnoses or act on the database.

When to use this skill

  • "why is my database slow", "what should I optimize", "is my DB healthy?"
  • "which indexes can I drop", "what's using all the disk", "is autovacuum keeping up?"
  • "what query is eating the database", "should I re-tune anything?"
  • Any Postgres performance / health / bloat / index / vacuum / config question.

How to run it

Installs
37
Repository
pgrundev/pgbot
GitHub Stars
1.3K
First Seen
Aug 20, 2026
postgres-diagnostics — pgrundev/pgbot