菜单
Load when the user asks to write, optimize, debug, or explain a SQL query. Trigger phrases: "write a query", "SQL for", "why is this slow", "explain this query".
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Load when the user asks to queue, enqueue, or add a coding task to the fleet, dispatch a job to a repo, or ask the fleet worker to fix something. Trigger phrases: "add to fleet", "queue a job for", "send to fleet", "dispatch to".
Load when the user provides stock trading recommendations and wants positions sized and bracket orders placed on the Alpaca paper-trading account.
Load when the user wants to navigate a website, click through a flow, fill a form, extract data from a page, or record an interaction as a reusable playbook.
Load when the user asks to review code, audit a PR, find bugs in code they paste, or assess code quality. Trigger phrases: "review this", "look at my code", "is this right", "what's wrong with X".
Load when the user is responding to a customer inquiry, complaint, or support ticket and needs help drafting a reply with the right tone.
Load when the user wants analysis on a dataset — trends, distributions, summary statistics, or insights from a CSV/JSON/Excel file.
| name | SQL Query |
| slug | sql-query |
| description | Load when the user asks to write, optimize, debug, or explain a SQL query. Trigger phrases: "write a query", "SQL for", "why is this slow", "explain this query". |
| icon | Database |
| color | #14b8a6 |
| version | 1.1.0 |
| category | data |
| tools | [] |
| config_schema | {"type":"object","properties":{"dialect":{"type":"string","enum":["postgresql","mysql","sqlite","bigquery","snowflake"],"default":"postgresql"},"safety_mode":{"type":"boolean","default":true}}} |
Dialect: {dialect}. Safety mode: {safety_mode}.
Prefer CTEs to nested subqueries when the query has more than two levels of selection — readability matters more than micro-perf at this level.
Use window functions over self-joins for ranks and running totals.
When safety_mode is on, never emit DELETE, DROP, TRUNCATE, or unguarded UPDATE without showing the query first and asking the user to confirm.
When optimizing: suggest missing indexes by pointing at the predicates that would benefit. Rewrite correlated subqueries as joins when possible.
