Pgweb

What Pgweb is

Pgweb is a free, web-based explorer for PostgreSQL databases, written in Go and available on Linux, macOS, Windows, and self-hosted deployments. It connects to local or remote PostgreSQL servers, including Heroku Postgres, and can use SSH tunnels through firewalls. Users can run and analyze custom SQL, then export query results or table data as CSV, JSON, or XML. Multiple database sessions, query history, and server bookmarks support recurring work. Pgweb is distributed as a single binary and can also be installed with Docker or Homebrew. Command-line options include HTTP basic authentication, read-only database mode, SSL certificate settings, and disabling SSH connections. The README lists PostgreSQL 9.6+ support, while the product site says official support starts at 9.1 and older versions are not guaranteed. It is MIT licensed and free.

Who it suits

Pgweb suits people managing PostgreSQL databases who want a browser-based interface across Linux, macOS, Windows, or self-hosted setups. It also fits users needing SSH tunneling, query history, and exports in common data formats.

Limits

Pgweb is focused on PostgreSQL. The product site says official support starts at PostgreSQL 9.1 and older versions are not guaranteed; the README lists PostgreSQL 9.6 and later as supported.

Getting started

1. Visit the Pgweb GitHub repository for the project and documentation links.
2. Choose a single-binary, Docker, or Homebrew installation route.
3. Run Pgweb and connect to a local or remote PostgreSQL server.
4. Configure options such as HTTP basic authentication, read-only mode, SSL certificates, or SSH access as needed.

Verdict

Pgweb combines SQL work, session management, exports, and connection controls in a free PostgreSQL-focused interface. Its platform coverage and SSH support suit varied deployment needs, while database compatibility should be checked against the stated version notes.