← ClaudeAtlas

engine_migrationslisted

Maintain Subfloor's schema baseline, ordered migration ledger, live-DB backup boundary, rebuild/update compatibility, and source-repository migration files. Admin-only by default.
jedbjorn/subfloor · ★ 28 · API & Backend · score 78
Install: claude install-skill jedbjorn/subfloor
# engine_migrations — maintain Subfloor's database floor Subfloor owns `.super-coder/schema.sql` as the current baseline and `.super-coder/migrations/*.sql` as ordered additive deltas. The `schema_migrations` ledger applies each delta once. `sc rebuild` creates the baseline, applies every migration, then restores instance content; `sc update` materializes source and reconciles migrations before the next boot. ## Author in the source repository Allocate migrations through the collision-safe source command: ```bash ./sc migration new <lowercase_snake_case_slug> ``` Pass = it reports the created next-numbered path and its source-removal allowlist entry. Keep historical migrations append-only and change `schema.sql` only when the current baseline itself must describe a new schema object. Never fold an already shipped delta into the baseline in a way that makes rebuild apply it twice. `0001_seed_skills.sql` is the generated exception: update authoritative global skill assets, run `./sc seed-skills`, and commit the regenerated 0001 body with the trailing reconciliation migration. Do not hand-edit 0001 or regenerate it for fork-local skills. For seeded system content, update the authoritative asset or generator and add a trailing reconciliation migration. Preserve per-instance rows carried by the snapshot. Pass = fresh build, in-place migration, and rebuild from an older snapshot converge to the same state. ## Protect the live instance The Admin boot names the private insta