Menu
Review, optimize, or generate SQL queries and database schemas. Use when the user asks about SQL optimization, database design, query analysis, or says "sql".
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
把一个新站点部署上线到 bluecatbot 服务器（chi）并自动接入门户导航：选子域名/端口 → tar+build+systemd（动态站）或静态产物→nginx root（静态站）→ nginx 子域名 + certbot SSL → 拉门户 website-main/index.html、加一张三语卡片、备份回推 → 自检 SEO → 验证 → 提交。 当用户要「发布/部署一个新站」「上 *.bluecatbot.com 新子域名」「给门户/主站加卡片」 「让新站走这套上线流程」时使用。务必遵守安全不变量（连接信息读 servers.json、 门户先拉后改先备份再推、只动本站服务+新增 nginx 站、绝不把 servers.json/.env/.pem/HANDOFF 推公开仓库）。
Router/index for the software-craftsmanship skill family — 7 classic books turned into knowledge bases: clean-code, refactoring, design-patterns, solid-principles, code-complete, pragmatic-programmer, 97-things. Use when the user wants cleaner code / more disciplined, standardized engineering, asks which principle/pattern/refactoring applies, wants a code-quality or design-review rubric, or says 让代码更简洁 / 工程更规范 / 重构 / 设计模式 / 设计原则 — and you need to pick the right craftsmanship skill. Routes a task or topic to the OWNING skill with clear boundaries so they don't overlap. Distinct from dev-commons (this workspace's stack-specific recipes) and from code-review/simplify (which execute reviews); those run the work, code-craft supplies the canonical craft knowledge.
生成/更新会话进度交接文档（HANDOFF.md，落到本会话实际改动的项目目录），用于上下文接近上限时把当前所有工作落盘，方便 /clear 或 /compact 后让新会话无缝接力。Use when 上下文用量偏高、用户说"交接/接力/handoff"、或准备清理会话之前。也会被全局 Stop hook（context-handoff-check.py）在用量达阈值（默认 50%）时自动调用。
Diagnose and fix backend bugs, errors, and exceptions. Use when the user reports a bug, shares an error log/stack trace, or asks to debug an issue.
Cross-project development intelligence. 20 Flask patterns, 18 Electron patterns, 20 frontend patterns, 15 Windows pitfalls, 12 git/release workflows, 15 code conventions, 12 security patterns, 15 Next.js patterns, 15 Python patterns. BM25 search engine. Actions: scaffold route, build feature, fix bug, configure build, debug pitfall, review code, release version, setup project. Stacks: Flask + vanilla JS, Electron + PyInstaller, Next.js + React + Prisma, FastAPI + SQLite, pure Python CLI. Shared across all projects.
鉴技 / SkillScope —— 当你（或用户）不确定「这个活该用哪个 skill / 用哪个技能 / which skill should I use / 有没有现成的 skill 干这个」时，用自然语言查询本地 skill 库并给出可解释的推荐。CJK 感知（中/日/英都行）、零网络、确定性、只读。Use this WHENEVER the user asks which skill/技能 to use for a task, asks if a skill exists for X, wants to browse/list installed skills by domain, or when you yourself are unsure which skill to route a task to. Also use to audit skill-context bloat (how many skills, token weight, tier distribution).
| name | sql |
| description | Review, optimize, or generate SQL queries and database schemas. Use when the user asks about SQL optimization, database design, query analysis, or says "sql". |
| disable-model-invocation | true |
| allowed-tools | Read, Grep, Glob |
| metadata | {"tier":"default","cost":"light","side_effects":"none"} |
Analyze or generate SQL based on the following:
$ARGUMENTS
For optimization:
For generation:
