Pgweb

Pgweb is a lightweight, cross-platform desktop PostgreSQL client that gives developers and administrators a local web interface for browsing schemas, running…

  • Databases
Pgweb is a lightweight, cross-platform desktop PostgreSQL client that gives developers and administrators a local web interface for browsing schemas, running queries, and inspecting data.

Platform availability

Available on 4 of 10 platforms

  • Unraid (not listed)
  • TrueNAS (not listed)
  • Umbrel (not listed)
  • ZimaOS (not listed)
  • Proxmox (not listed)
  • Helm (not listed)
  • Mac
  • Windows
  • Linux
  • Any server

Health score?A 0-100 score computed nightly from four factors: maintained (40%: recent commits and steady activity), popular (25%: GitHub stars, log scale), easy to install (20%: platforms, install notes, setup guides, Docker image) and light to run (15%: minimum RAM, ARM support). When the source code has been checked, a fifth factor, security check (20%: automated scan for committed secrets, unsafe desktop-app settings, known-vulnerable dependencies and project hygiene; any serious finding caps it at 20), is added. Factors without data are left out and the rest are rescaled.

59/100 Fair

Maintained
61last commit 141 days ago
Popular
809,560 GitHub stars
Easy to install
554 install platforms, install notes
Light to run
100256 MB minimum RAM
Security check
07 serious findings, 2 minor, CI, tests, OpenSSF Scorecard 2.9/10

Availability: platform listings confirmed today

GitHub stars
9,560
Open issues
63
Last commit
2026-07-03
Latest release
v0.17.0
License
MIT
Activity
stale

Checked today - source: GitHub (sosedoff/pgweb)

Resources & Compatibility

Minimum requirements: 256 MB RAM.

Checked today - source: Docker Hub image tags and published docs

First-install notes

  • Set up PostgreSQL on Red Hat Install postgresql-server with dnf, then run postgresql-setup --initdb and enable/start postgresql.service. This initializes the database area and makes it start automatically; without it, the server won’t be ready after reboot. source
  • Enable the PostgreSQL repo on Ubuntu Install postgresql-common, run the pgdg setup script, then install postgresql-18 or another version number. This adds the PostgreSQL Apt repository (a package list) so you can install newer database versions instead of only the older default. source
  • Install PostgreSQL on macOS Use Homebrew with brew install postgresql@15, or swap in @16 if you want that version. This installs the database server the app needs, so it has a place to store and read data. source
  • Install pgweb Download the single binary for macOS, Windows, or Linux, or install it with Homebrew on macOS, then start pgweb, open a browser, and connect it to a PostgreSQL server. source

Fetched today - each note links to its source

Alternatives (4)

  • Adminer - Adminer is a lightweight, full-featured database management tool written in PHP that runs as a single deployable file for homelab administr…
  • Postico
  • cloudbeaver - CloudBeaver is a self-hosted, web-based database manager that provides a rich browser interface for connecting to and managing PostgreSQL,…
  • pgAdmin - pgAdmin is a web-based administration tool for the PostgreSQL database.

Checked today - source: AlternativeTo

Common questions

How do I set the PostgreSQL connection when starting Pgweb?

Run pgweb with connection flags for the host, user, and database. You can also pass a Postgres connection string with the url option, including a Unix socket directory.

Can Pgweb connect to PostgreSQL when the database is remote or behind a firewall?

Yes. Pgweb supports native SSH tunnels and can work with local or remote PostgreSQL servers. You can use password or SSH key authentication for the tunnel and save server bookmarks for quick connection.

What formats can Pgweb use to export table rows or query results?

Table data and query results can be exported to CSV, JSON, or XML.

Can Pgweb be deployed with Docker for self-hosting?

Yes, Pgweb can be deployed on a server with Docker. A Docker guide also lets you choose the pgweb version interactively.

Answers sourced from github.com, senate.sh, sosedoff.github.io

Community

Collected today - public community threads