D B T

CLI tool to copy, run SQL,
and connect to PostgreSQL databases

Add repo root to PATH.
chmod +x dbt if UNIX.
Create conf.json before using.
Use conf.template.json as an example.
By default:

• host is localhost
• port is 5432
• user is postgres

How to use:

dbt copy --use-cache --from "dev" --to "local"
dbt run --on "local" --file "./migration.sql"
dbt connect --to "local"