Can I use this for NoSQL databases like MongoDB?

Yes, the skill includes support for MongoDB migration patterns alongside traditional relational databases.

Which databases are supported by this migration manager?

The skill currently supports PostgreSQL, MySQL, SQLite, and MongoDB, providing specific syntax for each.

How does the skill handle failed migrations?

It generates 'down' scripts for every 'up' migration and encourages the use of transactions to ensure migrations either succeed completely or fail without leaving the database in an inconsistent state.

Does it follow standard industry naming conventions?

Yes, it uses timestamp-prefixed filenames (YYYYMMDDHHMMSS) to ensure chronological order and prevent naming collisions in version control.

Database Migration Manager

Name: Database Migration Manager
Author: BbgnsurfTech

byBbgnsurfTech

•

数据库管理

Manages database schema evolution by generating and executing version-controlled migrations for PostgreSQL, MySQL, SQLite, and MongoDB.

This skill automates the complex process of database version control by allowing Claude to generate timestamped migration files with both 'up' and 'down' scripts. It streamlines schema modifications—such as adding columns or modifying tables—while ensuring safety through rollback capabilities and support for transactions across major database systems including PostgreSQL, MySQL, and MongoDB. By enforcing best practices like idempotency and naming conventions, it ensures that your database evolution remains organized and reversible.

主要功能

01Intelligent rollback identification for the most recent changes

02Automated generation of timestamped migration files

03Dual-track migration scripts with 'up' and 'down' logic

04Support for PostgreSQL, MySQL, SQLite, and MongoDB syntax

05Transaction-aware execution to ensure database atomicity

061 GitHub stars

使用场景

01Safely rolling back a database to a previous state after a failed deployment

02Creating and applying new schema changes such as adding or removing columns

03Synchronizing database structures across development, staging, and production environments

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