pgweb

MIT
Platform
Web Docker Linux macOS Windows
Licence
MIT Open source
pgweb

pgweb is a lightweight, browser-based explorer for PostgreSQL. One Go binary starts a small web server on your own machine, and the database — tables, views, schema, SQL console — opens in a browser tab. There is no desktop client to install and no runtime to babysit.

What it does

  • Browse data — open any table or view in a paginated grid with column search and sorting, alongside Structure, Indexes and Constraints tabs for the same table.
  • SQL console — write queries, read the plan with Explain Query, and export result sets as JSON, CSV or XML.
  • Connections — connect with flags or a URL (pgweb --url postgres://user:pass@host:5432/db?sslmode=require), keep multiple database sessions open with --sessions, save server bookmarks, and reach hosts through native SSH tunnels.
  • History and activity — past queries are kept in a searchable history, and the Activity tab shows what the server is currently running.
  • Zero dependencies — a single static binary for macOS, Linux and Windows; the same app is also published as a Docker image.

Getting started

Download a prebuilt binary, or run the official image and point it at a database. The web interface listens on port 8081 and binds to localhost by default; --bind and --listen change that. pgweb speaks to PostgreSQL 9.6 and newer, and a --readonly mode exists for browsing production data without write access.

Things to know

pgweb is a data browser rather than a server administration console — it will not create roles, manage replication or run maintenance tasks, and there are no dashboards or alerting. Its web server has no login of its own, which is why it binds to localhost by default: exposing it on a network means putting an authenticating reverse proxy in front of it. The current release line is 0.17.

Alternatives

DBeaver and pgAdmin are the fuller-featured choices, at the cost of a desktop application. pgweb trades features for a tiny footprint and a browser tab, which suits a database you already reach over SSH.

Explore More Categories

Sign In

Register

Reset Password

Please enter your username or email address, you will receive a link to create a new password via email.