Monitoring Database Health
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.
Install
/plugin marketplace add jeremylongshore/claude-code-plugins-plus-skills
/plugin install database-health-monitor@claude-code-plugins-plusRun these inside Claude Code. The skill comes with its plugin.
What this skill does
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".
Trigger phrases
Claude loads this skill automatically when you say things like:
How it works
- 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 it
- Check the current health status of a database.
- Monitor database performance for potential bottlenecks.
- Receive alerts about potential database issues before they impact production.
Best practices
- 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.
Details
- Skill name
monitoring-database-health- Plugin
- database-health-monitor
FAQ
What does the Monitoring Database Health skill do?
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".
How do I install the Monitoring Database Health skill?
Claude Code plugin: /plugin marketplace add jeremylongshore/claude-code-plugins-plus-skills then /plugin install database-health-monitor@claude-code-plugins-plus. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Related skills
000 Jeremy Content Consistency Validator
jeremylongshore/claude-code-plugins-plus-skills
Validates messaging consistency across website, GitHub repositories, and local documentation. Generates comprehensive read-only discrepancy reports showing where messaging conflicts or inconsistencies exist. Activates when user mentions "consistency check", "validate documentation", "check for mixed messaging", "audit content consistency", or before updating internal paperwork.
001 Jeremy Taskwarrior Integration
jeremylongshore/claude-code-plugins-plus-skills
Enforces complete Taskwarrior integration protocol for ALL coding tasks. Activates automatically when user mentions "taskwarrior", "task warrior", "tw", or discusses task management. Decomposes all coding work into properly tracked Taskwarrior tasks with full lifecycle: task add → task start → implementation → task done. Integrates with Timewarrior for automatic time tracking.
Adapting Transfer Learning Models
jeremylongshore/claude-code-plugins-plus-skills
This skill automates the adaptation of pre-trained machine learning models using transfer learning techniques. It is triggered when the user requests assistance with fine-tuning a model, adapting a pre-trained model to a new dataset, or performing transfer learning. It analyzes the user's requirements, generates code for adapting the model, includes data validation and error handling, provides performance metrics, and saves artifacts with documentation. Use this skill when you need to leverage existing models for new tasks or datasets, optimizing for performance and efficiency.
Monitoring Database Transactions
jeremylongshore/claude-code-plugins-plus-skills
This skill enables Claude to monitor database transactions for performance and lock issues using the database-transaction-monitor plugin. It is triggered when the user requests transaction monitoring, lock detection, or rollback rate analysis for databases. Use this skill when the user mentions "monitor database transactions," "detect long-running transactions," "identify lock contention," "track rollback rates," or asks about "transaction anomalies." The skill leverages the `/txn-monitor` command to provide real-time alerts and insights into database health.
Managing Database Sharding
jeremylongshore/claude-code-plugins-plus-skills
This skill assists with managing database sharding strategies. It is activated when the user needs to implement horizontal database sharding to scale beyond single-server limitations. The skill supports designing sharding strategies, distributing data across multiple database instances, and implementing consistent hashing, automatic rebalancing, and cross-shard query coordination. Use this skill when the user mentions "database sharding", "sharding implementation", "scale database", or "horizontal partitioning". The plugin helps design and implement sharding for high-scale applications.
Optimizing Database Connection Pooling
jeremylongshore/claude-code-plugins-plus-skills
This skill optimizes database connection pooling for enhanced performance and resource management. It is activated when the user requests assistance with connection pooling, database performance tuning, or connection lifecycle management. Use this skill to implement and configure connection pools in various programming languages, identify optimal pool settings, and troubleshoot common connection-related issues. The skill is triggered by phrases like "connection pooling," "optimize database connections," or "improve database performance with connection pool.
Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.