db-seed

# Database Seed Generator Generate seed scripts that populate databases with realistic, domain-appropriate sample data. Reads your schema and produces ready-to-run seed files. ## Workflow ### 1. Find the Schema Scan the project for schema definitions: | Source | Location pattern | |--------|-----------------| | Drizzle schema | `src/db/schema.ts`, `src/schema/*.ts`, `db/schema.ts` | | D1 migrations | `drizzle/*.sql`, `migrations/*.sql` | | Raw SQL | `schema.sql`, `db/*.sql` | | Prisma | `prisma/schema.prisma` | Read all schema files. Build a mental model of: - Tables and their columns - Data types and constraints (NOT NULL, UNIQUE, DEFAULT) - Foreign key relationships (which tables reference which) - JSON fields stored as TEXT (common in D1/SQLite) ### 2. Determine Seed Parameters Ask the user: | Parameter | Options | Default | |-----------|---------|---------| | Purpose | dev, demo, testing | dev | | Volume | small (5-10 rows/table), medium (20-50), large (100+) | small | | Domain context | "e-commerce store", "SaaS app", "blog", etc. | Infer from schema | | Output format | TypeScript (Drizzle), raw SQL, or both | Match project's ORM | **Purpose affects data quality**: - **dev**: Varied data, some edge cases (empty fields, long strings, unicode) - **demo**: Polished data that looks good in screenshots and presentations - **testing**: Systematic data covering boundary conditions, duplicates, special characters ### 3. Plan Insert Order Build a dependency graph from...