PGWeb: Browser-based PostgreSQL Client
PGWeb Client
PGWeb is a browser-based PostgreSQL client. Pigsty provides a small Docker Compose template under app/pgweb. By default, PGWEB_PORT=8886 in .env maps container port 8081 to host port 8886.
If the portal entry resolves to the Infra node, open http://cli.pigsty. Alternatively, open http://10.10.10.10:8886 directly. The public demo is http://cli.pigsty.io.
PGWeb asks for a PostgreSQL connection URL. For example:
These strings use public demo defaults and disable TLS. For real deployments, use a least-privilege account, a non-default secret, and an appropriate sslmode. Do not expose an unauthenticated PGWeb container or database credentials to untrusted networks.

Shortcuts
The bundled Makefile provides:
The template uses an unpinned sosedoff/pgweb image. For reproducible production deployments, pin a version or digest in app/pgweb/docker-compose.yml. make run is an alias for make up and follows the same .env and Compose configuration.
Was this page helpful?
Thanks—your feedback helps us improve this page.
What got in the way? (optional)