SQL Optimization Patterns
ynulihao/AgentSkillOS
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
当代码涉及循环内查询、批量 ID 查询、IN 子句、BFS/递归遍历、嵌套 service 调用时触发。防止 N+1 查询、IN 子句过长、递归内存炸裂等性能陷阱。
Install Query Performance Safety
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install doccker/cc-use-exp query-performance-safety --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .claude/skills && cp -r skills-src/.claude/skills/query-performance-safety .claude/skills/query-performance-safety && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .claude/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safetyType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install doccker/cc-use-exp query-performance-safety --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .agents/skills && cp -r skills-src/.claude/skills/query-performance-safety .agents/skills/query-performance-safety && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .agents/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install doccker/cc-use-exp query-performance-safety --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/.claude/skills/query-performance-safety .cursor/skills/query-performance-safety && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .cursor/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/doccker/cc-use-exp.git --path .claude/skills/query-performance-safety--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install doccker/cc-use-exp query-performance-safety --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/.claude/skills/query-performance-safety .gemini/skills/query-performance-safety && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .gemini/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install doccker/cc-use-exp query-performance-safetyInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .github/skills && cp -r skills-src/.claude/skills/query-performance-safety .github/skills/query-performance-safety && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .github/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add doccker/cc-use-exp --skill query-performance-safety -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install doccker/cc-use-exp query-performance-safety --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/doccker/cc-use-exp.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/.claude/skills/query-performance-safety .opencode/skills/query-performance-safety && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "query-performance-safety" agent skill from https://github.com/doccker/cc-use-exp/tree/main/.claude/skills/query-performance-safety into .opencode/skills/query-performance-safety/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "query-performance-safety", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
query-performance-safety- GitHub stars
- 1.1k
- Token cost
- ~3.3k tokens
- SKILL.md length
- 437 words
- Files
- 2 (incl. references)
- Skills in repo
- 67
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
当代码涉及循环内查询、批量 ID 查询、IN 子句、BFS/递归遍历、嵌套 service 调用时触发。防止 N+1 查询、IN 子句过长、递归内存炸裂等性能陷阱。
- Tasks that involve Query optimization
- SKILL.md covers 陷阱 #1: 循环内调用单条查询 → N+1, 陷阱 #2: IN 子句不分批, 陷阱 #3: BFS/递归遍历无总节点上限 and 陷阱 #4: 嵌套 service 调用造成隐式重复查询, plus 2 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Query Performance Safety is an agent skill from doccker/cc-use-exp. 当代码涉及循环内查询、批量 ID 查询、IN 子句、BFS/递归遍历、嵌套 service 调用时触发。防止 N+1 查询、IN 子句过长、递归内存炸裂等性能陷阱。
Its SKILL.md is about 3.3k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files, including reference files (for example `references/multi-lang-examples.md`).
It sits in Databases, covering Query optimization. It works with SQL. The repository describes itself as: ⛔ No longer maintained → dev-agent-kit/recipes 让 Claude Code、Antigravity、Gemini CLI、Codex、Cursor 开箱即用的分层配置模板，总结十多年的日常开发经验.
When your agent uses it
- Tasks that involve Query optimization
Example prompts
- “/query-performance-safety”
What it can do on your machine
Read from SKILL.md and the folder at commit 64470cb. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md (its code samples are java and sql).
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Query Performance Safety loads about 3.3k tokens when it runs, and up to ~4.8k if it reads all its reference files. Until then it costs about 27 tokens; SKILL.md has 437 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 437 words (~3,296 tokens).
- name
- query-performance-safety
Files
SKILL.md and 1 other file (references) in .claude/skills/query-performance-safety of doccker/cc-use-exp.
- SKILL.md
- references/multi-lang-examples.md
Open the folder on GitHubat commit 64470cb
Compare with similar skills
Query Performance Safety next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Query Performance Safety this skilldoccker/cc-use-exp | 1.1k | — | ~3.3k | Automated safety check: Pass | Custom licence | |
| SQL Optimization Patternsynulihao/AgentSkillOS | 617 | 10 repos | ~3.3k | Automated safety check: Pass | None | |
| Query Engine Designrevfactory/claude-code-harness | 120 | — | ~474 | Automated safety check: Pass | None | |
| SQL Optimization Patternssickn33/agentic-awesome-skills | 47k | 1 repos | ~566 | Automated safety check: Pass | MIT | |
| SQL Database Assistantborghei/Claude-Skills | 874 | — | ~1.5k | Automated safety check: Pass | MIT | |
| SQL Optimization InterviewerPrepLabsAI/InterviewMentor | 112 | — | ~2.1k | Automated safety check: Pass | MIT |
Similar skills
Query Engine Design
revfactory/claude-code-harness
SQL query engine design and implementation guide. An agent skill from revfactory/claude-code-harness.
SQL Optimization Patterns
sickn33/agentic-awesome-skills
Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.
SQL Database Assistant
borghei/Claude-Skills
This skill should be used when the user asks to "optimize SQL queries", "explore database schemas", "generate migration SQL", "analyze query performance", or "document database structure".
SQL Optimization Interviewer
PrepLabsAI/InterviewMentor
A Data Engineering interviewer focused on database performance.
Writing SQL
rileyhilliard/claude-essentials
Staff+ DBA SQL patterns targeting what Claude's defaults miss - multi-column statistics, operator classes, keyset pagination, silent performance anti-patterns.
More from doccker/cc-use-exp
All 67 skills in this repoAPI Design Safety
doccker/cc-use-exp
当设计或修改 REST API 响应结构、处理 API 返回值，或生成 Excel/CSV/PDF/对账文件等下游产物时触发。防止 API 设计缺陷导致的字段错位、类型歧义，以及生成产物时关键字段缺失但静默成功的问题。
Cc Code Quality Principles
doccker/cc-use-exp
当编写新模块、设计接口、重构代码或代码审查时触发。提供经典模块化六原则检查清单（大小适中/调用深度/扇入扇出/边界清晰/作用域内聚/可预测性），适用于 PR/Review/新模块设计场景。
Cc Review
doccker/cc-use-exp
结构化代码审查工作流，适用于显式 quick/full/security review；不负责普通实现或 bug 修复流程。
Cc Streaming Export Safety
doccker/cc-use-exp
当实现用户驱动的大文件导出或批量序列化（Excel/CSV/JSON/JSONL/PDF，数据量未知或超过 1 万行/10 MB）时触发；普通小文件下载、静态资源下载、非导出 Writer/Report 类不触发。防止 OOM、临时文件残留、同步导出阻塞 HTTP 线程和表格公式注入。
Code Quality Principles
doccker/cc-use-exp
当编写新模块、设计接口、重构代码或代码审查时触发。提供经典模块化六原则检查清单（大小适中/调用深度/扇入扇出/边界清晰/作用域内聚/可预测性），适用于 PR/Review/新模块设计场景。
External System Debugging
doccker/cc-use-exp
涉及浏览器、编辑器、CDN/WAF、IM 平台、操作系统剪贴板、第三方 SaaS 等"外部黑盒系统"的代码编写或 bug 调试时触发。强制先抓真实环境数据再推理,避免连续 2 轮"凭代码推理"的修复 no-op。关键词:粘贴/复制异常、跨平台显示不一致、第三方 API 怪结果、CDN/WAF 拦截、本地复现失败、HTML→MD 转换丢属性。
Related
Works with
Categories
Questions about Query Performance Safety
What does Query Performance Safety do?
当代码涉及循环内查询、批量 ID 查询、IN 子句、BFS/递归遍历、嵌套 service 调用时触发。防止 N+1 查询、IN 子句过长、递归内存炸裂等性能陷阱。. Query Performance Safety is an agent skill from doccker/cc-use-exp.
When should I use Query Performance Safety?
Query Performance Safety fits situations like: tasks that involve Query optimization.
How do I install Query Performance Safety in Claude Code?
Run `npx skills add doccker/cc-use-exp --skill query-performance-safety -a claude-code`. Or copy the skill folder (.claude/skills/query-performance-safety in doccker/cc-use-exp) into .claude/skills/query-performance-safety in your project. Claude Code loads it when a task matches its description.
How do I install Query Performance Safety in Codex?
Run `npx skills add doccker/cc-use-exp --skill query-performance-safety -a codex`. Or copy the skill folder (.claude/skills/query-performance-safety in doccker/cc-use-exp) into .agents/skills/query-performance-safety in your project. Codex loads it when a task matches its description.
Can I use Query Performance Safety in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add doccker/cc-use-exp --skill query-performance-safety -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/query-performance-safety, .gemini/skills/query-performance-safety, .github/skills/query-performance-safety and .opencode/skills/query-performance-safety in your project.
What does Query Performance Safety need to run?
SKILL.md names no scripts, command-line tools or credentials: Query Performance Safety is instructions for the agent only.
Does Query Performance Safety access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Query Performance Safety safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Query Performance Safety use?
Query Performance Safety has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does Query Performance Safety use?
About 3.3k tokens (SKILL.md is roughly 13k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 1.5k tokens, read only when the agent opens those files.
What are the alternatives to Query Performance Safety?
Skills that share tags, products or a category with Query Performance Safety: SQL Optimization Patterns (ynulihao/AgentSkillOS, 617 stars), Query Engine Design (revfactory/claude-code-harness, 120 stars), SQL Optimization Patterns (sickn33/agentic-awesome-skills, 47k stars) and SQL Database Assistant (borghei/Claude-Skills, 874 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Query Performance Safety?
doccker (a GitHub user) maintains it in doccker/cc-use-exp, which has 1,063 GitHub stars. The repository holds 67 skills in this directory. The repository was last updated on August 26, 2026.
Source: doccker/cc-use-exp on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.