Are the migration files compatible with standard naming conventions?

Yes, the skill uses a timestamped naming convention (YYYYMMDDHHMMSS) to ensure that migrations are applied in the correct chronological order.

How does Claude handle migration rollbacks?

The skill generates both 'up' (apply) and 'down' (revert) scripts. When a rollback is requested, Claude identifies the last migration and executes the 'down' script.

Which databases are supported by the Database Migration Manager?

The skill currently supports PostgreSQL, MySQL, SQLite, and MongoDB, covering both relational and document-based data structures.

Can I use this skill to add a single column to a table?

Absolutely. You can request specific changes like 'add an email column to users', and Claude will generate the appropriate migration file for your specific database engine.

Database Migration Manager

Name: Database Migration Manager
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Automates the creation, application, and rollback of version-controlled database schema migrations for SQL and NoSQL databases.

This skill empowers developers to manage evolving database schemas safely and efficiently by automating the generation of timestamped migration files. Supporting PostgreSQL, MySQL, SQLite, and MongoDB, it handles both 'up' and 'down' migration scripts to ensure easy rollbacks and consistent environments across development and production. It is particularly useful for tracking schema history, adding table columns, and maintaining database integrity through idempotent, transaction-aware modifications that integrate seamlessly into your version control workflow.

Key Features

01Intelligent schema evolution tracking and version control integration

023 GitHub stars

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

04Automated generation of timestamped migration files

05Dual 'up' and 'down' script support for safe schema rollbacks

06Enforcement of idempotency and atomic transaction best practices

Use Cases

01Adding or modifying database columns and tables without manual script writing

02Synchronizing schema changes across a distributed development team

03Reverting specific database changes to a previous state during local development

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