dbcheck

What problem does it solve?

DBAs and operators need a fast, repeatable way to inspect database health across multiple engines and quickly turn raw metrics into actionable findings and a professional report, without doing everything manually.

Core Features & Use Cases

• Multi-database health inspection: Run automated checks for MySQL, PostgreSQL, Oracle, SQL Server, DM8, TiDB, and IvorySQL and produce a Word report.
• 130+ enhanced risk rules + slow query deep analysis: Detect performance, security, configuration baseline gaps, index health issues, and generate fix-focused recommendations.
• Offline AI diagnosis (local Ollama only): Produce structured optimization advice locally and inject it into the report.
• History and trends: Persist numeric indicators locally and compare recent runs to highlight changes.
• Use Case: When a production database shows intermittent latency, run this skill to generate a Word inspection report, identify top risks (including locks and slow queries), and immediately get remediation SQL suggestions.

Quick Start

Ask your AI assistant to run the dbcheck skill to fully inspect a MySQL instance and return the generated Word report for review.