PG Compass is a fast, minimal database viewer for PostgreSQL. Connect, navigate schemas, inspect tables, and run queries without the overhead of a full IDE.
Most PostgreSQL tools are bloated IDEs or primitive CLI wrappers. PG Compass sits in the sweet spot: a focused, fast tool for the thing developers do most — inspecting data.
Browse connections, expand schemas, and drill into tables from a clean tree. Schemas remain first-class instead of being buried behind database tooling.
Paste a PostgreSQL connection string and start exploring. Save, label, color-code, and favorite the connections you use every day.
Tables stuffed with JSONB? Flip to card view and read documents like a human, not a row.
Data, Structure, Indexes, Constraints, and Query keep everything you need to understand a table in one focused interface.
Right-click any result set or table. Export full or filtered rows, no row-count limit.
Run ad-hoc SQL and inspect the results with the same pagination and data views used while browsing tables.
Inspect pgvector embeddings and PostGIS geometry as meaningful values instead of unreadable blobs.
A quiet, data-first interface with light mode included and keyboard-friendly controls throughout.
One window. Tab anything you want to keep open. Switch between connections without losing your place.
Release metadata and platform assets are loaded directly from the public repository.
Choose the release asset for your platform, or inspect every file on GitHub.
Because the existing ones are either heavy IDEs full of features you'll never touch — or terminal wrappers with the ergonomics of a hand-cranked drill. We picked the middle.
PG Compass is MIT-licensed and developed in public. No paid tier, no “pro” features held hostage, no telemetry pinging home. Fork it, audit it, ship a patch, or just lurk in the issues — all of it is welcome.
The whole app — desktop shell, query engine, and every theme — lives at github.com/waterrmalann/pg-compass. It is the same code we ship and the same code you can read, extend, and rebuild.