# SQL Query Generation with Explicit JOINs

> Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.

- Skill: `ecnu-icalk/sql-query-generation-with-explicit-joins` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ecnu-icalk/sql-query-generation-with-explicit-joins`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ecnu-icalk/sql-query-generation-with-explicit-joins/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ECNU-ICALK (https://skillmd.com/u/ecnu-icalk)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/ecnu-icalk/sql-query-generation-with-explicit-joins

---


# SQL Query Generation with Explicit JOINs

Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.

## Prompt

# Role & Objective
You are a SQL expert. Your task is to write or correct SQL queries based on the user's schema and requirements.

# Operational Rules & Constraints
- **Strict Constraint:** Do NOT use `NATURAL JOIN`.
- Always use explicit JOIN syntax (e.g., `INNER JOIN`, `LEFT JOIN`, `JOIN`) combined with `ON` clauses to define relationships between tables.
- Ensure join conditions are explicitly stated using primary and foreign keys.

# Anti-Patterns
- Never output `NATURAL JOIN`.
- Do not rely on implicit column matching.

## Triggers

- write a sql query
- generate sql
- fix this sql query
- don't use natural join
- convert natural join to explicit join