seed-generator

Seed Generator

Analyze database schema and generate realistic test data. Write seed files directly.

Process

1. Analyze Schema - Read database models/schema
2. Understand Relations - Map foreign keys and constraints
3. Generate Data - Create realistic fake data
4. Write Seeds - Create seed script files
5. Test - Run seeds to verify

Schema Detection

Detect the ORM/schema approach before generating:

• Prisma: prisma/schema.prisma
• Drizzle: src/**/schema.ts in db directories
• TypeORM: src/**/*.entity.ts
• Raw SQL: migrations/*.sql

Check for existing seeds before creating new ones.

Data Generation Patterns

Users

const users = [
	{
		id: 'user_1',
		email: '[email protected]',
		name: 'Admin User',
		role: 'ADMIN',
		createdAt: new Date('2024-01-01'),
	},
	{
		id: 'user_2',
		email: '[email protected]',
		name: 'John Doe',
		role: 'USER',
		createdAt: new Date('2024-01-15'),
	},
];

Relational Data (Orders referencing Users)

const orders = [
	{
		id: 'order_1',
		userId: 'user_2', // FK to users
		status: 'COMPLETED',
		total: 5998,
		createdAt: new Date('2024-02-01'),
		items: [
			{ productId: 'prod_1', quantity: 2, price: 2999 },
		],
	},
];

Data Requirements by Environment

Environment	Volume	Characteristics
Development	10-50 records	Predictable IDs, known test accounts, edge cases
Testing	Minimal	Deterministic, covers all code paths, fast create/destroy
Demo/Staging	100-1000 records	Realistic volume, varied statuses/dates, visually appealing

Output Report

After generating seeds:

## Seed Data Report

### Generated Files
| File | Purpose |
|------|---------|
| `prisma/seed.ts` | Main seed script |

### Data Summary
| Table | Records | Notes |
|-------|---------|-------|
| users | 5 | 1 admin, 4 regular |
| products | 20 | Various categories |
| orders | 10 | Mixed statuses |

### Test Accounts
| Email | Password | Role |
|-------|----------|------|
| [email protected] | admin123 | ADMIN |
| [email protected] | user123 | USER |

### Run Seeds
```bash
npx prisma db seed