database-monitoring

Monitor database performance and health. Use when setting up monitoring, analyzing metrics, or troubleshooting database issues.

By aj-geddes · 450 installs

npx skills add aj-geddes/useful-ai-prompts --skill database-monitoring

Source repository · Upstream listing

Database Monitoring Table of Contents [Overview]( overview) [When to Use]( when to use) [Quick Start]( quick start) [Reference Guides]( reference guides) [Best Practices]( best practices) Overview Implement comprehensive database monitoring for performance analysis, health checks, and proactive alerting. Covers metrics collection, analysis, and troubleshooting strategies. When to Use Performance baseline establishment Real time health monitoring Capacity planning Query performance analysis Resource utilization tracking Alerting rule configuration Incident response and troubleshooting Quick Start Minimal working example: Reference Guides Detailed implementations in the references/ directory: Guide Contents [Connection Monitoring](references/connection monitoring.md) Connection Monitoring [Query Performance Monitoring](references/query performance monitoring.md) Query Performance Monitoring [Table & Index Monitoring](references/table index monitoring.md) Table & Index Monitoring [Performance Schema](references/performance schema.md) Performance Schema [InnoDB Monitoring](references/innodb monitoring.md) InnoDB Monitoring [PostgreSQL Monitoring Setup](references/postgresql monitoring setup.md) PostgreSQL Monitoring Setup [Automated Monitoring Dashboard](references/automated monitoring dashboard.md) Automated Monitoring Dashboard Best Practices ✅ DO Follow established patterns and conventions Write clean, maintainable code Add appropriate documentation Test thoroughly before deploying ❌ DON'T Skip testing or validation Ignore error handling Hard code configuration values