Menu
Guide safe database and code migrations with zero-downtime strategies.
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/nguyenthienthanh/aura-frog --skill migration-helperThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Based on SOC occupation classification
Vision feedback loop for UI โ render the running UI, screenshot it across viewports + dark mode, run deterministic gates then a multimodal critique against the design system, and iterate until it passes. Use after building or changing a UI component/page, when asked to 'check the UI', make it 'look right', or verify a build matches a design spec / Stitch screen.
UI/UX design expertise โ component design, design system selection, responsive layout. Includes auto-detection from package.json and Context7 integration for library docs.
Generate a cohesive color-token system from ONE OKLCH brand hue โ primary/secondary/background/foreground/muted/border with semantic light + dark, emitted as a Tailwind v4 @theme block or a CSS-variables fallback. Use when starting a design system, defining brand colors, setting up theming/dark-mode, or replacing scattered hardcoded colors with a derived palette.
Showing SKILL.md
| name | migration-helper |
| description | Guide safe database and code migrations with zero-downtime strategies. |
| autoInvoke | false |
| priority | medium |
| triggers | ["database migration","code migration","zero-downtime"] |
| user-invocable | false |
AI-consumed reference. Optimized for Claude to read during execution. Human-readable explanation: see docs/architecture/HIERARCHICAL_PLANNING.md or docs/getting-started/ depending on topic.
Safe database and code migrations with zero-downtime strategies.
rules/core/simplicity-over-complexity.md โ smallest migration that closes the gap; no "while we're here" schema expansionsrules/core/verification.md โ verify each migration step before advancingrules/workflow/immutable-workflow.md โ migrations are append-only recordsrules/workflow/dual-llm-review.md โ destructive migrations (DROP COLUMN/TABLE) trigger dual-LLM review| Change | Safe Approach |
|---|---|
| Add column | Add nullable โ backfill โ NOT NULL |
| Remove column | Stop using โ deploy โ drop |
| Rename column | Add new โ copy โ deploy โ drop old |
| Add index | CREATE INDEX CONCURRENTLY |
| Change type | Add new col โ migrate โ drop old |
Add nullable โ dual-write โ backfill โ switch reads โ remove old writes โ drop old column.
export async function up(db: Database) {
await db.query(`ALTER TABLE users ADD COLUMN status VARCHAR(20) DEFAULT 'active'`);
// Backfill in batches of 1000
// Add NOT NULL constraint
}
export async function down(db: Database) {
await db.query(`ALTER TABLE users DROP COLUMN status`);
}
Before: Backup, tested on staging, rollback plan, monitoring alerts. During: Batch processing, monitor performance, verify integrity. After: Validation queries, smoke tests, monitor 24-48h, document.
| Strategy | When |
|---|---|
| Script rollback | Reversible data changes |
| Backup restore | Major failure |
| Feature flag off | Code changes |
| Traffic reroute | Service migration |