SQL Schema Designer skill for Claude and Codex
Designs a relational schema from an app description and returns the reasoning plus ready-to-run CREATE TABLE statements, with keys, constraints and optional…
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 starting an app and needs tables, keys and constraints worked out from a plain description of its entities. Do not use for optimizing queries on an existing schema or choosing a join. Related topics: sql, database, architecture.
What it will ask you for
- App and main entities (longer free text)
- Database system (choose one: PostgreSQL, MySQL, SQLite, SQL Server)
- Use UUIDs for primary keys (choose one: Yes, No)
- Elements to include (choose any: Foreign keys, Indexes, Timestamps, Constraints)
- Include sample INSERT statements (choose one: Yes, No)
How it works
- List entities and relationships from the description and mark which need join tables.
- Normalize the design and note any deliberate denormalization with the reason.
- Write CREATE TABLE statements in dependency order with native types, constraints and ON DELETE rules.
- Add the requested indexes, timestamps and sample INSERTs, then confirm the script would run top to bottom.
What you get
A brief design explanation followed by the complete SQL for the chosen database in dependency order, with optional sample INSERT statements.
What it watches out for
- Creating tables before the ones they reference, which makes the script fail.
- Omitting ON DELETE rules so deletes either fail or orphan child rows.
- Using types from another database, such as UUID on SQLite or SERIAL on MySQL.
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.