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.
Tunes max_connections, calculates per-connection memory overhead, and rightsizes PostgreSQL connections for on-premise and serverless deployments.