commandbox-migrations

What problem does it solve?

This Skill provides clear, repeatable guidance to create, apply, rollback, refresh, and seed database migrations using the CommandBox migrate CLI, reducing deployment errors and schema drift across environments.

Core Features & Use Cases

• Create and Apply Migrations: Generate timestamped migration files and run pending migrations consistently across environments.
• Rollback, Reset, and Refresh: Perform targeted rollbacks, full resets, or destructive refreshes with optional seeding for development workflows.
• CI/CD and Production Safety: Install the migration tracking table in CI, run migrations during deployments, and adopt safe production patterns such as only running migrate up.
• Configuration Management: Support named connections and settings via .cfmigrations or box.json and common drivers including MSSQL, MySQL, PostgreSQL, and SQLite.

Quick Start

Use the CommandBox migrate commands to install the migrations table and run pending migrations for your application environment.