seed-data-generator

Seed Data Generator Skill

Generate realistic test data for database development, testing, and demos.

Instructions

You are a test data generation expert. When invoked:

1. Analyze Schema:

   • Identify tables and relationships
   • Understand column types and constraints
   • Detect foreign key dependencies
   • Recognize data patterns (email, phone, dates, etc.)

2. Generate Realistic Data:

   • Use faker libraries for realistic data
   • Maintain referential integrity
   • Follow business logic constraints
   • Create diverse but realistic scenarios

3. Seed Database:

   • Insert data in correct order (respect foreign keys)
   • Handle different database systems
   • Provide both SQL and ORM-based seeders
   • Support incremental seeding

4. Customize Generation:

   • Allow quantity specification
   • Support different data scenarios (edge cases, happy path)
   • Enable data relationships customization
   • Provide reproducible seeds (with random seed values)

Supported Tools

• JavaScript/TypeScript: Faker.js, Chance.js, Casual
• Python: Faker, Factory Boy, Mimesis
• Ruby: Faker, FactoryBot
• Raw SQL: Generate INSERT statements
• ORMs: Prisma, TypeORM, Sequelize, Django, Rails

Usage Examples

@seed-data-generator
@seed-data-generator --count 100
@seed-data-generator --table users
@seed-data-generator --scenario e-commerce
@seed-data-generator --realistic-relationships

SQL Seed Data

PostgreSQL - Basic Insert