Which database frameworks are supported?

The skill supports popular ORMs and migration tools including Prisma, TypeORM, Alembic (Python), Sequelize (Node.js), and Raw SQL migrations.

Will it generate rollback scripts automatically?

Yes, the skill is designed to always include both 'up' and 'down' logic to ensure that every migration can be safely reverted.

Does it support both schema and data migrations?

Yes, it can generate scripts for structural schema changes (like adding columns) and data migrations (like transforming existing records into a new format).

Is it compatible with PostgreSQL-specific features like Enums?

Absolutely. It handles database-specific features like PostgreSQL ENUM types, JSONB columns, and specialized indexes.

Database Migration Helper

Name: Database Migration Helper
Author: Dexploarer

byDexploarer

•

データベース管理

Generates safe, reversible database migrations and schema transformations for multiple ORMs and raw SQL.

概要

The Database Migration Helper is a specialized skill designed to streamline database version control and schema evolution. It automates the creation of precise 'up' and 'down' migration scripts for popular frameworks like Prisma, TypeORM, Alembic, and Sequelize, as well as raw SQL. Beyond simple schema changes, it excels at complex data transformations, ensuring data integrity through transactional safety, proper indexing, and rollback support. This skill helps developers maintain production-grade databases by enforcing best practices and reducing the risk of manual migration errors.

主な機能

Supports multiple ORMs including Prisma, TypeORM, Alembic, and Sequelize
2 GitHub stars
Automates index creation and constraint management for performance
Generates reversible migration scripts with both 'up' and 'down' logic
Handles complex data transformations and table restructures
Enforces migration best practices like transactional safety and batching

ユースケース

Performing data-only migrations to transform existing records during a schema update
Creating schema migrations for adding, renaming, or deleting tables and columns
Generating framework-specific CLI commands for applying and rolling back migrations

概要

主な機能

Supports multiple ORMs including Prisma, TypeORM, Alembic, and Sequelize
2 GitHub stars
Automates index creation and constraint management for performance
Generates reversible migration scripts with both 'up' and 'down' logic
Handles complex data transformations and table restructures
Enforces migration best practices like transactional safety and batching

ユースケース

Performing data-only migrations to transform existing records during a schema update
Creating schema migrations for adding, renaming, or deleting tables and columns
Generating framework-specific CLI commands for applying and rolling back migrations