dbcheck

Inspect relational database health and generate a Word report with risk findings.

137|52|Updated Apr 9, 2026
One-click install
npx skills add https://github.com/fiyo/DBCheck --skill dbcheck
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dbcheck
Source: https://github.com/fiyo/DBCheck/tree/main
Command: npx skills add https://github.com/fiyo/DBCheck --skill dbcheck

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about dbcheck

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate a database health report for MySQL and PostgreSQL?

You can generate a database health report by running automated inspections across MySQL, PostgreSQL, Oracle, and SQL Server, which produces a professional Word document containing categorized risk findings and remediation guidance.

What is included in an automated database health inspection?

A database health inspection includes 130+ enhanced risk rules, slow query deep analysis, configuration baseline compliance checks, and index health analysis, delivering fix-focused recommendations for detected performance and security issues.

Does the database health inspection support offline AI diagnosis?

Yes, offline AI diagnosis is supported strictly through a local Ollama-only environment with localhost validation, producing structured optimization advice locally and injecting it directly into your generated health report.

Can I compare historical database health trends across different inspection runs?

Yes, you can compare historical database health trends because the inspection persists numeric indicators locally and compares recent runs to highlight metric changes across your database instances over time.

What database engines are supported for slow query analysis and risk detection?

Supported database engines for slow query analysis and risk detection include MySQL, PostgreSQL, Oracle, SQL Server, DM8, TiDB, and IvorySQL, covering a wide range of relational database environments.

Do I need to provide database connection credentials for the health check?

Yes, you must provide database connection credentials, with optional SSH-based system metrics collection available, ensuring all local reports and history files are generated without credential exfiltration.