Pgweb
Pgweb is a free, web-based explorer for PostgreSQL databases, written in Go.
What Pgweb is
Pgweb is a free, web-based explorer for PostgreSQL databases, written in Go. It connects to local or remote servers, including Heroku Postgres, and supports SSH tunnels through firewalls. Users can run and analyze custom SQL, work across multiple database sessions, and export query results or table data as CSV, JSON, or XML. Pgweb also keeps query history and lets users save server bookmarks for quicker connections. It is available on Linux, macOS, and Windows, and can be deployed as a single binary or installed with Docker or Homebrew. Command-line controls include HTTP basic authentication, read-only database mode, SSL certificate settings, and an option to disable SSH connections. PostgreSQL compatibility is described differently across its materials: the README lists version 9.6 and later, while the product site says official support starts at 9.1 and older releases are not guaranteed. Pgweb is MIT licensed and free. Questions and documentation are directed to GitHub Issues and the project wiki.
Good
- Free and MIT licensed.
- Connects to local and remote PostgreSQL servers.
- Supports SSH tunnels through firewalls.
- Exports results as CSV, JSON, or XML.
- Offers query history and server bookmarks.
Watch out
- PostgreSQL version guidance differs between project materials.
- Older PostgreSQL versions are not guaranteed.
- Supports PostgreSQL databases only.
Who it suits
Pgweb suits people who need to connect to PostgreSQL databases from a web interface or across desktop platforms. It may also fit users who need SQL history, export formats, or SSH tunneling.
Verdict
Pgweb brings PostgreSQL access, custom queries, session management, and data exports together in a free tool. Check the stated version guidance against the database you plan to use.
Plans and prices
From Pgweb's own pricing page, checked 9 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Pgweb | Free | MIT licensed · PostgreSQL 9.6+ · Mac, Linux, Windows |
The facts
Each one read from Pgweb's own pages, with the date it was checked.
What it does
- Connections
- Pgweb connects to local or remote PostgreSQL servers, including Heroku Postgres, and supports SSH tunnels through firewalls.checked 9 Oct 2026
- Convenience
- It records query history and supports server bookmarks for quick connections.checked 9 Oct 2026
- Deployment
- Pgweb is distributed as a single binary and can also be installed with Docker or Homebrew.checked 9 Oct 2026
- Exports
- Query results and table data can be exported to CSV, JSON, or XML.checked 9 Oct 2026
- License
- The repository identifies Pgweb as MIT licensed.checked 9 Oct 2026
- PostgreSQL compatibility
- The README lists PostgreSQL 9.6+ support; the product site says official support starts at 9.1 and older versions are not guaranteed.checked 9 Oct 2026
- Purpose
- Pgweb is a web-based, cross-platform explorer for PostgreSQL databases, written in Go.checked 9 Oct 2026
- Queries
- Users can execute and analyze custom SQL queries.checked 9 Oct 2026
- Security controls
- CLI options include HTTP basic authentication, read-only database mode, SSL certificate settings, and an option to disable SSH connections.checked 9 Oct 2026
- Sessions
- The application supports multiple database sessions.checked 9 Oct 2026
- Support and community
- The README directs users to GitHub Issues for questions and the project wiki for documentation.checked 9 Oct 2026
Where it runs
- Platforms
- The installation page lists macOS, Linux, Windows, and 64-bit ARM as supported platforms.checked 9 Oct 2026
Alternatives to Pgweb
- 1
Outerbase Studio
Free planOpen sourceAndroidiOSWebAPI8.5From $9 a month - 2
DBeaver
Free planOpen sourceWebAPIExtensionLinux8.2From $113 a year - 3
Beekeeper Studio
Free planOpen sourceAPIExtensionLinuxmacOS8.0From $18 a month - 4
MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 5
Database Workbench
Free planLinuxmacOSWindows7.5€199 one-time - 6
dbForge Studio for PostgreSQL
Free planLinuxmacOSWindows7.5From $89.95 a year