Run and manage database migrations from the CommandBox CLI.
npx skills add https://github.com/ColdBox/skills --skill commandbox-migrations
Please help me install this Agent Skill. Skill: commandbox-migrations Source: https://github.com/ColdBox/skills/tree/main/modules/commandbox-migrations Command: npx skills add https://github.com/ColdBox/skills --skill commandbox-migrations
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.
Use the CommandBox migrate commands to install the migrations table and run pending migrations for your application environment.
High-intent search queries and answers about installing and using this skill.
Database migrations run safely from the CommandBox CLI by installing the cfmigrations tracking table and applying pending schema changes, using safe production patterns like only running migrate up to prevent unintended rollbacks during deployments.
Timestamped migration files are created and applied through CommandBox migrate commands, generating consistent schema changes across local development, CI/CD pipelines, and production environments to reduce deployment errors and schema drift.
CommandBox migrations supports MSSQL, MySQL, PostgreSQL, and SQLite drivers, allowing configuration of named connections and settings via .cfmigrations or box.json files for consistent schema management across different database platforms.
The best way to rollback and refresh database migrations during development is using CommandBox migrate commands to perform targeted rollbacks, full resets, or destructive refreshes with optional seeding to quickly rebuild your schema state.
Database seeders run when resetting your development database by executing CommandBox migrate refresh commands with optional seeding, which destructively refreshes the schema and populates it with seed data for local development workflows.
You should only run migrate up in production CI/CD pipelines because rollback and refresh commands are destructive operations that can cause data loss, so applying pending migrations exclusively ensures safe, forward-only schema changes during deployments.
cenjieAutomate type-safe Drizzle ORM schemas, queries, relations, transactions, and migrations.
ajsai47Merge GitHub pull requests and verify production health after deployment.
ColdBoxCreate and apply versioned database migrations for ColdBox/BoxLang projects.
Ayub-KhanPlan and execute versioned database migrations with rollback capabilities.
