菜单
Write a SQL query from a plain-English request and a table schema. Use when the user wants a query written, explained, or fixed.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
Turn a list of commits or changes into a release changelog (Keep a Changelog format). Use when preparing release notes.
Weigh options against weighted criteria to support a decision. Use when the user is choosing between alternatives.
Proofread and tighten text — fix grammar, clarity, and tone — and show what changed. Use when the user wants writing improved.
Build and explain a regular expression from a description, with examples. Use when the user needs a regex or wants one explained.
Answer a question with a short, sourced research brief. Use for "research X", "what's the latest on Y", or fact-finding that needs citations.
Summarize a web page or article from a URL. Use when the user shares a link and wants the gist or key points.
| name | sql-query |
| description | Write a SQL query from a plain-English request and a table schema. Use when the user wants a query written, explained, or fixed. |
| license | MIT |
Translate the user's request into a correct SQL query.
Work from the schema the user provides. If the relevant tables/columns aren't given, ask for them (or state the assumptions you're making).
Output:
-- one clear query
Then two lines explaining what it does and any assumption (e.g. dialect).
Rules:
JOIN ... ON, not implicit joins. Alias tables for readability.? / :name) and note it — never concatenate raw input.UPDATE/DELETE/DROP if the user explicitly asks; otherwise prefer a SELECT. For destructive statements, add a one-line warning and suggest a SELECT to preview affected rows first.