ogulcanaydogan/db-migrate repository overview

docker run \
  -e DB_TYPE=postgresql \
  -e DB_HOST=localhost \
  -e DB_NAME=myapp \
  -e DB_USER=postgres \
  -e DB_PASSWORD=secret \
  -v $(pwd)/migrations:/migrations \
  ogulcanaydogan/db-migrate up

migrations/
├── 001_create_users.up.sql
├── 001_create_users.down.sql
├── 002_add_email_index.up.sql
└── 002_add_email_index.down.sql

services:
  db:
    image: postgres:16-alpine
    environment:
      POSTGRES_DB: myapp
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: secret

  migrate:
    image: ogulcanaydogan/db-migrate
    command: ["up"]
    depends_on:
      db:
        condition: service_healthy
    environment:
      - DB_HOST=db
      - DB_NAME=myapp
      - DB_USER=postgres
      - DB_PASSWORD=secret
    volumes:
      - ./migrations:/migrations