← Back to Skills Marketplace
shenghoo123-png

MySQL慢查询分析器

by shenghoo123-png · GitHub ↗ · v1.0.1 · MIT-0
cross-platform ⚠ suspicious
125
Downloads
0
Stars
0
Active Installs
2
Versions
Install in OpenClaw
/install mysql-slow-query-analyzer-kay
Description
专业解析 MySQL EXPLAIN 与慢查询日志,定位性能瓶颈,提供索引与SQL重写优化建议,提高查询性能效率。
Usage Guidance
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.
Capability Analysis
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.
Capability Assessment
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.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install mysql-slow-query-analyzer-kay
  3. After installation, invoke the skill by name or use /mysql-slow-query-analyzer-kay
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Slug mysql-slow-query-analyzer-kay
Version 1.0.1
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 2
Frequently Asked Questions

What is MySQL慢查询分析器?

专业解析 MySQL EXPLAIN 与慢查询日志,定位性能瓶颈,提供索引与SQL重写优化建议,提高查询性能效率。 It is an AI Agent Skill for Claude Code / OpenClaw, with 125 downloads so far.

How do I install MySQL慢查询分析器?

Run "/install mysql-slow-query-analyzer-kay" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is MySQL慢查询分析器 free?

Yes, MySQL慢查询分析器 is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does MySQL慢查询分析器 support?

MySQL慢查询分析器 is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created MySQL慢查询分析器?

It is built and maintained by shenghoo123-png (@shenghoo123-png); the current version is v1.0.1.

💬 Comments