Does this skill handle database transactions?

The skill follows best practices by encouraging the wrapping of migration steps in transactions to ensure atomicity and prevent partial schema updates.

Can I undo a migration using this skill?

Yes, the skill generates both 'up' and 'down' scripts, allowing you to rollback specific migrations or the most recent changes safely.

How are migration files named?

Files follow a standard timestamped convention (e.g., YYYYMMDDHHMMSS_description) to ensure they are applied in the correct chronological order.

Which databases are supported by the Database Migration Manager?

This skill supports generating and managing migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

Database Migration Manager

Name: Database Migration Manager
Author: BbgnsurfTech

byBbgnsurfTech

•

Gestión de Bases de Datos

Manages database schema evolution by generating and applying version-controlled migration scripts for major SQL and NoSQL databases.

The Database Migration Manager skill provides a robust framework for handling database schema changes within your development workflow. It automates the creation of timestamped migration files, complete with 'up' and 'down' scripts, ensuring that every database modification is reversible and traceable. Supporting PostgreSQL, MySQL, SQLite, and MongoDB, this skill is essential for developers who need to maintain data integrity across different environments, safely add columns, or revert problematic schema changes using best practices like idempotency and transactional safety.

Características Principales

01Automated generation of timestamped migration files

02Dual-script generation for both applying and rolling back changes

03Cross-database support for PostgreSQL, MySQL, SQLite, and MongoDB

04Identification and execution of recent migration rollbacks

05Enforcement of best practices like transactions and idempotent logic

061 GitHub stars

Casos de Uso

01Safely reverting database changes that caused unexpected application behavior

02Standardizing migration naming and structure across a multi-developer team

03Creating version-controlled schema updates when adding new application features

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection database-migration-manager

For use in Claude.ai and ChatGPT

Download Skill