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

sql-optimization

GitHub

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

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

触发场景

需要优化慢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

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

版本历史

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

同 Skill 集合

airflow-workflow

datus/resources/skills/airflow-workflow/SKILL.md

bi-validation

datus/resources/skills/bi-validation/SKILL.md

create-skill

datus/resources/skills/create-skill/SKILL.md

create-subagent

datus/resources/skills/create-subagent/SKILL.md

dashboard-bootstrap

datus/resources/skills/dashboard-bootstrap/SKILL.md

data-migration

datus/resources/skills/data-migration/SKILL.md

dosi-semantic-authoring

datus/resources/skills/dosi-semantic-authoring/SKILL.md

extract-knowledge

datus/resources/skills/extract-knowledge/SKILL.md

gen-metrics

datus/resources/skills/gen-metrics/SKILL.md

gen-table

datus/resources/skills/gen-table/SKILL.md

grafana-dashboard

datus/resources/skills/grafana-dashboard/SKILL.md

memory-organization

datus/resources/skills/memory-organization/SKILL.md

metricflow-semantic-authoring

datus/resources/skills/metricflow-semantic-authoring/SKILL.md

optimize-skill

datus/resources/skills/optimize-skill/SKILL.md

osi-metrics-authoring

datus/resources/skills/osi-metrics-authoring/SKILL.md

osi-semantic-authoring

datus/resources/skills/osi-semantic-authoring/SKILL.md

scheduler-validation

datus/resources/skills/scheduler-validation/SKILL.md

semantic-sql-history-profiler

datus/resources/skills/semantic-sql-history-profiler/SKILL.md

session-summarize

datus/resources/skills/session-summarize/SKILL.md

storage-classify

datus/resources/skills/storage-classify/SKILL.md

superset-dashboard

datus/resources/skills/superset-dashboard/SKILL.md

table-validation

datus/resources/skills/table-validation/SKILL.md

transfer-reconciliation

datus/resources/skills/transfer-reconciliation/SKILL.md

report-generator

tests/data/skills/report-generator/SKILL.md

sql-analysis

tests/data/skills/sql-analysis/SKILL.md

build-kb

datus/resources/skills/build-kb/SKILL.md

gen-datasource

datus/resources/skills/gen-datasource/SKILL.md

init

datus/resources/skills/init/SKILL.md

admin-tools

tests/data/skills/admin-tools/SKILL.md

data-profiler

tests/data/skills/data-profiler/SKILL.md

查看所属 Skill 集合 ›

元信息

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

sql-optimization