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.