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