Database schema designer. Design table structures, generate SQL DDL, migration scripts, seed data, ER diagrams, optimization reports, NoSQL schemas, and sche...
From requirement to complete database structure in one step.
bash scripts/schema.sh <command> <table_name> [options]
┌──────────┬──────────────────────────────┬───────────────┐
│ 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 │
└──────────┴──────────────────────────────┴───────────────┘
design → sql → migrate → seed
↓
optimize
↓
erd
design users — plan fields and relationssql users — generate executable SQLmigrate users — versioned migrationseed users — populate test dataoptimize users — check index suggestionsnosql command)ZIP package — ready to use