mysql-slow-query-analyzer帮助开发者解析MySQL EXPLAIN和慢查询日志,定位性能瓶颈,生成索引与SQL重写优化建议,提升查询效率。
Install via ClawdBot CLI:
clawdbot install shenghoo123-png/mysql-slow-query-analyzerGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Generated Oct 8, 2026
SRE or on-call DBA copies slow query log entries into the analyzer to quickly rank the worst offenders by Query_time and rows examined. The tool returns per-query optimization actions and index suggestions so the team can patch high-impact queries during an incident.
Engineers paste EXPLAIN outputs into the skill before merging a migration or query change. The analyzer flags full table scans, filesort, missing indexes, and implicit type conversions as blocking issues in code review, reducing the chance of shipping slow SQL.
During seasonal traffic spikes, e-commerce teams analyze slow queries on orders, payments, and inventory tables. The skill checks index coverage on status, created_at, and customer_id columns and recommends composite indexes to protect checkout latency.
New backend engineers use the tool to learn why a query is slow by inspecting cost, scan efficiency, and join type in a friendly report format. The indexed advice and rewrite suggestions serve as a practical MySQL performance curriculum.
A consulting agency runs the analyzer against client-provided slow query logs and EXPLAIN outputs to produce a performance audit. The generated index and rewrite recommendations become deliverables in a database optimization engagement.
Developers get 10 EXPLAIN analyses per day for free, while power users upgrade to Pro for slow log analysis, history, and higher daily limits. The tiered limits make it easy to try in a local CLI and then adopt in daily workflow.
Sold as a team seat product that adds batch analysis, exportable reports, and shared query review to existing DBA and backend engineering teams. Team plans enable collaborative review of slow query findings and index proposals.
Use the analyzer as the diagnostic engine for a paid consulting engagement where experts deliver prioritized index plans and SQL rewrites. Reports generated by the tool can be exported and packaged as client-facing optimization deliverables.
💬 Integration Tip
Because this is a pure local Python CLI/API with no external dependencies, it can be run inside a coding agent environment or CI pipeline by passing EXPLAIN output or slow log text directly as a command argument. For agent use, wrap the CLI commands as tools so the model can pipe EXPLAIN JSON and slow query log snippets into analysis without network access.
Scored Oct 8, 2026
Database Designer - POWERFUL Tier Skill
Skill Oracle — Curated documentation of quality ClawHub skills. Markdown tables telling agents which tools work and which are empty. Not an API or code library.
Database Schema Designer
Use when optimizing SQL queries, designing database schemas, or tuning database performance. Invoke for complex queries, window functions, CTEs, indexing strategies, query plan analysis.
Pinecone vector database — manage indexes, upsert vectors, query similarity search, manage namespaces, and track collections via the Pinecone API. Build sema...
Connect, query, and monitor Redis instances. Use when checking key health, validating data types, generating backups, formatting results, linting configs.