Menu

Individual skill

mysql-full-inspection-skill

对远程多实例MySQL数据库执行全方位深度巡检，覆盖基础健康、连接负载、性能慢查询、索引冗余、主从复制、容量空间、账号安全、配置风险八大维度，全自动完成巡检扫描、风险识别、问题定级、优化建议、报告归档与飞书推送，适用于生产/测试所有运行中MySQL实例常态化合规巡检。适用场景：用户要求进行 MySQL 全链路健康检查、MySQL 综合巡检、MySQL 风险扫描、MySQL 性能审计、MySQL 主从状态核查、MySQL 安全检测，并生成 MySQL 全量巡检报告时使用。

MySQL数据库巡检/SKILL.md

Read pinned source

Source commit 6ac447941289a7aa25df36b1c8977704db7ba3f1

What was checked

Matches the observed repository HEAD
Yes
Scanner rules are current
Yes
Repository scan complete
No
Skill scan complete
No
Observed behavior
Network or broad shell
Last checked
Nov 5, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings)
174
Repository last updated
Jun 22, 2026
License
MIT

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files
Read excerpt

# MySQL全方位深度巡检Skill

## 一、Skill整体概述

### 1.1 技能定位

本Skill为**企业级MySQL全维度自动化巡检闭环技能**，融合静态数据库现场巡检与Prometheus动态时序指标趋势分析，彻底解决传统单点瞬时巡检无法发现的隐性性能瓶颈、长期资源劣化、业务流量波动、间歇性故障、慢查询累积劣化等运维痛点。全面兼容MySQL 5.7/8.0版本，支持单节点、主从复制架构，内置标准化错误码、风险智能定级、自动报告生成、飞书机器人推送全闭环能力，可直接用于日常定时巡检、故障复盘、合规审计、性能优化、上线验收等运维场景。

### 1.2 核心能力

- 基础健康巡检：实例连通性校验、版本识别、运行时长、最大连接、字符集等基础配置合规校验

- 连接负载巡检：总会话、活跃会话、超时空闲无效连接统计，连接使用率、线程缓存命中率检测，规避连接堆积与连接泄露