How do I trigger a health check?

You can use natural language phrases like 'check database health' or use the specific command '/health-check' to initiate the monitoring process.

Which databases does this skill support?

This skill currently supports production-grade monitoring and health checks for PostgreSQL and MySQL databases.

Can Claude automatically fix database issues?

Yes, the skill includes automated remediation capabilities designed to address common performance bottlenecks and resource exhaustion issues.

Does this skill require database credentials?

Yes, for the skill to function properly, Claude must have the necessary access credentials to the target database environment via the local bash tools.

What specific metrics does the monitor track?

It tracks connection counts, query execution times, CPU usage, memory consumption, disk I/O, and replication status.

Database Health Monitor

Name: Database Health Monitor
Author: BbgnsurfTech

byBbgnsurfTech

•

Analytics & Monitoring

Monitors PostgreSQL and MySQL health using real-time metrics, predictive alerts, and automated remediation workflows.

This skill equips Claude with the ability to proactively manage database infrastructure by analyzing performance metrics, resource utilization, and replication status. It supports production-grade monitoring for PostgreSQL and MySQL, offering predictive alerts for potential bottlenecks and automated steps for remediation. Ideal for DevOps engineers and database administrators, it simplifies complex health audits through natural language commands or the /health-check trigger, ensuring high availability and optimal database performance for critical applications.

Key Features

01Replication status tracking and anomaly detection

02Automated remediation steps for common performance bottlenecks

033 GitHub stars

04Predictive alerting based on historical data and predefined thresholds

05Real-time metrics collection for PostgreSQL and MySQL databases

06Comprehensive reporting on CPU, memory, disk I/O, and connection counts

Use Cases

01Identifying slow-running queries and performance bottlenecks in real-time

02Performing on-demand health audits of production databases via terminal

03Setting up automated alerts for resource exhaustion such as high CPU or memory

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-health-monitor

For use in Claude.ai and ChatGPT

Download Skill