pgweb
Inspect a PostgreSQL database right now, without installing pgAdmin or exposing Postgres to
the internet - pgweb answers that recurring need. It's a Go application from Dan Sosedoff, a
decade in development, shipped as a single statically-linked binary with zero dependencies -
the Docker image is essentially just the executable - that puts a clean browser UI in front of
any PostgreSQL 9.1+ server. Connect via URL string or host/port credentials, and browse
tables, views, and sequences from the sidebar; selecting a table shows its rows immediately
alongside tabs for structure, indexes, and constraints. The Query tab executes arbitrary SQL
with query history, and the Explain Query button renders the query plan - estimated cost, row
counts, execution strategy - which makes pgweb a quick performance-triage tool, not just a
browser. Results and entire tables export to CSV, JSON, or XML in a click. Connectivity is
more flexible than its size suggests: native SSH tunneling (password or key) reaches databases
behind firewalls, server bookmarks make switching instances instant, and an optional
multi-session mode handles several databases concurrently. For a RepoCloud stack full of
Postgres-backed apps, one pgweb instance is the universal inspection hatch. MIT-licensed,
actively maintained.
Deploy