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.

주요 기능

Intelligent rollback identification for the most recent changes
Automated generation of timestamped migration files
Dual-track migration scripts with 'up' and 'down' logic
Support for PostgreSQL, MySQL, SQLite, and MongoDB syntax
Transaction-aware execution to ensure database atomicity
1 GitHub stars

사용 사례

Safely rolling back a database to a previous state after a failed deployment
Creating and applying new schema changes such as adding or removing columns
Synchronizing database structures across development, staging, and production environments

소개

주요 기능

Intelligent rollback identification for the most recent changes
Automated generation of timestamped migration files
Dual-track migration scripts with 'up' and 'down' logic
Support for PostgreSQL, MySQL, SQLite, and MongoDB syntax
Transaction-aware execution to ensure database atomicity
1 GitHub stars

사용 사례

Safely rolling back a database to a previous state after a failed deployment
Creating and applying new schema changes such as adding or removing columns
Synchronizing database structures across development, staging, and production environments