jeremylongshore

Monitoring Database Health

@jeremylongshore/Monitoring Database Health
jeremylongshore
1,004
123 forks
Updated 1/18/2026
View on GitHub

This skill enables Claude to monitor database health using real-time metrics, predictive alerts, and automated remediation. It's designed for production-grade database health monitoring for PostgreSQL and MySQL, detecting performance degradation, resource exhaustion, and replication issues. Use this skill when the user requests to monitor database health, check database performance, receive database alerts, or automate database remediation. The skill is triggered by phrases like "check database health", "monitor database performance", "database health check", or "/health-check".

Installation

$skills install @jeremylongshore/Monitoring Database Health
Claude Code
Cursor
Copilot
Codex
Antigravity

Details

Repositoryjeremylongshore/claude-code-plugins-plus-skills
Pathbackups/plugin-enhancements/plugin-backups/database-health-monitor_20251020_054050/skills/skill-adapter/SKILL.md
Branchmain
Scoped Name@jeremylongshore/Monitoring Database Health

Usage

After installing, this skill will be available to your AI coding assistant.

Verify installation:

skills list

Skill Instructions

name: Monitoring Database Health description: | This skill enables Claude to monitor database health using real-time metrics, predictive alerts, and automated remediation. It's designed for production-grade database health monitoring for PostgreSQL and MySQL, detecting performance degradation, resource exhaustion, and replication issues. Use this skill when the user requests to monitor database health, check database performance, receive database alerts, or automate database remediation. The skill is triggered by phrases like "check database health", "monitor database performance", "database health check", or "/health-check".

Overview

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.

How It Works

  1. Initiate Health Check: The user requests a database health check via natural language or the /health-check command.
  2. Collect Metrics: The plugin gathers real-time metrics from the specified database (PostgreSQL or MySQL), including connection counts, query performance, resource utilization, and replication status.
  3. Analyze and Alert: The collected metrics are analyzed against predefined thresholds and historical data to identify potential issues. Predictive alerts are generated for anomalies.
  4. Provide Report: A comprehensive health report is provided, detailing the current status, potential issues, and recommended remediation steps.

When to Use This Skill

This skill activates when you need to:

  • Check the current health status of a database.
  • Monitor database performance for potential bottlenecks.
  • Receive alerts about potential database issues before they impact production.

Examples

Example 1: Checking Database Performance

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.

Example 2: Setting Up Monitoring for a MySQL Database

User request: "Monitor the health of my MySQL database and alert me if CPU usage exceeds 80%."

The skill will:

  1. Connect to the MySQL database.
  2. Configure monitoring to track CPU usage, memory consumption, disk I/O, and connection counts.
  3. Set up an alert that triggers if CPU usage exceeds 80%.

Best Practices

  • Database Credentials: Ensure that the plugin has the necessary credentials to access the database.
  • Alert Thresholds: Customize alert thresholds to match the specific needs of your application and infrastructure.
  • Regular Monitoring: Schedule regular health checks to proactively identify and address potential issues.

Integration

This skill can be integrated with other monitoring and alerting tools to provide a comprehensive view of your infrastructure's health.

More by jeremylongshore

View all
rabbitmq-queue-setup
1,004

Rabbitmq Queue Setup - Auto-activating skill for Backend Development. Triggers on: rabbitmq queue setup, rabbitmq queue setup Part of the Backend Development skill category.

model-evaluation-suite
1,004

evaluating-machine-learning-models: This skill allows Claude to evaluate machine learning models using a comprehensive suite of metrics. It should be used when the user requests model performance analysis, validation, or testing. Claude can use this skill to assess model accuracy, precision, recall, F1-score, and other relevant metrics. Trigger this skill when the user mentions "evaluate model", "model performance", "testing metrics", "validation results", or requests a comprehensive "model evaluation".

neural-network-builder
1,004

building-neural-networks: This skill allows Claude to construct and configure neural network architectures using the neural-network-builder plugin. It should be used when the user requests the creation of a new neural network, modification of an existing one, or assistance with defining the layers, parameters, and training process. The skill is triggered by requests involving terms like "build a neural network," "define network architecture," "configure layers," or specific mentions of neural network types (e.g., "CNN," "RNN," "transformer").

oauth-callback-handler
1,004

Oauth Callback Handler - Auto-activating skill for API Integration. Triggers on: oauth callback handler, oauth callback handler Part of the API Integration skill category.