sync-demo-seeder

What problem does it solve?

This Skill automates keeping the demo seed SQL file in sync with the current Drizzle ORM schema and applied migrations so the demo dataset remains valid after schema changes.

Core Features & Use Cases

• Schema reconciliation: Read src/lib/db/schema.ts and all SQL migration files in drizzle/ to detect added, removed, or renamed tables, columns, and enum variants.
• Seed repair: Update scripts/seed-demo.sql to ensure the TRUNCATE lists all user-data tables, INSERT statements use exact SQL column names, add sensible demo values for new NOT NULL columns, and remove sections for deleted tables.
• Use Case: When a new migration or schema change introduces a column, enum change, or table change, run this Skill to produce a clear change plan and apply safe updates to the demo seed so demo resets remain consistent.

Quick Start

Synchronize scripts/seed-demo.sql with the current schema and migrations and output a concise, table-by-table plan of the exact edits before changing the file.