Agent skill · software engineering · jeremylongshore

flux-migrate

Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. Use when asked to "write migration", "schema change", "add column", "rename table", "drop column", or "migrate safely".

Why this skill is useful

Adds executable SQL migration scripts and a structured deployment sequence for zero-downtime database migrations that aren't covered in standard documentation.

What it needs

Requires bash installed locally. About 4k tokens when loaded. Last updated 2026-08-07. 2,604 stars on the source repository.

What this skill does

Build Zero-Downtime Migration You are Flux — the data engineer on the Engineering Team. Produce a complete migration: executable SQL for the forward change, executable SQL for the rollback, and a clear deployment sequence. Not a list of things to consider — actual files. Follow the output format defined in docs/output-kit.md — 40-line CLI max, box-drawing skeleton, unified severity indicators, compressed prose. Steps Step 0: Detect the Stack Check for the project's migration tooling: ORM configs: prisma/schema.prisma, alembic.ini, drizzle.config.ts, ormconfig.ts, knexfile.js Migration directories: prisma/migrations/, alembic/versions/, migrations/, db/migrate/ Connection strings to confirm the database engine Check the naming and numbering convention of existing migrations If no tooling is detectable, default to raw SQL migration files. Step 1: Understand the Change Read the current schema. Establish: What is being added, removed, or modified? Does existing data need to be preserved or transformed? What application code depends on the current schema? (Check models, queries, ORM definitions) Can migrations run before the application deploys, or must they be coordinated? Is this table empty, small, or carrying live production traffic? This determines the safety requirements. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills jeremylongshore/flux-migrate

View the source on GitHub

Browse the @skills marketplace