database

What problem does it solve? Writing database migrations and seed data by hand is error-prone: missed rollback scripts, broken foreign key ordering, and destructive changes applied without review can corrupt production data. This Skill standardizes how migrations, seeds, factories, and fixtures are created across different ORMs and migration tools. ## Core Features & Use Cases - Migration Generation: Detects the project's migration tool (Prisma, Knex, Alembic, Flyway, Django, Goose) and generates forward and rollback migrations following its naming conventions. - Safety Gates: Requires explicit user confirmation before destructive operations like dropping columns, changing types, or adding NOT NULL constraints to populated tables. - Seed Data & Factories: Reads the actual schema and generates seed scripts, test factories, or fixtures that respect foreign key ordering, constraints, and enums. - Use Case: You need to add an author_id column to a posts table. The Skill produces a reversible migration, a backfill script for existing rows, and updated seed data ordered users → posts → comments. ## Quick Start Use the database skill to create a migration adding an author_id foreign key to the posts table and generate matching seed data.