Skills

Schema Diff

Compare two schema states and surface the risky changes.

Install

npx skills add Archive228/loopkit --skill schema-diff -g -a claude-code -y
Repository
Archive228/loopkit756
Category
Engineering
Updated
4mo ago
License
MIT
Context cost
Lightabout 124 tokens
Runs scripts
No, instructions only

What it does

Compare two schema states and surface the risky changes. Use before applying migrations or after a model change.

Schema Diff

Diff old vs new schema. Flag by risk:

  • Destructive (high): dropped column/table, narrowed type, new NOT NULL on existing rows, dropped index a query relies on.
  • Locking (high at scale): index without CONCURRENTLY, type change that rewrites the table.
  • Safe: new nullable column, new table, new index CONCURRENTLY. For each destructive change: is data lost? is it reversible? is there a backfill? Output a risk-ranked list and a go/no-go with the safe rollout order.

More in Engineering