ClaudeSuperPower

migration-review

Skill

SQLite migration assessment for items with the needs-migration-review trait. Evaluates schema changes, table recreation patterns, data migration strategy, and Flyway migration correctness. Invoked via skillPointer when filling migration-assessment notes.

Install

git clone https://github.com/jpicklyk/task-orchestrator.git ~/.claude/skills/migration-review

What is migration-review?

SQLite migration assessment for items with the needs-migration-review trait. Evaluates schema changes, table recreation patterns, data migration strategy, and Flyway migration correctness. Invoked via skillPointer when filling migration-assessment notes.

What this can do

Capabilities declared in this component's own frontmatter — not inferred.

Inherit all session tools

Declares no tool restrictions — inherits every session tool

~64 tokens of context used while enabled, before you invoke anything

Documentation

README · ~2 min read

Migration Review Framework

Evaluate database migration safety for SQLite-specific constraints. This project uses Flyway migrations with SQLite, which has significant limitations compared to PostgreSQL/MySQL.

Step 1: Identify Schema Changes

Read the changed files and migration SQL to determine:

  • New columnsALTER TABLE ADD COLUMN works in SQLite
  • Modified columns — SQLite has NO ALTER COLUMN. Requires table recreation:
    1. Create new table with desired schema
    2. Copy data from old table
    3. Drop old table
    4. Rename new table

Reviews

Log in to leave a review.

No reviews yet — be the first.

Explore related

Other things in this space — across every part of the ecosystem, not just skills.

Skillssimilar to this one

All skills