← All skills

腾讯云TCHouse-D 慢 SQL 诊断与自动调优

100 / 100 · Low risk

Fine to try.

By infometa/workbuddyskills (GitHub) · data · 443 stars · scanned at commit 33b6151

TCHouse-D（Doris）慢 SQL 诊断与自动调优 Skill。AI 自动检索指定集群的慢查询日志，对业务 SQL 模式（排除元数据/会话语句与后台系统任务）基于 SQL 文本与建表 DDL 做静态分析，识别性能瓶颈（全表扫描/JOIN 顺序不优/索引缺失/数据倾斜），生成 SQL 改写方案；若需 EXPLAIN 验证执行计划，则建议用户到控制台 SQL 工作区手动执行。若慢查询样本全部为系统 SQL，则明确给出「业务侧无慢查询」的结论并指引调度参数调优。 触发词：慢查询、慢SQL、slow query、SQL优化、查询优化、执行计划、EXPLAIN、查询耗时、查询超时、SQL调优、索引优化、全表扫描、数据倾斜、JOIN优化、查询性能、SQL性能、query performance、查询变慢、报表变慢、Doris优化、TCHouse-D优化、cdwdoris、查询诊断、SQL诊断、Bucket倾斜、物化视图。 本 Skill 包含 3 个子能力：①慢查询 Top N 检索与趋势分析 ②基于 SQL 文本 + DDL 的静态瓶颈识别 ③SQL 改写与索引优化方案生成。 何时不触…

Works with any agent that supports SKILL.md skills.

Partially scanned — some files couldn't be read; we'll retry on the next scan

What this skill can do

We found nothing in the files we read that matches our rules. That does not prove the skill is safe: see the limits of static scanning.

Install

Paste this into your terminal. It downloads exactly the version we scanned, not whatever is newest.

if [ -e ~/.agents/skills/'tchouse-d-sql' ] || [ -L ~/.agents/skills/'tchouse-d-sql' ]; then echo 'A skill folder named tchouse-d-sql already exists — not replacing it' >&2; false; else d=$(mktemp -d) && git clone --quiet --filter=blob:none --no-checkout 'https://github.com/infometa/workbuddyskills' "$d" && git -C "$d" checkout --quiet '33b6151ccee9aa0816c6f32d021be77d82772755' -- 'connectors/tencent-tchouse-c/skills/tchoused-slow-sql-diagnosis' && mkdir -p ~/.agents/skills && cp -R "$d"/'connectors/tencent-tchouse-c/skills/tchoused-slow-sql-diagnosis' ~/.agents/skills/'tchouse-d-sql' && rm -rf "$d"; fi

Codex reads ~/.agents/skills directly. For Claude Code, Cursor, Copilot, Gemini CLI, Antigravity or OpenCode, also link it. For Claude Code: ln -s ~/.agents/skills/'tchouse-d-sql' ~/.claude/skills/'tchouse-d-sql' (other agents: ~/.cursor/skills, ~/.copilot/skills, ~/.gemini/skills, ~/.gemini/config/skills, ~/.config/opencode/skills). Or install through the finder skill, which does both.

Badge for your README

The badge for infometa/workbuddyskills shows the score of its lowest-scoring skill.

[![SkillTrust](https://zalavijaysinh.github.io/skilltrust/badges/infometa/workbuddyskills.svg)](https://zalavijaysinh.github.io/skilltrust/repos/infometa/workbuddyskills/)

Score history