Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Create Database Migration · tryghost | DecimalAI

databy tryghost

Create Database Migration

tryghost/Create database migration

Source tryghost/ghost ↗License MIT

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.

SkillScore95Maintained

Automatic

Coding pack

Last verified 9/27/2026

What it changes

Passed 21 of 22 test cases with the skill, and 8 of 22 without it.

Without skill36%

With skill95%

Checks it passed that the model alone missed

Points to docs/practices/database-migrations.md.
Instructs running pnpm test:unit within ghost/core.
Does not instruct modifying schema.js or updating table-lists.js.

and 20 more in the full report

14 fixed7 passed either way0 still failing1 broke

Pass-rate lift: +59 pp
Tokens: -34%
Agent turns: 0%
Response time: -63%

Model gemini-3.6-flashMeasured 9/27/2026v1 · latest is v321 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

This benchmark measured an earlier version of the skill.

A newer attempt on gemini-3.6-flash on 10/4/2026 did not produce a publishable comparison (not comparable). The snapshot above is the previously measured run.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/tryghost-create-database-migration/SKILL.md https://app.decimal.ai/s/tryghost-create-database-migration/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add tryghost-create-database-migration, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/tryghost-create-database-migration/ and pins it in .decimal/skills.lock

decimalai skills add tryghost-create-database-migration

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/tryghost-create-database-migration/SKILL.md https://app.decimal.ai/s/tryghost-create-database-migration/SKILL.md

Raw file: /s/tryghost-create-database-migration/SKILL.md ↗ · machine-readable summary at /s/tryghost-create-database-migration.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 14 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 14

Prompt

Before executing database migration steps in Ghost core, where in the repository is the canonical human guidance document located?

What was checked, without and with the skill
Checked	Without skill	With skill
Points to docs/practices/database-migrations.md.	Missed	Passed

case-22 · gemini-3.6-flash · 9/27/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md32 linessingle file

Create Database Migration

Read the canonical human guidance in docs/practices/database-migrations.md before making a migration. This skill is the executable checklist that accompanies it.

Instructions

If you are adding a new table whose shape is still changing, consider marking it as in development instead of writing a migration yet; see "New tables still in development" in the guide.

Create a new, empty migration file: pnpm gx generate migration <kebab-case-slug> from the repository root. IMPORTANT: do not create the migration file manually; always use this script to create the initial empty migration file. The slug must be kebab-case (e.g. add-column-to-posts).
The above command will create a new directory in ghost/core/server/data/migrations/versions if needed, create the empty migration file with the appropriate name, and bump the core and admin package versions to RC if this is the first migration after a release.
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/server/data/migrations/utils/*.
Update the schema definition file in ghost/core/server/data/schema/schema.js, and make sure it aligns with the latest changes from the migration.
Test the migration manually from the repository root: pnpm knex-migrator migrate --v {version directory} --force
Roll the migration back to test down(): pnpm knex-migrator rollback --v {previous version} --force, then migrate forward again.
Run the migration integration test, which covers initialization, rollback, forward migration, and idempotency: cd ghost && pnpm test:single test/integration/migrations/migration.test.js. It needs MySQL running, which pnpm dev starts.
If adding or dropping a table, update ghost/core/server/data/exporter/table-lists.js as appropriate. The consistency assertion in ghost/test/unit/server/data/exporter/index.test.js checks that every schema table is classified in the exporter lists.
Run the focused exporter unit test when the table lists change: cd ghost && pnpm test:single test/unit/server/data/exporter/index.test.js.
Run the schema integrity test, and update the hash: cd ghost && pnpm test:single test/unit/server/data/schema/integrity.test.js
Run unit tests in Ghost core, and iterate until they pass: cd ghost && pnpm test:unit

Examples

See examples.md for example migrations.

Rules

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

Track record

Benchmark

21 / 22

test cases passed, vs 8 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v6 — 10/15/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

tryghost / ghost

.agents/skills/create-database-migration/SKILL.md

View on GitHub ↗

License MITImported 10/15/2026Version v3

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Create Database Migration

Instructions

Examples

Rules

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills