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.34x

Quality

72%

Does it follow best practices?

Impact

94%

1.34x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./plugins/database/database-migration-manager/skills/managing-database-migrations/SKILL.md

Evaluation results

100%

51%

Email Verification Compliance Migration

UP migration safety practices and changelog

Criteria

Without context

With context

Flyway naming convention

100%

Nullable column first

100%

Backfill before NOT NULL

30%

100%

NOT NULL applied after backfill

100%

IF NOT EXISTS idempotency

100%

Transaction wrapping

100%

Business reason comments

100%

DOWN migration reverses UP

100%

DOWN cleans up enum/type

100%

Changelog all required fields

60%

100%

Shipping Address Extraction Migration

Zero-downtime expand-contract migration

Criteria

Without context

With context

Expand phase: new table only

100%

Expand phase: dual-write described

80%

100%

Migrate phase: batch backfill

70%

100%

Contract phase: separate step

100%

Contract phase: old removal deferred

100%

Pre-flight script created

100%

Pre-flight checks access/connectivity

100%

Rollback runbook created

100%

Rollback covers all phases

100%

Changelog all required fields

80%

100%

84%

15%

Multi-Tenant Data Isolation Migration

Large table migration with schema capture

Criteria

Without context

With context

Schema captured before changes

100%

Online DDL tool selected

Column added as nullable first

100%

Separate backfill script

100%

Backfill uses batches

100%

NOT NULL applied after backfill

100%

lock_timeout configured

100%

DOWN migration included

100%

80%

Changelog includes execution time estimate

100%

Transaction wrapping on DDL

80%

100%

Repository: jeremylongshore/claude-code-plugins-plus-skills
Commit: 3a2d27d

Evaluated: 1 day ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Email Verification Compliance Migration Shipping Address Extraction Migration Multi-Tenant Data Isolation Migration

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.