Schema Migration Tool
ELI5 — The Vibe Check
A schema migration tool is version control for your database. Each migration is a numbered script that changes the schema: add a column, create a table, drop an index. It tracks what's been applied so you never run the same change twice. No more 'hey can you run this SQL on production?'
Real Talk
Schema migration tools manage versioned, incremental changes to database schemas across environments. They maintain a metadata table tracking applied migrations, support reversible up/down operations, and ensure schema consistency across development, staging, and production. Examples include Prisma Migrate, Alembic, Flyway, Knex migrations, and Django migrations.
When You'll Hear This
"Always use a migration tool — never modify production schemas by hand." / "The migration tool tracks which changes have been applied to each environment."
Related Terms
Database
A database is like a super-organized filing cabinet for your app's data.
Flyway
Flyway is a migration tool that keeps track of every change you've ever made to your database schema, in order, like a meticulous diary.
Liquibase
Liquibase is like Flyway's more enterprise cousin who wears a suit. It tracks database changes but uses XML, YAML, or JSON changelogs instead of raw SQL.
Migration
A migration is a versioned script that modifies your database schema — adding a column, creating a table, changing a type.