Stats
Actions
Tags
From role-database
Provides database monitoring, alerting, and observability for PostgreSQL (pg_stat_statements), MySQL (Performance Schema), MongoDB (mongostat), Redis (SLOWLOG). Covers Datadog, Grafana dashboards, metrics, thresholds for troubleshooting and setup.
How this skill is triggered — by the user, by Claude, or both
Slash command
/role-database:database-monitoringThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Load from `references/` based on what's needed:
Load from references/ based on what's needed:
PostgreSQL: pg_stat_statements top queries, pg_stat_activity session view, pg_stat_user_tables bloat, table/index size queries. MySQL: Performance Schema digest analysis, InnoDB status sections, sys schema helpers (full table scans, unused indexes). MongoDB: serverStatus key sections, profiler setup and query, mongostat/mongotop commands. Redis: INFO sections (memory, stats, replication, clients), SLOWLOG, LATENCY, bigkeys, memkeys. Load when: running live diagnostic queries against a specific database engine.
Key metrics tables with alert thresholds for connections, query performance, storage, replication, and cache. Three-tier alert classification (critical/warning/informational) with specific conditions. Monitoring tool comparison (Datadog, PMM, pganalyze, Prometheus+Grafana, Zabbix). Prometheus exporter list for all four engines. Minimum viable database dashboard (8 panels). Load when: setting up monitoring infrastructure, configuring alerts, or building dashboards.
npx claudepluginhub rnavarych/alpha-engineer --plugin role-databaseSets up Grafana Cloud Database Observability for MySQL and PostgreSQL with query-level RED metrics, explain plans, and trace correlation. Use for diagnosing slow queries or connecting DB metrics to APM.
Monitors PostgreSQL, MySQL, MongoDB health via CLI queries for connections, throughput, disk usage, cache ratios, locks, with alerting thresholds and automation guidance.
Monitors transactions in PostgreSQL, MySQL, MongoDB for long-running queries, lock contention, idle sessions, and throughput using CLI queries and scripts.