skills.rest
jeremylongshore
jeremylongshoreCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

2.6k|379|Updated Oct 10, 2025
Search Tags:#performance#database#PostgreSQL#MySQL#health monitoring#uptime#alerts
One-click install
npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill monitoring-database-health
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: monitoring-database-health
Source: https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/plugins/database/database-health-monitor/skills/database-health-monitor
Command: npx skills add https://github.com/jeremylongshore/claude-code-plugins-plus --skill monitoring-database-health

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This skill empowers Claude to proactively monitor the health of your databases. It provides real-time metrics, predictive alerts, and automated remediation capabilities to ensure optimal performance and uptime for production-grade PostgreSQL and MySQL systems.

Core Features & Use Cases

  • Real-Time Metrics: Collect and analyze connection counts, query performance, resource utilization, and replication status.
  • Predictive Alerts: Generate alerts for anomalies and potential issues before they impact production.
  • Automated Remediation: Receive recommended or automated steps to address identified problems.
  • Use Case: Monitor your MySQL database health and receive an alert if CPU usage exceeds 80%, allowing for proactive intervention.

Quick Start

User request: "Check the health of my PostgreSQL database."

The skill will:

  1. Connect to the PostgreSQL database.
  2. Collect metrics on CPU usage, memory consumption, disk I/O, connection counts, and query execution times.
  3. Analyze the collected data and generate a report highlighting any performance bottlenecks or potential issues.

Frequently Asked Questions about monitoring-database-health

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I monitor PostgreSQL and MySQL database health in production?▼

Monitor database health by collecting real-time metrics on CPU, memory, disk I/O, connection counts, and query latency. Analyze the data to detect performance degradation, identify bottlenecks, and generate alerts before issues impact production uptime.

Can I set up alerts for database performance issues automatically?▼

Yes. Configure threshold-based alerts for metrics like CPU usage exceeding 80% or replication lag. The skill generates predictive alerts for anomalies and potential issues, enabling proactive intervention before performance degrades.

What metrics does database health monitoring collect?▼

Database health monitoring collects connection counts, query execution times, CPU usage, memory consumption, disk I/O rates, and replication status. Historical trend analysis identifies patterns and supports anomaly detection for early problem identification.

Do I need to manually remediate database performance issues?▼

No. The skill provides recommended or automated remediation steps for identified problems. After detecting issues through real-time metrics and trend analysis, you receive actionable remediation actions to address health checks automatically.

Can I monitor database health across multiple databases?▼

Yes. The skill supports production-grade deployments for both PostgreSQL and MySQL systems. Real-time metrics gathering, anomaly detection, and alerting workflows scale across multiple database instances for comprehensive monitoring.

Related Skills

Explore More Software Engineering Skills→
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced
richardadonnellrichardadonnell
45

sentry-create-alert

Create Sentry alerts via the workflow engine API with triggers and notification actions.

Community
Advanced
Impertio-StudioImpertio-Studio
2

mariadb-errors-slow-queries

Diagnose and optimize slow MariaDB queries using logs, EXPLAIN, and performance schema.

Official
Advanced
gfargogfargo

monitoring-setup

Deploy Prometheus, Grafana, and Alertmanager for self-hosted monitoring across VPS stacks.

Community
Advanced