MySQL Slow Query Analyzer
v1.2.0帮助开发者解析MySQL EXPLAIN和慢查询日志，定位性能瓶颈，生成索引与SQL重写优化建议，提升查询效率。
⭐ 0· 69·1 current·1 all-time
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
OpenClaw
Benign
high confidencePurpose & Capability
The name, description, SKILL.md, and code all describe a local MySQL EXPLAIN and slow-query log analyzer; the code implements parsers, suggestion generators and a CLI and does not require external credentials or binaries. Minor inconsistencies: SKILL.md claims a single-file <500-line implementation and 'pure local' SaaS-free behavior while the package contains multiple modules and test files and also contains a 'Pricing' section (Free/Pro/Team) implying a hosted offering — this is a documentation/information mismatch but not a security issue in the code.
Instruction Scope
SKILL.md instructs the agent to accept pasted EXPLAIN JSON/text or slow_log entries and return analysis. The runtime instructions and code operate on provided text inputs; there are no instructions telling the agent to read arbitrary system files, environment variables, or external config. The code shown parses strings and returns suggestions consistent with the stated task.
Install Mechanism
There is no install spec — this is effectively an instruction-only / local-Python tool packaged with source. No downloads, no external package installs, and no extract-from-URL operations are declared.
Credentials
The skill declares no required environment variables, credentials, or config paths, and the code does not reference network libraries or secret-bearing env vars. Required privileges are minimal and proportional to the stated functionality.
Persistence & Privilege
The skill is not marked always:true and does not attempt to modify other skills or persist agent-wide configuration. It runs as a local analyzer and has no elevated persistence or privilege requests.
Assessment
This package appears to be a straightforward local MySQL EXPLAIN / slow-log analyzer implemented in Python with no network calls or credential requirements in the provided files. Before installing or running it: 1) Review the truncated portion of analyzer_parser.py (parse_slow_query_log) to confirm no unexpected network/file operations (the visible code is safe). 2) Be cautious about pasting production queries/logs — slow logs and EXPLAIN outputs can contain sensitive identifiers or data. 3) Note the source/homepage is unknown and SKILL.md mentions pricing (implying a hosted product) despite the code being fully local; if provenance matters, ask the publisher for origin or a checksum. 4) Run the included tests locally (pytest) to verify behavior in your environment.Like a lobster shell, security has layers — review code before you run it.
latestvk97ewbj4hdksbxzmanpv3xgg4584dtqg
License
MIT-0
Free to use, modify, and redistribute. No attribution required.