Does it create rollback scripts automatically?

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

Which database ORMs and tools does this skill support?

The skill provides specialized support for Prisma, TypeORM, Alembic (SQLAlchemy), Sequelize, and raw SQL migrations.

Does it follow database performance best practices?

Yes, it recommends practices like adding indexes after data insertion, using transactions, and batching large migrations to minimize downtime.

Can it help with data transformations?

Absolutely. It can generate complex logic for transforming data, such as moving fields into JSONB objects or restructuring tables while preserving data.

Database Migration Helper

Name: Database Migration Helper
Author: Dexploarer

byDexploarer

•

Database Management

Generates safe, reversible database migrations and schema changes across major ORMs and raw SQL environments.

About

The Database Migration Helper skill enables Claude to act as a database architect, providing expert guidance for managing schema changes and data transformations. It supports a wide range of popular tools including Prisma, TypeORM, Alembic, and Sequelize, as well as raw SQL. The skill ensures every migration is production-ready by including reversible 'up' and 'down' logic, proper indexing, constraint management, and framework-specific CLI commands. Whether you are performing simple column additions or complex table restructures, this skill helps prevent data loss and ensures deployment stability.

Key Features

Provides framework-specific CLI commands for applying and reverting changes
Generates mandatory reversible rollback (down) scripts for every migration
Supports multiple ORMs including Prisma, TypeORM, Alembic, and Sequelize
Handles complex data transformations and table restructures using best practices
2 GitHub stars
Automates index creation and constraint management for performance and integrity

Use Cases

Writing complex data migrations to transform or normalize existing record formats
Generating framework-specific migration files for TypeORM, Prisma, or SQLAlchemy projects
Evolving a production database schema by adding, modifying, or removing tables and columns

About

Key Features

Provides framework-specific CLI commands for applying and reverting changes
Generates mandatory reversible rollback (down) scripts for every migration
Supports multiple ORMs including Prisma, TypeORM, Alembic, and Sequelize
Handles complex data transformations and table restructures using best practices
2 GitHub stars
Automates index creation and constraint management for performance and integrity

Use Cases

Writing complex data migrations to transform or normalize existing record formats
Generating framework-specific migration files for TypeORM, Prisma, or SQLAlchemy projects
Evolving a production database schema by adding, modifying, or removing tables and columns