database-monitoring

What problem does it solve?

This Skill helps teams implement robust database monitoring to detect performance issues, track health, and automate alerting for PostgreSQL and MySQL environments.

Core Features & Use Cases

• Query performance monitoring: Identify slow queries, optimize execution, and monitor critical workloads.
• Connection and health checks: Track active connections, idle transactions, and replication health to maintain service levels.
• Table & index health analysis: Assess table sizes, dead tuples, and index usage to prevent bloat and degradation.
• Alerts & baseline planning: Design starter alerting rules and health checks aligned with SLAs.
• Use Case: Imagine you run a PostgreSQL cluster with rising latency; this skill guides you to instrument metrics, inspect top queries, and configure alerts to catch regressions early.

Quick Start

Set up baseline metrics collection for a PostgreSQL server and create starter alert rules for high connections and long-running queries.