managing-database-migrations

Process use when you need to work with database migrations. This skill provides schema migration management with comprehensive guidance and automation. Trigger with phrases like "create migration", "run migrations", or "manage schema versions".

1.06x

Quality

—

Does it follow best practices?

Impact

88%

1.06x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Evaluation results

100%

19%

Adding Email Verification Tracking to the Customers Table

Safe NOT NULL column addition with Flyway

Criteria

Without context

With context

Flyway naming convention

100%

Column nullable first

100%

Backfill before NOT NULL

100%

NOT NULL applied separately

100%

IF NOT EXISTS usage

100%

Transaction wrapping

100%

Business reason comments

40%

100%

DOWN migration reverses UP

100%

Pre-flight validation script

100%

Changelog completeness

70%

100%

73%

-11%

Splitting User Profile Data Into a Dedicated Service Table

Zero-downtime expand-contract table split

Criteria

Without context

With context

Expand phase: adds without removing

100%

Expand phase: dual-write strategy

100%

20%

Migrate phase: batched data copy

100%

Contract phase: separate migration

100%

Three phases are distinct

100%

DOWN migration handles existing data

20%

30%

Rollback runbook completeness

100%

Migration naming convention

50%

30%

Business reason comments

100%

50%

Changelog completeness

70%

100%

92%

Renaming a High-Traffic Column on a 15-Million-Row MySQL Payments Table

Large table column rename with online DDL tools

Criteria

Without context

With context

Online DDL tool used

25%

33%

New column added first

100%

Data sync / trigger step

100%

Batched backfill

100%

Old column dropped separately

100%

Knex migrate:make command

100%

DOWN function reverts

100%

Pre-flight validation script

100%

Business reason comments

37%

100%

Changelog completeness

100%

New column nullable initially

100%

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 607d11b

Evaluated: about 1 month ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Adding Email Verification Tracking to the Customers Table Splitting User Profile Data Into a Dedicated Service Table Renaming a High-Traffic Column on a 15-Million-Row MySQL Payments Table

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.