sync-demo-seeder

Synchronize demo seed SQL with Drizzle ORM schema and migrations.

55|1|Updated Feb 16, 2026
One-click install
npx skills add https://github.com/aaronjoeldev/cashlytics-ai --skill sync-demo-seeder
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: sync-demo-seeder
Source: https://github.com/aaronjoeldev/cashlytics-ai/tree/main/.claude/skills/sync-demo-seeder
Command: npx skills add https://github.com/aaronjoeldev/cashlytics-ai --skill sync-demo-seeder

SYSTEM DOCUMENTATION & REQUIREMENTS

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.

Frequently Asked Questions about sync-demo-seeder

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I keep my Drizzle demo seed SQL synchronized after schema migrations?

To keep your Drizzle demo seed SQL synchronized, this Skill reads your schema.ts and migration history to detect changes, then updates INSERT statements, TRUNCATE lists, and enum values in your seed file to match the current schema.

What happens to demo data when a new NOT NULL column is added to a Drizzle schema?

When a new NOT NULL column is added to a Drizzle schema, this Skill adds sensible demo values to the corresponding INSERT statements in your seed file, ensuring the demo data remains valid without manual intervention.

Can I automatically update TRUNCATE lists in my SQL seed file when database tables change?

Yes, you can automatically update TRUNCATE lists in your SQL seed file. This Skill validates and updates the lists to ensure all user-data tables are included after schema edits or migrations are applied.

Does this seed synchronization tool work with TypeScript projects using Drizzle ORM?

Yes, this seed synchronization tool works specifically with TypeScript projects using Drizzle ORM, requiring the schema in src/lib/db/schema.ts and SQL migrations in the drizzle directory.

How does the seeding process handle deleted tables and renamed columns?

The seeding process handles deleted tables by removing their corresponding INSERT sections from the seed file, and handles renamed columns by updating INSERT statements to use exact SQL column names from the current schema.

What limitations exist when synchronizing demo data with UUID formats and transaction boundaries?

A key limitation is that the Skill enforces strict hexadecimal UUID formats and preserves existing BEGIN/COMMIT transaction boundaries, meaning malformed UUIDs or broken transaction blocks must be corrected to successfully synchronize the demo seed.