Logo
Deploy Now

SaaS Alternative

DBeaver TablePlus DataGrip pgAdmin

Stars

9426

Forks

852

Watchers

135

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.

pgweb
pgweb

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.