/usr/local/bin/dbmate

NAME:
   dbmate - A lightweight, framework-independent database migration tool.

USAGE:
   dbmate [global options] command [command options]

VERSION:
   2.38.1

COMMANDS:
   new, n          Generate a new migration file
   up              Create database (if necessary) and migrate to the latest version
   create          Create database
   drop            Drop database (if it exists)
   migrate         Migrate to the latest version
   rollback, down  Rollback the most recent migration
   status          List applied and pending migrations
   dump            Write the database schema to disk.
                   Supports passing extra arguments to the underlying dump tool for pg/mysql
                   example: dbmate dump -- --extra-flag
   load            Load schema file to the database
   wait            Wait for the database to become available
   help, h         Shows a list of commands or help for one command

GLOBAL OPTIONS:
   --url value, -u value                                                  specify the database URL
   --driver value                                                         specify the driver to use (instead of deriving from the database URL scheme) [$DBMATE_DRIVER]
   --env value, -e value                                                  specify an environment variable containing the database URL (default: "DATABASE_URL")
   --env-file value [ --env-file value ]                                  specify a file to load environment variables from (default: ".env")
   --migrations-dir value, -d value [ --migrations-dir value, -d value ]  specify the directory containing migration files (default: "./db/migrations") [$DBMATE_MIGRATIONS_DIR]
   --migrations-table value                                               specify the database table to record migrations in (default: "schema_migrations") [$DBMATE_MIGRATIONS_TABLE]
   --schema-file value, -s value                                          specify the schema file location (default: "./db/schema.sql") [$DBMATE_SCHEMA_FILE]
   --no-dump-schema                                                       don't update the schema file on migrate/rollback (default: false) [$DBMATE_NO_DUMP_SCHEMA]
   --wait                                                                 wait for the db to become available before executing the subsequent command (default: false) [$DBMATE_WAIT]
   --wait-timeout value                                                   timeout for --wait flag (default: 1m0s) [$DBMATE_WAIT_TIMEOUT]
   --wait-interval value                                                  time to wait between connection attempts for --wait flag (default: 1s) [$DBMATE_WAIT_INTERVAL]
   --migration-lock                                                       hold a database lock while migrating so that concurrent dbmate instances wait for each other (postgres only) (default: false) [$DBMATE_MIGRATION_LOCK]
   --migration-lock-timeout value                                         maximum time to wait for the migration lock, 0 to wait indefinitely (default: 5m0s) [$DBMATE_MIGRATION_LOCK_TIMEOUT]
   --migration-application-name                                           record migration version in application_name during execution (postgres only) (default: false) [$DBMATE_MIGRATION_APPLICATION_NAME]
   --help, -h                                                             show help
   --version, -v                                                          print the version