// the find
sosedoff/pgweb
Cross-platform client for PostgreSQL databases
pgweb is a single-binary, web-based PostgreSQL explorer written in Go. Zero runtime dependencies — download one file, point it at a database, and you have a browser UI for browsing tables, running queries, and exporting data. Aimed at developers who want something lighter than DBeaver or TablePlus without installing Electron.
Single binary with no dependencies is genuinely useful — works on a remote server over SSH tunneling without installing anything else. Native SSH tunnel support is built in rather than bolted on, which means you can connect through a bastion host without a separate tunnel process. Multi-session mode lets you hold connections to several databases simultaneously. CockroachDB support (separate SQL statements for CockroachDB in pkg/statements) suggests the Postgres wire-compatibility story is thought through rather than accidental.
The frontend is Bootstrap 3 + jQuery + inline Ace editor — not been modernized in years, and the static assets (FontAwesome .otf, unminified jQuery) make this feel frozen in 2016. No support for pgvector, logical replication slots, or any of the Postgres-14+ features that have become table stakes; it's purely a data browser. Query history is in-memory only (pkg/history/history.go has no persistence), so it disappears when the server restarts. The connect-backend model (pkg/connect/backend.go) lets you plug in an external auth service, but the docs for this are a Go example and a Ruby example in a config folder — not enough to trust it in a shared/team deployment without reading source.