Create database migration

To create a Ghost CMS database migration, this Skill uses the `slimer` tool to generate a new, empty migration file with proper naming conventions, then guides you through updating the central `schema.js` definition file to reflect the changes before applying them.

Adding a table to the Ghost database schema involves generating a migration file, updating the schema definition in `schema.js` to include the new table structure, and running schema integrity tests to ensure the changes apply correctly.

`knex-migrator` executes the generated database migration files to apply schema changes to the Ghost CMS database, handling the actual data manipulation and structural updates defined during the migration creation workflow.

Yes, you must manually update the central `schema.js` definition file to reflect any new columns or settings added to the Ghost database, ensuring the schema definition stays synchronized with your migration file changes.

Yes, this Skill includes steps for manual migration testing and running schema integrity tests, allowing you to validate that adding tables, columns, and settings works correctly before merging the Ghost CMS changes.

Using `slimer` for Ghost database migrations is limited to generating empty migration files with correct structure; it does not automatically define the schema logic, meaning you must manually implement the table definitions and data manipulation steps.