# Ccc Pro Migration

> Zero-downtime schema versioning, backfills, and safe deploy patterns · Pro tier only

- Skill: `kevinzai/ccc-pro-migration` (Agent Skill)
- Install (CLI): `npx skillmds@latest add kevinzai/ccc-pro-migration`
- Raw SKILL.md: https://api.skillmd.com/api/skills/kevinzai/ccc-pro-migration/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: DevOps & Infra
- Author: KevinZai (https://skillmd.com/u/kevinzai)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/kevinzai/ccc-pro-migration

---


## What this pack will do

- Generate expand-contract migration plan for any schema change (add → backfill → switch → drop)
- Scaffold zero-downtime column rename: dual-write phase → backfill → cutover → cleanup
- Generate zero-downtime index creation scripts (CREATE INDEX CONCURRENTLY patterns)
- Scaffold large-table backfill runner: chunked updates with rate limiting and progress tracking
- Generate migration safety checklist: lock acquisition risk, rollback path, estimated duration
- Scaffold blue-green schema deploy with feature-flag gate
- Add migration CI gate: blocks deploy if migration is unsafe (table locks, missing rollback)
- Generate rollback scripts alongside every forward migration (auto-paired)
- Scaffold data type coercion migrations: int→bigint, varchar→text, nullable→not null
- Add foreign key deferral strategy for large cross-table migrations
- Generate Drizzle ORM migration wiring (schema push + migration file management)
- Generate Prisma migration wiring with shadow database support
- Scaffold multi-database migration sequencing: primary + replicas + read-replica lag checks
- Add post-migration verification queries: row counts, null checks, index health

## Why Pro-only

Zero-downtime migrations are one of the highest-risk operations in production databases. The wrong index creation or column rename can lock a production table for minutes. The patterns here represent hard-won production experience with PostgreSQL, MySQL, and SQLite at scale — not documentation copy-paste.

## Coming in v4.2

This skill is scaffolded. Full implementation ships in v4.2. Sign up at [commanderplugin.com/pro](https://commanderplugin.com/pro) to get notified and receive early access.

## Tier check

This skill checks `isPro()` from `commander/cowork-plugin/lib/license.js` before running. If your license tier is `starter`, it surfaces an upgrade prompt and exits cleanly — no partial scaffolding, no silent failure.

## Reference

- [Pricing and tiers](https://commanderplugin.com/pricing)
- [Free vs Pro comparison](https://commanderplugin.com/free-vs-pro)
- [License activation](/plugin/license-activation)