Seed Data Generator Protocol

This skill helps developers populate empty local or staging databases with massive amounts of realistic data for load testing and UI development.

Core assumption: Simple random strings (asdfgh) are useless for UI testing. Seed data must look real and respect Foreign Key constraints to successfully insert.

1. Schema Analysis & Topological Sort

Before generating data, read the schema and understand the relationships:

• If orders depends on users and products.
• If order_items depends on orders and products.
• Topological Sort (Insert Order): users -> products -> orders -> order_items.

(Never try to insert an order item before the order exists).