SQL JOIN Helper skill for Claude and Codex
Picks the right SQL JOIN type for two tables and writes the query for your database engine, with a plain explanation of which rows each side keeps.
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 a developer is unsure whether two tables need an inner, left, right or full join and wants the query written for their database. Do not use for tuning a slow query or designing table structure. Related topics: sql, data, coding.
What it will ask you for
- Table 1 name (free text, e.g. "users")
- Table 2 name (free text, e.g. "orders")
- Shared key (free text, e.g. "users.id = orders.user_id")
- Rows to keep (choose one: All rows from both (full outer), Only matching rows (inner), All rows from Table 1 (left), All rows from Table 2 (right))
- Extra filtering (longer free text)
- Database engine (choose one: PostgreSQL, MySQL, SQL Server)
How it works
- Map the rows-to-keep choice to the join type and confirm the shared key is the join condition.
- Write the query with aliases and explicit columns for the chosen engine.
- Decide whether each filter belongs in ON or WHERE so outer-join rows are not silently dropped.
- Explain which rows appear and where NULLs show up, noting any engine workaround for unsupported joins.
What you get
A SQL query in a code block for the chosen engine, followed by a short explanation of which rows are kept, where NULLs appear and why the filter is placed as it is.
What it watches out for
- Putting a filter on the outer table in WHERE, which quietly converts a left join to an inner join.
- Using FULL OUTER JOIN on MySQL, where it does not exist.
- Selecting every column and returning duplicate key names that confuse the application.
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.