MySQL Inspection Report Generator
mysql-healthcheck is a MySQL inspection report automation tool chain for DBA /architect/customer delivery scenarios. It has built-in six-dimensional health scoring, root cause association inference, TOP SQL governance, compliance comparison table, and 10 embedded charts.
MySQL Inspection Report Generator A device that automatically generates a commercial deliverable inspection report (. docx) by using the (*. txt) results output by the MySQLHealthCheck collection script, and can customize the report cover, header, and logo to serve as a commercial MySQL inspection report generator. Built-in six-dimensional health score, root-cause correlation inference, TOP SQL governance, compliance comparison table, and 10 embedded charts. mysql-healthcheck is a MySQL inspection report automation tool chain for DBA/architect/customer delivery scenarios: Built-in six-dimensional health score, root-cause correlation inference, TOP SQL governance, compliance comparison table, and 10 embedded charts Applicable to: monthly routine inspection, pre-launch evaluation, post-failure review, compliance self-inspection (equivalent insurance/PCI/GDPR/SOX). π Report chief like this Chapter 17 + Executive Summary + Automatic Catalog: π Cover π Executive summary-----Health dashboard + six-dimensional radar chart + quick overview of key facts (management finished reading on 1 page) π Contents δΈ¨ β β β 1. Inspection summary β β Cluster level problems + node level problems + root cause correlation analysis δΈ¨ β β β 2. Server and topology overview + MySQL replication topology diagram + disk utilization histogram δΈ¨ β β β 3. Connection and session analysis + connection utilization chart + Processlist distribution chart δΈ¨ β β β IV. Database list (cross-node difference detection) δΈ¨ β β β 5. Comparison of key configuration parameters (Differences/Automatic judgment) δΈ¨ β β β 6. Performance indicator analysis + Buffer Pool hit rate histogram δΈ¨ β β β 7. Storage space analysis + TOP10 large table histogram (including archiving table identification) δΈ¨ β β VIII. Analysis of temporary table space (ibtmp 1) δΈ¨ β β β 9. InnoDB engine status δΈ¨ β β 10. Analysis of transactions and locks δΈ¨ β β β XI. User rights audit (host = % users are grouped according to risk level) δΈ¨ β β 12. Master-slave copying status δΈ¨ β β 13. Schema design audit β β Utilization rate of unused index/redundant index/BLOB/partition/self-increasing column δΈ¨ β β XIV. SQL Performance Governance β β Top 20 Slow SQL + Slow Log Samples + Missing Index SQL δΈ¨ β β β 15. Backup and recovery evaluation β β Backup tools/cron/products/RTOΒ·RPO estimation δΈ¨ β β β 16. Security compliance audit β β 9 inspections + equivalent insurance/PCI/GDPR/SOX comparison β β 17. Inspection summary and action plan β β Each P0/P1/P2 is attached with executable SQL Typical product: <Project Name>_MySQL Health Inspection Report_v1.0.docx (about 200 KB, including 10 embedded charts) Core characteristics π©Ί Six-dimensional health score Availability/security/performance/data specification/persistence/operation and maintenance-one number shows health, one radar shows weakness π Root cause correlation analysis Automatically identify 6 types of typical associations (such as "DR disk high binlog never expires ") to help DBAs find the true cause behind symptoms π 10 embedded charts Health Meter/Six-D Radar/Problem Distribution/MySQL Topology/Disk/Connections/Processlist/Buffer Pool/TOP10 Large Table/Compliance Distribution π― 20 + inspection rules P0/P1/P2/P3 automatic grading, intelligent aggregation of similar problems across nodes (35 items β 27 items with zero duplication) π‘οΈ Λ 9 safety compliance inspections Automatic mapping and other guarantees 2.0/PCI DSS/GDPR/SOX, PASS/WARN/FAIL at a glance π Top 20 Slow SQL Governance Grab TOP SQL directly from performance_schema + slow log tail actual SQL samples + missing index identification πΎ Backup capability assessment Detect backup tools/cron scheduling/backup products/binlog retention β Calculate RTO and RPO π€ Can be used as Claude Code Skill Equipped with YAML frontmatter, natural language trigger: "Help me generate MySQL inspection reports" π¦ Zero dependence on external services Purely local operation, no data is uploaded; suitable for financial/government and enterprise/other high-security environments π¨ WPS/Word/LibreOffice Universal Explicit column width + Microsoft YaHei to avoid common cross-platform rendering issues
