PgDesigner

Download PgDesigner — PostgreSQL Schema Designer

Homebrew (macOS / Linux)

The fastest way to install and keep PgDesigner up to date:

brew tap vmkteam/tap
brew install pgdesigner

Update to the latest version:

brew upgrade pgdesigner

GitHub Releases

Download the binary for your platform from GitHub Releases:

PlatformArchitectureFile
macOSApple Silicon (arm64)pgdesigner-darwin-arm64.tar.gz
macOSIntel (amd64)pgdesigner-darwin-amd64.tar.gz
Linuxamd64pgdesigner-linux-amd64.tar.gz
Linuxarm64pgdesigner-linux-arm64.tar.gz
Windowsamd64pgdesigner-windows-amd64.zip
Windowsarm64pgdesigner-windows-arm64.zip

Install from tarball

# Linux / macOS
curl -L https://github.com/vmkteam/pgdesigner/releases/latest/download/pgdesigner-linux-amd64.tar.gz | tar xz
sudo mv pgdesigner /usr/local/bin/

# Verify
pgdesigner --version

Docker

The image runs the CLI — useful for CI/CD pipelines. Mount your project to /work, the working directory:

# Lint (exit code 1 on errors)
docker run --rm -v "$(pwd)":/work ghcr.io/vmkteam/pgdesigner:latest lint -s error schema.pgd

# Migration between two versions of the model
docker run --rm -v "$(pwd)":/work ghcr.io/vmkteam/pgdesigner:latest diff old.pgd schema.pgd

# DDL
docker run --rm -v "$(pwd)":/work ghcr.io/vmkteam/pgdesigner:latest generate -o schema.sql schema.pgd

The visual editor binds to 127.0.0.1 and opens your browser, so run it from a native install rather than the container.

Available tags: latest, vX.Y.Z (specific version). Images are published for linux/amd64 and linux/arm64.

Build from source

Requires Go 1.25+, Node.js and pnpm. The frontend is embedded into the binary, so build it first:

git clone https://github.com/vmkteam/pgdesigner.git
cd pgdesigner
(cd frontend && pnpm install)
make build-full

The binary is at ./pgdesigner. PgDesigner is open source under the Apache License 2.0 — free for any use, including commercial.

System requirements

  • OS: macOS 12+, Linux (any — static binary, no glibc dependency), Windows 10+
  • Disk: ~25 MB for the binary
  • Browser: Chrome, Firefox, Safari, Edge (for the UI)
  • Dependencies: None — single statically-linked binary

macOS Gatekeeper

Release binaries (Homebrew and GitHub Releases) are signed and notarized by Apple — they open without warnings. If you build from source, macOS may show "unidentified developer". To allow:

xattr -d com.apple.quarantine pgdesigner

Or: System Settings → Privacy & Security → Allow.