# 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.

- Skill: `dvcrn/schema-builder` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add dvcrn/schema-builder`
- Raw SKILL.md: https://api.skillmd.com/api/skills/dvcrn/schema-builder/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: dvcrn (https://skillmd.com/u/dvcrn)
- Updated: 2026-09-08
- Page: https://skillmd.com/skills/dvcrn/schema-builder

---


# 🗃️ Schema Builder

From requirement to complete database structure in one step.

## Usage

```bash
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
```

1. `design users` — plan fields and relations
2. `sql users` — generate executable SQL
3. `migrate users` — versioned migration
4. `seed users` — populate test data
5. `optimize users` — check index suggestions

## Supported Databases

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