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

需要优化慢查询时 数据库性能问题排查

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
6da6962
Hash
5521847a
Indexed
2026-08-20 12:34

Home - Wiki
Copyright © 2011-2026 iteam. Current version is 2.155.2. UTC+08:00, 2026-09-27 07:22
浙ICP备14020137号-1