SQL Query Builder skill for Claude and Codex
A correct SQL query for a plain-English question, with the join risks called out so row counts and totals are not silently inflated.
Install it once and Claude or Codex runs it for you. When your request matches, your AI loads the skill, asks for anything it is missing, and works through the template itself. Prefer to fill it in by hand? See the full prompt template.
Download the skill (.zip) · View SKILL.md
When it is used
Use when someone can describe a data question in plain English and needs a trustworthy SQL query against a known schema. Do not use for designing a schema or tuning a slow production query plan. Related topics: Data, Technical, Coding.
What it will ask you for
- Schema (longer free text)
- Question to answer (longer free text)
- Database (choose one: PostgreSQL, MySQL, BigQuery, Snowflake, SQL Server, SQLite)
- Rough table sizes (free text, e.g. "Row counts since they change the approach")
How it works
- Map the question to the tables and columns in the schema and note the grain of the result.
- Write the query in the chosen dialect, formatted and commented where the logic is not obvious.
- Check each join for fan-out against the keys and aggregate before joining where needed.
- Describe the null handling and whether an index is justified at the stated row counts.
- Provide a sanity-check query that compares the result to a known count or total.
What you get
The formatted query, a short join and null explanation, an index note, and a sanity-check query.
What it watches out for
- Joining a one-to-many table before aggregating, which multiplies rows and inflates sums.
- Using dialect-specific functions from the wrong database.
- Filtering on a nullable column in a way that silently drops rows.
How to install
Claude.ai and the Claude desktop app
- Download the skill .zip.
- Open Settings, then Capabilities, and find Skills.
- Choose Upload skill and select the .zip.
- Ask Claude for help with the task. It loads the skill when your request matches.
Claude Code
- Download the skill .zip.
- Unzip it into ~/.claude/skills/ (or .claude/skills/ inside a project).
- Start a new session. Claude Code loads the skill when your request matches.
Codex
- Download the skill .zip.
- Unzip it into ~/.agents/skills/ (or .agents/skills/ inside a project).
- Codex picks it up on its own. Type $ and the skill name to use it, or just ask for the task.
Cursor
- Download the Cursor rule (.mdc).
- Save it in .cursor/rules/ inside your project.
- Cursor's agent applies the rule when your request matches its description.
AGENTS.md (Codex, Cursor, and other coding agents)
- Copy the AGENTS.md section.
- Paste it into AGENTS.md at the root of your repository, creating the file if needed.
- Coding agents that read AGENTS.md follow it when your request fits.