Claude Code Plugins

Community-maintained marketplace

Feedback

Create database migration

@majiayu000/claude-skill-registry
27
0

Create a database migration to add a table, add columns to an existing table, add a setting, or otherwise change the schema of Ghost's MySQL database.

Install Skill

Shared

Installs to .agents/skills, used by Codex, Amp, Warp, Cursor, OpenCode, and more.

CodexAmp
WarpCursorOpenCode
ClineGemini CLI
GitHub Copilot
Personal

Available across projects.

$npx skills-installer add @majiayu000/claude-skill-registry/create-database-migration --client shared
Project

Writes to .agents/skills.

$npx skills-installer add @majiayu000/claude-skill-registry/create-database-migration -p --client shared
Note: Review the skill instructions before using it.

SKILL.md

name Create database migration
description Create a database migration to add a table, add columns to an existing table, add a setting, or otherwise change the schema of Ghost's MySQL database.

Create Database Migration

Instructions

  1. Change directories into ghost/core: cd ghost/core
  2. Create a new, empty migration file using slimer: slimer migration <name-of-database-migration>. IMPORTANT: do not create the migration file manually; always use slimer to create the initial empty migration file.
  3. The above command will create a new directory in ghost/core/core/server/data/migrations/versions if needed, and create the empty migration file with the appropriate name.
  4. Update the migration file with the changes you want to make in the database, following the existing patterns in the codebase. Where appropriate, prefer to use the utility functions in ghost/core/core/server/data/migrations/utils/*.
  5. Update the schema definition file in ghost/core/core/server/data/schema/schema.js, and make sure it aligns with the latest changes from the migration.
  6. Test the migration manually: yarn knex-migrator migrate --v {version directory} --force
  7. If adding or dropping a table, update ghost/core/core/server/data/exporter/table-lists.js as appropriate.
  8. Run the schema integrity test, and update the hash: yarn test:single test/unit/server/data/schema/integrity.test.js
  9. Run unit tests in Ghost core, and iterate until they pass: cd ghost/core && yarn test:unit

Examples

See examples.md for example migrations.

Rules

See rules.md for rules that should always be followed when creating database migrations.