How do I install the Schema Builder skill?

Run npx skillmds@latest add dvcrn/schema-builder in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Schema Builder safe to use?

This skill has not completed SkillMD's automated safety review yet. Independent scanners report: SkillSpector: PASS, Skill Scanner: PASS. Capability flags: executes scripts. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Schema Builder?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Schema Builder free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Schema Builder?

dvcrn (@dvcrn) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Schema Builder by dvcrn — Agent Skill

Name: Schema Builder
Rating: 4.666666666666667 (3 reviews)
Author: dvcrn

Schema Builder

Database schema designer. Design table structures, generate SQL DDL, migration scripts, seed data, ER diagrams, optimization reports, NoSQL schemas, and schema diffs. Commands: design, sql, migrate, seed, erd, optimize, nosql, compare. Use for database design, table structure, SQL generation.

dvcrn Updated Sep 8, 2026 32 repo stars

File contents

🗃️ Schema Builder

From requirement to complete database structure in one step.

Usage

bash scripts/schema.sh <command> <table_name> [options]

Command Matrix

┌──────────┬──────────────────────────────┬───────────────┐
│ Command  │ Description                  │ Output        │
├──────────┼──────────────────────────────┼───────────────┤
│ design   │ Design schema from name      │ Field layout  │
│ sql      │ Generate CREATE TABLE DDL    │ SQL statement │
│ migrate  │ Generate migration script    │ Migration     │
│ seed     │ Generate test/seed data      │ INSERT stmts  │
│ erd      │ ASCII ER diagram             │ Relationship  │
│ optimize │ Index & perf recommendations │ Report        │
│ nosql    │ MongoDB schema               │ JSON schema   │
│ compare  │ Diff two schemas             │ Diff report   │
└──────────┴──────────────────────────────┴───────────────┘

Typical Flow

design → sql → migrate → seed
         ↓
       optimize
         ↓
        erd

design users — plan fields and relations
sql users — generate executable SQL
migrate users — versioned migration
seed users — populate test data
optimize users — check index suggestions

Supported Databases

Relational: MySQL, PostgreSQL, SQLite
NoSQL: MongoDB, Redis (via nosql command)

---name: schema-builderdescription: Database schema designer. Design table structures, generate SQL DDL, migration scripts, seed data, ER diagrams, optimization reports, NoSQL schemas, and schema diffs. Commands: design, sql, migrate, seed, erd, optimize, nosql, compare. Use for database design, table structure, SQL generation.---# 🗃️ Schema BuilderFrom requirement to complete database structure in one step.## Usage```bashbash scripts/schema.sh <command> <table_name> [options]```## Command Matrix```┌──────────┬──────────────────────────────┬───────────────┐│ Command │ Description │ Output │├──────────┼──────────────────────────────┼───────────────┤│ design │ Design schema from name │ Field layout ││ sql │ Generate CREATE TABLE DDL │ SQL statement ││ migrate │ Generate migration script │ Migration ││ seed │ Generate test/seed data │ INSERT stmts ││ erd │ ASCII ER diagram │ Relationship ││ optimize │ Index & perf recommendations │ Report ││ nosql │ MongoDB schema │ JSON schema ││ compare │ Diff two schemas │ Diff report │└──────────┴──────────────────────────────┴───────────────┘```## Typical Flow```design → sql → migrate → seed ↓ optimize ↓ erd```1. `design users` — plan fields and relations2. `sql users` — generate executable SQL3. `migrate users` — versioned migration4. `seed users` — populate test data5. `optimize users` — check index suggestions## Supported Databases- Relational: MySQL, PostgreSQL, SQLite- NoSQL: MongoDB, Redis (via `nosql` command)

Frequently asked questions