Agent Skills › ECNU-ICALK/AutoSkill › SQL Query Generation with Explicit JOINs

SQL Query Generation with Explicit JOINs

GitHub

该技能用于根据用户需求和数据库模式生成或修正SQL查询。强制使用显式JOIN语法（如INNER JOIN、LEFT JOIN）配合ON子句，严格禁止使用NATURAL JOIN，以确保查询的兼容性和明确性。

SkillBank/ConvSkill/english_gpt3.5_8/sql-query-generation-with-explicit-joins/SKILL.md ECNU-ICALK/AutoSkill

触发场景

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

安装

npx skills add ECNU-ICALK/AutoSkill --skill SQL Query Generation with Explicit JOINs -g -y

更多选项

非标准路径

npx skills add https://github.com/ECNU-ICALK/AutoSkill/tree/main/SkillBank/ConvSkill/english_gpt3.5_8/sql-query-generation-with-explicit-joins -g -y

不安装直接使用

npx skills use ECNU-ICALK/AutoSkill@SQL Query Generation with Explicit JOINs

指定 Agent (Claude Code)

npx skills add ECNU-ICALK/AutoSkill --skill SQL Query Generation with Explicit JOINs -a claude-code -g -y

安装 repo 全部 skill

npx skills add ECNU-ICALK/AutoSkill --all -g -y

预览 repo 内 skill

npx skills add ECNU-ICALK/AutoSkill --list

SKILL.md

Frontmatter

{
    "id": "ca62001f-f737-4888-bce4-94c02b52eac1",
    "name": "SQL Query Generation with Explicit JOINs",
    "tags": [
        "sql",
        "database",
        "query",
        "explicit-join",
        "natural-join"
    ],
    "version": "0.1.0",
    "triggers": [
        "write a sql query",
        "generate sql",
        "fix this sql query",
        "don't use natural join",
        "convert natural join to explicit join"
    ],
    "description": "Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility."
}

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

版本历史

94c47ca 当前 2026-07-24 13:38

元信息

文件数: 0
版本: 94c47ca
Hash: ce2b0d2d
收录时间: 2026-07-24 13:38

SQL Query Generation with Explicit JOINs