PGView

A minimal and modern web-based PostgreSQL database viewer and editor.

⚠️ PGView is still in early development. Some features may be missing or incomplete.

Features

• 🌳 Tree view of databases and tables
• 📄 Paginated rows
• 🔍 Search rows
• ✏️ Edit rows with a built-in JSON editor
• 🗑️ Delete rows

Getting Started

npm

# Install globally
npm install -g @catwallon/pgview

# Run
pgview --url postgresql://user:password@localhost:5432/mydb

Docker

docker run -p 8080:8080 \
  -e PGVIEW_URL=postgresql://user:password@localhost:5432/mydb \
  catwallon/pgview

Configuration

PGView can be configured via environment variables or CLI arguments.

Environment variable	CLI argument	Default
PGVIEW_HOST	--host	localhost
PGVIEW_PORT	--port	5432
PGVIEW_DBNAME	--dbname	—
PGVIEW_USER	--user	—
PGVIEW_PASSWORD	--password	—
PGVIEW_URL	--url	—
PGVIEW_LISTEN_PORT	--listen-port	8080

• CLI arguments take precedence over their corresponding environment variables.
• PGVIEW_URL / --url accept a full PostgreSQL connection string and take precedence over all individual parameters.