Database Health Monitor Skill for PostgreSQL Sampling
Use PostgreSQL statistics to compare connection utilization, database size, and rollback rates across sampling intervals.
中文Install in Claude Code
Use your test database, psql, and access to the relevant statistics views. The example uses two adjacent snapshots.
- Get the complete `plugins/database/database-health-monitor/skills/monitoring-database-health` directory from the pinned GitHub commit.
- Copy it into the target project's `.claude/skills/`. Check `.claude/skills/monitoring-database-health/SKILL.md`, start Claude Code at the project root, and call `/monitoring-database-health`.
Example task
Start with 20 commits and 2 rollbacks, then sample 29 commits and 3 rollbacks. Compute interval commits, rollbacks, and the rollback share of all transactions.What to check
The interval has nine commits and one rollback for a 10% rollback share. The report also records connection counts and scope.
Original SKILL.md on GitHub · Updated
Frequently asked question
Can cumulative counters reveal an issue that just happened?
Compare consecutive snapshots for an interval-specific measure and rebuild the baseline after a statistics reset.