What problem does it solve?
Evolving and applying database schema changes is error-prone and difficult to audit across environments; this Skill provides a repeatable workflow to generate, review, and apply SQL migrations derived from TypeScript Drizzle schemas so teams can manage schema drift safely.
Core Features & Use Cases
- Generate audited SQL migrations by diffing TypeScript schemas and producing migration folders with migration.sql and snapshot.json for review.
- Apply and track migrations against a target database using migrate, with a journal to prevent reapplication and ensure ordered execution.
- Push and pull workflows for rapid prototyping and database-first introspection, plus programmatic runtime migration support for startup or serverless deployments.
- Use Case: A backend team modifies the schema, generates a named migration, reviews SQL for destructive changes, and then applies migrations in CI and production with predictable ordering.
Quick Start
Run the generate command to produce a reviewed SQL migration file and then run migrate to apply pending changes to your database.