Repository navigation
pg0 - Embedded PostgreSQL CLI
CLI Binaries
pg0-darwin-aarch64- macOS Apple Siliconpg0-darwin-x86_64- macOS Intelpg0-linux-x86_64-gnu- Linux x86_64 for Debian/Ubuntu (glibc)pg0-linux-x86_64-musl- Linux x86_64 for Alpine (musl, statically linked)pg0-linux-aarch64-gnu- Linux ARM64 for Debian/Ubuntu (glibc)pg0-linux-aarch64-musl- Linux ARM64 for Alpine (musl, statically linked)pg0-windows-x86_64.exe- Windows x64
Python Package
Install from PyPI:
pip install pg0-embeddedPre-built wheels available for:
- macOS Apple Silicon (
macosx_14_0_arm64) - macOS Intel (
macosx_15_0_x86_64) - Linux x86_64 glibc (
manylinux_2_35_x86_64) - Linux ARM64 glibc (
manylinux_2_35_aarch64) - Windows x64 (
win_amd64)
Bundled Components
Everything is bundled directly in the binary - no downloads required, works completely offline!
- PostgreSQL 18.1.0
- pgvector 0.8.5
Installation (macOS/Linux)
curl -fsSL https://raw.githubusercontent.com/vectorize-io/pg0/main/install.sh | bash[0.17.0] - 2026-11-17
Added
pg0 ui: a read-only web UI for all your pg0 instances, served by pg0 itself. Browse tables, run read-only SQL, and see a per-database overview (structure diagram, sizes, vacuum and index stats, live activity). It listens on0.0.0.0:5050by default (--host,--portto change) and is protected by a per-run token. All access goes through a temporary read-only role inside read-only transactions.