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

sql-optimization

GitHub

提供SQL查询优化技巧与最佳实践,指导分析执行计划、检查缺失索引、重写子查询及验证性能提升。

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

trang chủ - Wiki
Copyright © 2011-2026 iteam. Current version is 2.156.0. UTC+08:00, 2026-11-05 20:40
浙ICP备14020137号-1