How does the safety verification process work?

Before generating any files, the skill executes a mandatory 'Theory of Mind' checkpoint. It presents a summary of its understanding and asks for confirmation to ensure no unintended data loss occurs.

Does it automatically create rollback scripts?

Yes. For every migration generated, the skill creates corresponding 'down' logic (such as dropping a table or column) to ensure your database can be safely reverted to a previous state.

Which database frameworks does this skill support?

The skill natively supports Prisma, Knex, TypeORM, Drizzle, and raw SQL. It automatically detects which framework your project is using by scanning your configuration files.

Can it handle complex changes like adding NOT NULL columns to existing tables?

Yes, the skill includes safety checks that warn you if you're adding a NOT NULL column without a default value, which would normally fail on tables that already contain data.

Database Migration Generator

Name: Database Migration Generator
Author: dkyazzentwatwa

bydkyazzentwatwa

•

데이터베이스 관리

Automates the creation of safe database migrations with automatic framework detection and built-in rollback logic.

소개

This skill simplifies database schema evolution by automatically detecting your project's migration framework—supporting Knex, Prisma, TypeORM, Drizzle, and raw SQL. It guides users through creating new tables, modifying columns, and adding indexes while enforcing a critical verification checkpoint to ensure the AI understands the schema requirements before any changes are generated. By ensuring every 'up' migration has a corresponding 'down' migration and performing safety checks for destructive operations like dropping columns, it significantly reduces the risk of data loss and schema inconsistencies.

주요 기능

Automatic detection of Prisma, Knex, TypeORM, Drizzle, and raw SQL frameworks
29 GitHub stars
Framework-specific CLI command generation for immediate execution and testing
Mandatory Theory of Mind (ToM) verification checkpoint for high-stakes DB changes
Generates both schema changes (UP) and complete rollback logic (DOWN)
Built-in safety validation for NOT NULL constraints and destructive operations

사용 사례

Standardizing migration file naming and timestamping across a development team
Generating complex rollback logic for multi-step schema modifications
Adding new tables or columns to an existing production database schema safely

소개

주요 기능

Automatic detection of Prisma, Knex, TypeORM, Drizzle, and raw SQL frameworks
29 GitHub stars
Framework-specific CLI command generation for immediate execution and testing
Mandatory Theory of Mind (ToM) verification checkpoint for high-stakes DB changes
Generates both schema changes (UP) and complete rollback logic (DOWN)
Built-in safety validation for NOT NULL constraints and destructive operations

사용 사례

Standardizing migration file naming and timestamping across a development team
Generating complex rollback logic for multi-step schema modifications
Adding new tables or columns to an existing production database schema safely