← 返回 Skills 市场
MySQL慢查询分析器
作者
shenghoo123-png
· GitHub ↗
· v1.0.1
· MIT-0
125
总下载
0
收藏
0
当前安装
2
版本数
在 OpenClaw 中安装
/install mysql-slow-query-analyzer-kay
功能描述
专业解析 MySQL EXPLAIN 与慢查询日志,定位性能瓶颈,提供索引与SQL重写优化建议,提高查询性能效率。
安全使用建议
This package mostly appears to be what it advertises: a local Python-based MySQL EXPLAIN / slow-log analyzer that needs no credentials. However, SKILL.md contains contradictory statements you should clarify before installing or trusting the skill: (1) it claims 'single-file <500 lines' but the bundle contains multiple modules and sizeable test files; (2) it advertises Pro/Team features (history, export, team sharing) and pricing, yet the code contains no networking, telemetry, authentication, or server-side components — ask the author how those paid features are implemented and where data would be stored or sent. Recommended steps before use: (a) review the code locally (search for network/socket/urllib/requests usage) to confirm no hidden endpoints; (b) run the tests in an isolated environment (VM/container) to verify behavior; (c) if you plan to analyze production slow logs, make sure you sanitize sensitive data before pasting into any skill or tool; (d) confirm licensing and the expected installation/distribution method with the publisher. If the author cannot explain the pricing/backend claims, treat the Pro/Team lines as marketing only and prefer the local-only behavior observed in the code.
功能分析
Type: OpenClaw Skill
Name: mysql-slow-query-analyzer-kay
Version: 1.0.1
The skill bundle is a legitimate MySQL performance analysis tool providing EXPLAIN parsing, slow query log analysis, and optimization suggestions. The Python code (analyzer_parser.py, analyzer_suggestions.py) uses standard libraries and regex to process SQL data locally without any network calls, file exfiltration, or suspicious execution patterns. The inclusion of a comprehensive test suite (tests/test_mysql_slow_query_analyzer.py) and clear documentation indicates a well-maintained, non-malicious project.
能力评估
Purpose & Capability
Name/description (MySQL slow-query analysis) align with the provided code: parser, suggestion generator, CLI, and tests all implement EXPLAIN and slow-log analysis. However SKILL.md claims '单文件 <500行' and a simple CLI-only distribution, while the package contains multiple modules (analyzer_parser.py, analyzer_suggestions.py, mysql_slow_query_analyzer.py, cli.py) plus tests. SKILL.md also advertises Pro/Team features (history, export, team sharing) yet there is no network or persistence implementation in the code. These are inconsistencies in documentation vs code (likely non-malicious misdocumentation) but they are incoherent with the stated packaging claims.
Instruction Scope
SKILL.md runtime instructions ask the agent to parse EXPLAIN outputs, slow query logs, and SQL text provided by the user; neither the instructions nor the code ask the agent to read arbitrary system files, environment variables, or to send data externally. The code accepts user-provided strings and returns analysis. There is no instruction for the agent to fetch production logs on its own or to exfiltrate data.
Install Mechanism
No install spec is present (instruction-only installation), which matches the code being pure Python files. The repository is self-contained and uses only standard-library modules. There is no remote download, package installer, or archive extraction to evaluate. This is low-risk from an install-mechanism perspective.
Credentials
The skill declares no required environment variables, no credentials, and no config paths; the code does not reference network libraries or secret-bearing env vars. Requested privileges are proportionate to the described purpose.
Persistence & Privilege
Flags show always:false and disable-model-invocation:false (normal). The code does not persist credentials or modify other skills; it does not request long-term presence or elevated system privileges.
如何使用
- 确保已安装 OpenClaw(本地或 Docker 部署)
- 在对话框中输入安装命令:
/install mysql-slow-query-analyzer-kay - 安装完成后,直接呼叫该 Skill 的名称或使用
/mysql-slow-query-analyzer-kay触发 - 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.1
bug修复+CLI增强
v1.0.0
- Initial release of MySQL Slow Query Analyzer skill.
- Analyze and optimize MySQL slow queries and EXPLAIN outputs (JSON/traditional/tab formats).
- Automatically generate index suggestions and SQL rewrite recommendations.
- Parse and review slow query logs with structured performance grading and actionable tips.
- Python-only implementation, CLI and API available, no dependencies or network required.
- Free and paid usage tiers supported.
元数据
常见问题
MySQL慢查询分析器 是什么?
专业解析 MySQL EXPLAIN 与慢查询日志,定位性能瓶颈,提供索引与SQL重写优化建议,提高查询性能效率。 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 125 次。
如何安装 MySQL慢查询分析器?
在 OpenClaw 或 Claude Code 对话框中运行命令「/install mysql-slow-query-analyzer-kay」即可一键安装,无需额外配置。
MySQL慢查询分析器 是免费的吗?
是的,MySQL慢查询分析器 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。
MySQL慢查询分析器 支持哪些平台?
MySQL慢查询分析器 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。
谁开发了 MySQL慢查询分析器?
由 shenghoo123-png(@shenghoo123-png)开发并维护,当前版本 v1.0.1。
推荐 Skills