Help us improve
Share bugs, ideas, or general feedback.
From postgres
Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.
npx claudepluginhub abiswas97/bonboncinnabon --plugin postgresHow this skill is triggered — by the user, by Claude, or both
Slash command
/postgres:database-healthThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Run the diagnose_database MCP tool to get a composite health assessment.
Monitors PostgreSQL, MySQL, MongoDB health via CLI queries for connections, throughput, disk usage, cache ratios, locks, with alerting thresholds and automation guidance.
Troubleshoots database performance across PostgreSQL, MySQL, MongoDB, Redis using pg_stat_statements, EXPLAIN ANALYZE, Performance Schema, SLOWLOG, and benchmarks like pgbench, sysbench. For slow queries, locks, deadlocks, I/O, memory issues.
Analyzes slow queries in PostgreSQL, MySQL, MongoDB using EXPLAIN plans, buffer stats, index usage to detect sequential scans, missing indexes, and recommend optimizations.
Share bugs, ideas, or general feedback.
Run the diagnose_database MCP tool to get a composite health assessment.
Interpret results by status:
If slow queries appear in results, offer to run get_slow_queries for deeper analysis. If connection issues appear, offer to run get_connections for per-connection detail. If pg_stat_statements is not installed, suggest enabling it for slow query visibility.