Database Migration

A database migration is a versioned, repeatable change to a database schema (such as adding a table or column) that lets teams evolve the schema safely over time.

Migrations capture schema changes as ordered scripts checked into version control, so every environment — local, staging, production — can be brought to the same state reproducibly.

Good migration practice includes making changes backward-compatible where possible, testing rollbacks, and running migrations as part of deployment.

Because migrations are SQL against standard PostgreSQL, they remain portable and transparent rather than hidden behind a proprietary abstraction.

Related terms

See it in practice

Kolaybase gives you PostgreSQL, auth, storage, and a REST API in minutes.

Get started