How are the migration files named?

Files use a standard YYYYMMDDHHMMSS timestamp prefix followed by a descriptive name to ensure correct execution order and version tracking.

Does it handle migration rollbacks?

Yes, the skill automatically generates 'down' migration scripts and can identify and execute the rollback of the most recently applied migration.

Does it ensure data safety during migrations?

The skill follows best practices by wrapping migrations in transactions where supported and ensuring scripts are idempotent to prevent unintended side effects.

Which databases does the Migration Manager support?

This skill supports a wide range of databases including PostgreSQL, MySQL, SQLite, and MongoDB.

Can I use this for NoSQL databases like MongoDB?

Yes, unlike many traditional tools, this skill includes specific support for managing schema evolution within MongoDB.

Database Migration Manager

Name: Database Migration Manager
Author: intent-solutions-io

byintent-solutions-io

0•

Database Management

Automates the creation, application, and rollback of version-controlled database migrations across SQL and NoSQL environments.

This skill streamlines database schema management by enabling Claude to generate timestamped migration files with corresponding 'up' and 'down' scripts. Whether you need to add columns, modify tables, or revert recent changes, it ensures consistency and safety across PostgreSQL, MySQL, SQLite, and MongoDB. By handling the boilerplate of migration logic and following best practices like idempotency and transactional integrity, it helps developers maintain a reliable and auditable history of their database evolution directly through natural language commands.

Key Features

01Automated generation of timestamped migration files for version control

02Support for 'up' and 'down' scripts to enable safe schema rollbacks

03Multi-database compatibility for PostgreSQL, MySQL, SQLite, and MongoDB

04Context-aware SQL/NoSQL generation for adding columns or modifying tables

05Implementation of best practices including idempotency and transactional atomicity

060 GitHub stars

Use Cases

01Generating a new migration to add or modify table columns using natural language

02Executing a rollback to safely revert the most recent database schema change

03Standardizing migration file structures across a multi-database project environment

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla database-migration-manager

For use in Claude.ai and ChatGPT

Download Skill