Stats
Actions
Tags
'%20stop-opacity%3D'0.16'%2F%3E%3Cstop%20offset%3D'1'%20stop-color%3D'rgb(200%2C90%2C60)'%20stop-opacity%3D'0.03'%2F%3E%3C%2FlinearGradient%3E%3C%2Fdefs%3E%3Crect%20width%3D'320'%20height%3D'200'%20fill%3D'url(%23g)'%2F%3E%3Ccircle%20cx%3D'250'%20cy%3D'56'%20r%3D'92'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.06'%2F%3E%3Ccircle%20cx%3D'64'%20cy%3D'172'%20r%3D'58'%20fill%3D'rgb(200%2C90%2C60)'%20fill-opacity%3D'0.05'%2F%3E%3C%2Fsvg%3E)
From postgres
Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion. Use when the database is unresponsive, connections are refused, or queries are stuck waiting.
How this skill is triggered — by the user, by Claude, or both
Slash command
/postgres:connection-debugThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Workflow:
Workflow:
npx claudepluginhub abiswas97/bonboncinnabon --plugin postgresTroubleshoots 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.
Audits connections, calculates pool sizes, configures app-level pooling params, and deploys PgBouncer/ProxySQL for PostgreSQL/MySQL to prevent exhaustion and boost throughput.
Provides deep PostgreSQL operational guidance for MVCC, autovacuum, WAL/checkpoints, replication, PgBouncer, deadlock diagnosis, and pg_stat_statements triage. Loads when tuning or diagnosing incidents, not for query writing.