Lightweight web interface for exploring and querying PostgreSQL databases. Browse schemas and tables, edit rows, run SQL, and save favorite connections.
docker run -d \
--name pg-view \
-p 8080:3000 \
-v pg-view-data:/app/.data \
lcurrol/pg-view:latest
Open http://localhost:8080.
| Variable | Required | Description |
|---|---|---|
PGVIEW_USERNAME | Yes* | Username for accessing the panel |
PGVIEW_PASSWORD | Yes* | Panel password |
PGVIEW_SESSION_SECRET | Recommended | Secret used to sign sessions. If not set, it is derived from the username and password |
* If neither PGVIEW_USERNAME nor PGVIEW_PASSWORD is set, the panel remains open without authentication. Not recommended for environments exposed to the internet.
If you configure these variables, the app connects automatically on startup and goes straight to the dashboard:
| Variable | Default | Description |
|---|---|---|
DB_URL | — | Connection URL (postgres://user:pass@host:5432/db). If present, it overrides the individual variables |
DB_HOST | — | PostgreSQL host |
DB_PORT | 5432 | Port |
DB_NAME | — | Database |
DB_USER | — | User |
DB_PASSWORD | — | Password |
| Variable | Default | Description |
|---|---|---|
PGVIEW_READ_ONLY | false | Read-only mode (true / false) |
PGVIEW_MAX_ROWS | 200 | Maximum number of rows returned per query |
PGVIEW_QUERY_TIMEOUT_MS | 30000 | Query timeout in milliseconds |
PORT | 3000 | Internal container port |
Mount a volume at /app/.data to keep saved connections and history across restarts:
-v pg-view-data:/app/.data
Content type
Image
Digest
sha256:55f9f0bcd…
Size
59.4 MB
Last updated
25 days ago
docker pull lcurrol/pg-view