database-migration
ゼロダウンタイム戦略、データ変換、ロールバック手順を使用して、ORM間およびプラットフォーム間でデータベース移行を実行します。データベースの移行、スキーマの変更、データ変換の実行、またはゼロダウンタイムデプロイメント戦略の実装時に使用します。
Security Assessment
About database-migration
The database-migration skill allows users to perform database migrations, schema changes, and data transformations across different platforms and ORMs (Object-Relational Mappers) such as Sequelize, TypeORM, and Prisma. It solves the problem of managing and executing database migrations in a way that minimizes downtime, providing strategies like zero-downtime deployments and rollback procedures. This skill is designed to ensure smooth transitions during schema updates, data model changes, and database upgrades by offering precise control over the migration process. Whether you're working with different ORM frameworks or upgrading your database version, this skill is essential for maintaining operational stability during critical database changes.
FAQ
How can I perform a migration using Sequelize?
To perform a migration with Sequelize, use the command `npx sequelize-cli db:migrate` to execute the migration and `npx sequelize-cli db:migrate:undo` to roll it back.
What ORM frameworks does this skill support?
This skill supports Sequelize, TypeORM, and Prisma for database migrations, schema changes, and data transformations.
Can I implement zero-downtime deployment with this skill?
Yes, the skill includes features and strategies for implementing zero-downtime deployment, such as adding columns with default values, renaming columns safely, and gradually applying changes.
What should I do if I need to rename a column without causing downtime?
To rename a column without downtime, follow a multi-step process: first, add the new column, copy the data, then update your application to use the new column, and finally remove the old column.
Is there support for rolling back migrations?
Yes, this skill supports rollback procedures. For Sequelize, TypeORM, and Prisma, you can use the respective commands to undo migrations.
Install database-migration
Quick Setup:
- Copy the skill folder to
.claude/skills/ - Claude will automatically detect and use the skill
Repository
amurata/cc-tools