Stars
Forks
Watchers
Developer links
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.
Benefits
- No Desktop App, No Exposure
- Inspect databases from any browser without installing clients or opening Postgres to the internet.
- The Lightest Tool for the Job
- One static Go binary with zero dependencies - it runs on anything, including a Raspberry Pi.
- Reach Firewalled Databases
- Native SSH tunneling with passwords or keys connects to servers no client can reach directly.
- Triage Slow Queries Fast
- One-click EXPLAIN renders query plans with costs and row estimates.
Features
- Schema Browser
- Tables, views, sequences, and materialized views with structure, index, and constraint tabs.
- SQL Query Editor
- Execute arbitrary SQL with recorded query history.
- Query Plan Analysis
- Built-in EXPLAIN for cost, loops, and execution-time estimates.
- Three-Format Export
- Query results and full tables downloaded as CSV, JSON, or XML.
- SSH Tunnels and Bookmarks
- Key- or password-based tunneling plus saved server connections.
- Multi-Session Mode
- Optional concurrent connections to multiple databases in one instance.