Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From role-database
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.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseHow this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:performance-diagnosticsThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
1. **Identify the symptom**: Slow queries? High CPU? Connection exhaustion? Lock waits?
Analyzes slow queries in PostgreSQL, MySQL, MongoDB using EXPLAIN plans, buffer stats, index usage to detect sequential scans, missing indexes, and recommend optimizations.
Analyzes slow queries, execution plans, and designs index/schema optimizations for PostgreSQL and MySQL.
Optimizes database queries and improves performance across PostgreSQL and MySQL systems. Analyzes slow queries, execution plans, and designs index strategies, query rewrites, and configuration tuning.
Share bugs, ideas, or general feedback.
Load from references/ based on what's needed:
PostgreSQL: pg_stat_statements top queries, EXPLAIN ANALYZE BUFFERS, lock wait query, deadlock detection, bloat estimation, wait event analysis, auto_explain config. MySQL: InnoDB buffer pool hit ratio, row lock stats, SHOW ENGINE INNODB STATUS, Performance Schema query digest, optimizer trace. Load when: diagnosing performance issues in PostgreSQL or MySQL.
MongoDB: profiler setup, explain executionStats, currentOp kill long-running operations. Redis: latency measurement, memory analysis (bigkeys, MEMORY DOCTOR), SLOWLOG configuration. Common issues/fixes table covering CPU, I/O, locks, deadlocks, connections, memory, replication, disk. pgbench, sysbench, redis-benchmark usage. Load when: diagnosing MongoDB/Redis issues or running performance benchmarks.