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

sql-optimization

GitHub

提供SQL查询优化技巧与最佳实践,涵盖执行计划分析、缺失索引检查、子查询改写为JOIN及EXPLAIN验证等步骤。

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

Trigger Scenarios

用户询问SQL性能问题 需要优化数据库查询语句 分析慢查询原因

Install

npx skills add Datus-ai/Datus-agent --skill sql-optimization -g -y
More Options

Non-standard path

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

Use without installing

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

Version History

  • 8fb79f6 Current 2026-08-20 12:34

Same Skill Collection

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/gen-datasource/SKILL.md
datus/resources/skills/init/SKILL.md
tests/data/skills/admin-tools/SKILL.md
tests/data/skills/data-profiler/SKILL.md

Metadata

Files
0
Version
c43f7c7
Hash
5521847a
Indexed
2026-08-20 12:34

inicio - Wiki
Copyright © 2011-2026 iteam. Current version is 2.155.2. UTC+08:00, 2026-10-04 12:10
浙ICP备14020137号-1