Quickstart

Install DBLift, write one SQL file, preview the statements, then apply them. OSS commands only. About five minutes if a database is already running.

Need Postgres? docker run --name dblift-pg -e POSTGRES_USER=user -e POSTGRES_PASSWORD=password -e POSTGRES_DB=mydb -p 5432:5432 -d postgres:16

Replace user, password, and mydb — or create that role and database first.

Run every dblift command from the directory that contains migrations/.

  1. pip install "dblift[postgresql]"
  2. export DBLIFT_DB_URL="postgresql+psycopg://user:password@localhost:5432/mydb"
  3. mkdir -p my-database-project/migrations && cd my-database-project
  4. dblift validate
  5. dblift migrate --dry-run --show-sql
  6. dblift migrate
  7. dblift info

DBLift is information technology / developer tools software. Contact: contact@dblift.com.