database-monitoring

What it does

This skill enables AI agents to actively query and analyze database health metrics, allowing them to detect performance bottlenecks or data integrity issues in real-time. It provides the capability to execute diagnostic queries that return specific status indicators for system stability.

When to use it

• Investigating sudden latency spikes in application response times by correlating them with database load.
• Performing routine health checks on production environments before scheduled deployments.
• Diagnosing connection pool exhaustion or lock contention during high-traffic periods.
• Validating data consistency after complex batch processing jobs complete.

Key capabilities

• Executes real-time diagnostic queries against database instances.
• Retrieves current system metrics such as CPU usage, memory consumption, and active connections.
• Identifies specific error logs or warning states within the database engine.
• Compiles analysis results into a readable format for immediate operator review.

Example prompts

• "Check the current connection count and query execution time on the primary production database."
• "Run a diagnostic scan to identify any active table locks or long-running transactions."
• "Analyze the latest error logs and summarize any critical warnings related to disk I/O performance."

Tips & gotchas

Ensure the AI agent has appropriate read-only permissions configured before enabling this skill to prevent accidental data modification. For best results, specify the exact database instance name in your prompt if your environment hosts multiple clusters.