dpg

dpg

Declarative PG — schema compiler and migration tool

Synopsis

DPG is a declarative, state-based superset of PostgreSQL SQL that compiles to idiomatic PG DDL. Describe what your database should be; DPG figures out what needs to change.

Source: https://github.com/thec1oud/dpg

Options

  -C, --dir string   project root directory (default: current working directory)
      --env string   path to .env file (default: .env in project root, if present)
  -h, --help         help for dpg

SEE ALSO

  • dpg apply - Execute the planned migration and update the snapshot
  • dpg completion - Generate the autocompletion script for the specified shell
  • dpg diff - Diff two DPG source directories and print the SQL migration
  • dpg docs - Serve the DPG documentation locally
  • dpg dump - Introspect a live database and produce initial .dpg source files
  • dpg fmt - Format .dpg source files in place
  • dpg init - Scaffold a new DPG project
  • dpg plan - Diff desired state vs snapshot and print the SQL migration
  • dpg portability - Report PostgreSQL-specific constructs in use
  • dpg validate - Validate .dpg source files offline without diffing
  • dpg verify - Check the live database for drift against the snapshot
Auto generated by spf13/cobra on 26-Aug-2026