Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Tencent SkillHub · Data Analysis
SQL Query Optimizer
Analyze and optimize SQL queries by providing performance analysis, index recommendations, execution plan interpretation, and optimization suggestions.
skill openclawclawhub Free
Analyze and optimize SQL queries by providing performance analysis, index recommendations, execution plan interpretation, and optimization suggestions.
⬇ 0 downloads ★ 0 stars Unverified but indexed
Install for OpenClaw
Quick setup
- Download the package from Yavira.
- Extract the archive and review SKILL.md first.
- Import or place the package into your OpenClaw setup.
Package facts
- Download mode
- Yavira redirect
- Package format
- ZIP package
- Source platform
- Tencent SkillHub
- What's included
- SKILL.md, skill.yaml
Validation
- Use the Yavira download entry.
- Review SKILL.md after the package is downloaded.
- Confirm the extracted package contains the expected setup assets.
Install with your agent
Agent handoff
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
New install
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
Upgrade existing
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
Trust & source
Release facts
- Source
- Tencent SkillHub
- Verification
- Indexed source record
- Version
- 1.0.0
Provenance
- Publisher
- HonestQiao
- Source page
- View original listing
- Canonical URL
- Open canonical page
Documentation
SQL Query Optimizer
分析并优化 SQL 查询，提升数据库性能。
功能
查询性能分析 索引建议 执行计划解读 SQL 优化建议
触发词
"SQL优化" "查询优化" "sql optimization" "慢查询"
检测问题
-- 检测 SELECT * 问题 SELECT * FROM users WHERE id = 1; -- 检测缺少 LIMIT SELECT name FROM users; -- 检测前导通配符 SELECT * FROM users WHERE name LIKE '%john%';
优化建议
避免 SELECT *，只查询需要的列 添加 WHERE 条件和 LIMIT 避免 LIKE 前导通配符 使用索引列 避免嵌套子查询 使用 EXPLAIN 分析执行计划
输出示例
{ "original": "SELECT * FROM users WHERE name LIKE '%john%'", "suggestions": [ "避免使用 SELECT *，只查询需要的列", "避免 LIKE 前导通配符", "添加 LIMIT 限制返回数量" ], "optimized": "SELECT id, name FROM users WHERE name LIKE '%john%' LIMIT 100" }
Category context
Data access, storage, extraction, analysis, reporting, and insight generation.
Source: Tencent SkillHub
Largest current source with strong distribution and engagement signals.
Package contents
Included in package
1 Docs1 Config
- SKILL.md
- skill.yaml