Overview
- Skill Key
- honestqiao/sql-query-optimizer
- Author
- honestqiao
- Source Repo
- openclaw/skills
- Version
- -
- Source Path
- skills/honestqiao/sql-query-optimizer
- Latest Commit SHA
- a912913c78394d690f94ffacc31ff13fa3204188
Stars
0
Installs
0
Status
ACTIVE
Visibility
PUBLIC
安装方式
直接复制以下提示词，发送给你的 AI 助手即可完成安装。
请先检查是否已安装 SkillHub 商店，若未安装，请根据 https://skillhub-1388575217.cos.ap-guangzhou.myqcloud.com/install/skillhub.md 安装 SkillHub 商店，然后安装 Sql Query Optimizer 技能。 若已安装，则直接安装 Sql Query Optimizer 技能。
Extracted Content
SKILL.md excerpt
# SQL Query Optimizer
分析并优化 SQL 查询，提升数据库性能。
## 功能
- 查询性能分析
- 索引建议
- 执行计划解读
- SQL 优化建议
## 触发词
- "SQL优化"
- "查询优化"
- "sql optimization"
- "慢查询"
## 检测问题
```sql
-- 检测 SELECT * 问题
SELECT * FROM users WHERE id = 1;
-- 检测缺少 LIMIT
SELECT name FROM users;
-- 检测前导通配符
SELECT * FROM users WHERE name LIKE '%john%';
```
## 优化建议
1. 避免 SELECT *，只查询需要的列
2. 添加 WHERE 条件和 LIMIT
3. 避免 LIKE 前导通配符
4. 使用索引列
5. 避免嵌套子查询
6. 使用 EXPLAIN 分析执行计划
## 输出示例
```json
{
"original": "SELECT * FROM users WHERE name LIKE '%john%'",
"suggestions": [
"避免使用 SELECT *，只查询需要的列",
"避免 LIKE 前导通配符",
"添加 LIMIT 限制返回数量"
],
"optimized": "SELECT id, name FROM users WHERE name LIKE '%john%' LIMIT 100"
}
```
Related Claw Skills
capt-marbles
Task Router Skill
Task Router
capncoconut
x402hub
Register, communicate, and earn on the x402hub AI agent marketplace. Use when an agent needs to register on x402hub, browse or claim bounties, submit deliverables, send messages to other agents via x402 Relay, check marketplace stats, or manage agent credentials. Triggers on x402hub, agent marketplace, bounty, relay messaging, agent-to-agent communication, or USDC earning.
capevace
claw
Real-time event bus for AI agents. Publish, subscribe, and share live signals across a network of agents with Unix-style simplicity.
captchasco
captchas-openclaw
OpenClaw integration guidance for CAPTCHAS Agent API, including OpenResponses tool schemas and plugin tool registration.
carol-gutianle
Modelready
name: modelready description: Start using a local or Hugging Face model instantly, directly from chat. metadata: {"openclaw":{"requires":{"bins": "bash", "curl" }, "env": "URL" }}
canbirlik
wiz-light-control
Controls Wiz smart bulbs (turn on/off, RGB colors, disco mode) via local WiFi.