What happens after the migration file is created?

The skill guides the user to update schema.js, modify table lists if necessary, and run manual migration tests using yarn knex-migrator.

How does it handle schema integrity?

It includes specific steps to run schema integrity tests and update the integrity hash, ensuring the codebase matches the database state.

Does this skill work with any SQL database?

This skill is specifically optimized for the Ghost CMS ecosystem and its use of MySQL and the Knex-migrator framework.

What tool does this skill use to create migrations?

The skill utilizes the 'slimer' CLI tool to ensure that migration files are created with the correct naming conventions and placed in the appropriate directory structure.

Ghost CMS Database Migration

Name: Ghost CMS Database Migration
Author: iBoostAI

byiBoostAI

0•

数据库管理

Automates the creation, implementation, and testing of database schema migrations for Ghost CMS.

This skill provides a structured workflow for modifying the Ghost CMS MySQL database schema, ensuring consistency across migrations, schema definitions, and integrity tests. It guides Claude through using the slimer CLI tool to generate boilerplate, implementing changes using Ghost's native utility functions, and validating updates with knex-migrator and unit tests to prevent regressions and maintain database health.

主要功能

01Step-by-step validation using knex-migrator and core unit tests

02Automated migration boilerplate generation via slimer CLI

03Integration with Ghost's internal migration utility library

040 GitHub stars

05Automated schema integrity test updates and hash regeneration

06Schema definition synchronization for schema.js alignment

使用场景

01Adding new custom tables to the Ghost CMS database architecture

02Modifying existing table columns or adding new settings to the Ghost schema

03Refactoring database structures while maintaining schema integrity and test coverage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add iboostai/ghost create-database-migration

For use in Claude.ai and ChatGPT

Download Skill