This is share svg Share this item

PGweb

Web-based PostgreSQL database browser

Most versions of PostgreSQL are supported, starting with official support for 9.1. Older versions could also be compatible but not guaranteed.

Pgweb can work with any local or remote PostgreSQL server (Heroku supported) as well as any server behind a firewall by using native SSH tunnelling with passwords or ssh keys. Quickconnect with server bookmarks.

Pgweb was designed to be very simple and clean UI to browse database tables or run and analyze SQL queries. Export query results or table rows to CSV/JSON/XML. Multiple schemas are supported. Records query history.

start automaically web UI (if admin role exists)
pgweb added to NAS $PATH

Usage:
pgweb [OPTIONS]

Application Options:
-v, --version Print version
-d, --debug Enable debugging mode
--url= Database connection string
--host= Server hostname or IP (default: localhost)
--port= Server port (default: 5432)
--user= Database user
--pass= Password for user
--db= Database name
--ssl= SSL option
--bind= HTTP server host (default: localhost)
--listen= HTTP server listen port (default: 8081)
--auth-user= HTTP basic auth user
--auth-pass= HTTP basic auth password
-s, --skip-open Skip browser open on start
--sessions Enable multiple database sessions
--prefix= Add a url prefix
--readonly Run database connection in readonly mode
--lock-session Lock session to a single database connection
-b, --bookmark= Bookmark to use for connection. Bookmark files are stored under $HOME/.pgweb/bookmarks/*.toml
--bookmarks-dir= Overrides default directory for bookmark files to search
--no-pretty-json Disable JSON formatting feature for result export
--no-ssh Disable database connections via SSH
--connect-backend= Enable database authentication through a third party backend
--connect-token= Authentication token for the third-party connect backend
--connect-headers= List of headers to pass to the connect backend
--no-idle-timeout Disable connection idle timeout
--idle-timeout= Set connection idle timeout in minutes (default: 180)
--cors Enable Cross-Origin Resource Sharing (CORS)
--cors-origin= Allowed CORS origins (default: *)

Help Options:
-h, --help Show this help message



Contact the Author