Menu
Write a SQL query from a plain-English request and a table schema. Use when the user wants a query written, explained, or fixed.
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
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.