Agent SkillsDatus-ai/Datus-agent › sql-optimization

sql-optimization

GitHub

提供SQL查询优化技巧与最佳实践,包括分析执行计划、检查缺失索引、将子查询重写为JOIN以及使用EXPLAIN验证改进效果。

tests/data/skills/sql-optimization/SKILL.md Datus-ai/Datus-agent

触发场景

用户询问SQL性能问题 需要优化现有SQL查询 请求数据库性能调优建议

安装

npx skills add Datus-ai/Datus-agent --skill sql-optimization -g -y
更多选项

非标准路径

npx skills add https://github.com/Datus-ai/Datus-agent/tree/main/tests/data/skills/sql-optimization -g -y

不安装直接使用

npx skills use Datus-ai/Datus-agent@sql-optimization

指定 Agent (Claude Code)

npx skills add Datus-ai/Datus-agent --skill sql-optimization -a claude-code -g -y

安装 repo 全部 skill

npx skills add Datus-ai/Datus-agent --all -g -y

预览 repo 内 skill

npx skills add Datus-ai/Datus-agent --list

SKILL.md

Frontmatter
{
    "name": "sql-optimization",
    "tags": [
        "sql",
        "performance",
        "optimization"
    ],
    "version": "1.0.0",
    "description": "SQL query optimization techniques and best practices"
}

SQL Optimization Skill

Optimization Steps

  1. Analyze the query execution plan
  2. Check for missing indexes
  3. Rewrite subqueries as JOINs where possible
  4. Use EXPLAIN to verify improvements

版本历史

  • 8fb79f6 当前 2026-08-20 12:34

同 Skill 集合

datus/resources/skills/airflow-workflow/SKILL.md
datus/resources/skills/bi-validation/SKILL.md
datus/resources/skills/create-skill/SKILL.md
datus/resources/skills/create-subagent/SKILL.md
datus/resources/skills/dashboard-bootstrap/SKILL.md
datus/resources/skills/data-migration/SKILL.md
datus/resources/skills/dosi-semantic-authoring/SKILL.md
datus/resources/skills/extract-knowledge/SKILL.md
datus/resources/skills/gen-metrics/SKILL.md
datus/resources/skills/gen-table/SKILL.md
datus/resources/skills/grafana-dashboard/SKILL.md
datus/resources/skills/memory-organization/SKILL.md
datus/resources/skills/metricflow-semantic-authoring/SKILL.md
datus/resources/skills/optimize-skill/SKILL.md
datus/resources/skills/osi-metrics-authoring/SKILL.md
datus/resources/skills/osi-semantic-authoring/SKILL.md
datus/resources/skills/scheduler-validation/SKILL.md
datus/resources/skills/semantic-sql-history-profiler/SKILL.md
datus/resources/skills/session-summarize/SKILL.md
datus/resources/skills/storage-classify/SKILL.md
datus/resources/skills/superset-dashboard/SKILL.md
datus/resources/skills/table-validation/SKILL.md
datus/resources/skills/transfer-reconciliation/SKILL.md
tests/data/skills/report-generator/SKILL.md
tests/data/skills/sql-analysis/SKILL.md
datus/resources/skills/build-kb/SKILL.md
datus/resources/skills/init/SKILL.md
tests/data/skills/admin-tools/SKILL.md
tests/data/skills/data-profiler/SKILL.md

元信息

文件数
0
版本
71384a0
Hash
5521847a
收录时间
2026-08-20 12:34

首页 - Wiki
Copyright © 2011-2026 iteam. Current version is 2.155.2. UTC+08:00, 2026-09-09 16:08
浙ICP备14020137号-1 $访客地图$