Create database migration

Create versioned Ghost MySQL schema migrations with Slimer and validate via knex-migrator.

3|Updated Feb 13, 2026

Search Tags:#automation #database #schema #migration #mysql #ghost #knex

Ready to run

npx skills add https://github.com/ahiendz/DuAnCuoiKhoa --skill create-database-migration-ahiendz

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Create database migration
Source: https://github.com/ahiendz/DuAnCuoiKhoa/tree/main/.agents/skills/create-database-migration
Command: npx skills add https://github.com/ahiendz/DuAnCuoiKhoa --skill create-database-migration-ahiendz

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers create database migrations for Ghost's MySQL schema, enabling controlled changes to tables, columns, and settings.

Core Features & Use Cases

Guided migration creation: generates versioned migration files using Slimer and updates the Ghost schema.
Schema synchronization: coordinates changes between migration files and the Ghost core schema.js to ensure consistency.
Validation workflow: includes manual testing steps with knex-migrator and schema integrity checks to prevent regressions.

Quick Start

Change into the project core directory and run the Slimer migration command to create your first migration.

Frequently Asked Questions about Create database migration

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I create a database migration for Ghost's MySQL schema?▼

To create a database migration for Ghost's MySQL schema, you generate versioned migration files using Slimer, update the Ghost core schema.js to synchronize structural changes, and validate the updates with knex-migrator to ensure consistency.

How do I add new tables and alter columns in a Ghost MySQL database?▼

You can add new tables, alter existing columns, or introduce new settings in a Ghost MySQL database by implementing idempotent migrations that generate versioned files and coordinate changes with the Ghost core schema.js.

When do I need to update the Ghost schema.js file for a database migration?▼

You need to update the Ghost schema.js file whenever you create database migrations to modify tables, columns, or settings, ensuring schema synchronization between the versioned migration files and the core database structure.

Does Ghost support idempotent database migrations using knex-migrator?▼

Yes, Ghost supports idempotent database migrations by generating versioned files with Slimer, updating the core schema.js, and validating the schema integrity with knex-migrator to prevent regressions across environments.

What's the best way to validate a MySQL schema migration in Ghost?▼

The best way to validate a MySQL schema migration in Ghost is to perform manual testing steps with knex-migrator and run schema integrity checks to ensure consistency and prevent regressions in development and production environments.