monitoring-database-health
About
This skill enables Claude to monitor PostgreSQL and MySQL database health using real-time metrics and predictive alerts. It detects issues like performance degradation and can trigger automated remediation. Use it when developers need to check database performance, set up alerts, or automate health checks.
Documentation
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
- Initiate Health Check: The user requests a database health check via natural language or the
/health-checkcommand. - 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.
- Analyze and Alert: The collected metrics are analyzed against predefined thresholds and historical data to identify potential issues. Predictive alerts are generated for anomalies.
- 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:
- Connect to the PostgreSQL database.
- Collect metrics on CPU usage, memory consumption, disk I/O, connection counts, and query execution times.
- 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:
- Connect to the MySQL database.
- Configure monitoring to track CPU usage, memory consumption, disk I/O, and connection counts.
- 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.
Quick Install
/plugin add https://github.com/jeremylongshore/claude-code-plugins-plus/tree/main/database-health-monitorCopy and paste this command in Claude Code to install this skill
GitHub 仓库
Related Skills
sglang
MetaSGLang is a high-performance LLM serving framework that specializes in fast, structured generation for JSON, regex, and agentic workflows using its RadixAttention prefix caching. It delivers significantly faster inference, especially for tasks with repeated prefixes, making it ideal for complex, structured outputs and multi-turn conversations. Choose SGLang over alternatives like vLLM when you need constrained decoding or are building applications with extensive prefix sharing.
evaluating-llms-harness
TestingThis Claude Skill runs the lm-evaluation-harness to benchmark LLMs across 60+ standardized academic tasks like MMLU and GSM8K. It's designed for developers to compare model quality, track training progress, or report academic results. The tool supports various backends including HuggingFace and vLLM models.
llamaguard
OtherLlamaGuard is Meta's 7-8B parameter model for moderating LLM inputs and outputs across six safety categories like violence and hate speech. It offers 94-95% accuracy and can be deployed using vLLM, Hugging Face, or Amazon SageMaker. Use this skill to easily integrate content filtering and safety guardrails into your AI applications.
langchain
MetaLangChain is a framework for building LLM applications using agents, chains, and RAG pipelines. It supports multiple LLM providers, offers 500+ integrations, and includes features like tool calling and memory management. Use it for rapid prototyping and deploying production systems like chatbots, autonomous agents, and question-answering services.