PostgreSQL in the browser. Nothing to install.
pg-view is a lightweight, modern web interface to explore, query, and edit PostgreSQL databases. Deploy in seconds with Docker and access it from any device.
Lightweight. Self-hosted. PostgreSQL-native.
| id | plan | last_login | metadata | |
|---|---|---|---|---|
| 1 | [email protected] | enterprise | 2026-05-21 | {"role":"admin","seats":24} |
| 2 | [email protected] | pro | 2026-05-20 | {"role":"editor","seats":8} |
| 3 | [email protected] | starter | 2026-05-18 | {"role":"viewer","seats":3} |
| 4 | [email protected] | pro | 2026-05-17 | {"role":"billing","seats":12} |
Instant startup
One Docker command and your panel is ready. No Java, no heavy installers, no complex setup.
Focused on essentials
Browse schemas, query tables, edit rows, and run SQL. Everything you need, nothing to distract you.
Yours, under your control
Self-hosted, panel authentication, read-only mode, and confirmation for destructive operations.
Less friction for your team
pg-view removes the friction of accessing PostgreSQL day to day.
Before
- Install pgAdmin, DBeaver, or another client on every team machine.
- Share credentials insecurely so someone can "take a quick look".
- Heavy tools with hundreds of options nobody uses.
- Hard to give quick access in staging or production environments.
With pg-view
- One Docker container accessible via internal URL or VPN.
- Clean browser UI with controlled permissions.
- Deploy in minutes, update with a docker pull.
- Read-only mode for analysts; full editing for developers.
Everything essential for working with PostgreSQL
Exploration, editing, and SQL in one coherent interface. No features you'll never use.
Schema explorer
Navigable tree with search, row estimates, and restoration of the last visited table.
Data viewer and editor
Paginated table with filters, sorting, and a side panel to view, edit, and insert rows.
Table structure
Columns, types, primary keys, indexes, and constraints visible at a glance.
Built-in SQL editor
History, favorites, auto-save draft, and confirmation for destructive operations.
Connection management
Saved connections with environment labels, URL import, and volume persistence.
User experience
Light and dark theme, resizable sidebar, and responsive design with Nuxt UI.
Built-in security and control
Panel authentication, global read-only mode, SQL guardrails, and configurable row limits and timeouts.
Ready in three steps
From zero to exploring data in under a minute.
Deploy
Run the Docker container on your server or local environment.
Connect
Open the URL, sign in, and connect to your PostgreSQL.
Explore
Browse schemas, edit rows, or open the SQL editor from your browser.
Comparison with alternatives
pg-view wins on simplicity, deployment speed, and daily query and edit experience.
| Feature | pg-view | pgAdmin | DBeaver | Adminer |
|---|---|---|---|---|
| Native web interface | ||||
| Lightweight (< 200 MB image) | ||||
| SQL editor with history and favorites | ||||
| Visual row editing | ||||
| Environment labels (prod/staging) | ||||
| Global read-only mode | ||||
| Destructive SQL confirmation | ||||
| Self-hosted with Docker in 1 command | ||||
| No client installation | ||||
| Open source (MIT) |
⚠️ pg-view does not compete on advanced server administration. It is built for day-to-day data querying and editing.
Deploy in 30 seconds
Optimized multi-stage Docker image. Internal port 3000, expose whatever you need.
services:
pg-view:
image: lcurrol/pg-view
ports:
- '8080:3000'
# environment:
# PGVIEW_USERNAME: admin
# PGVIEW_PASSWORD: 123456
# PGVIEW_SESSION_SECRET: random-secret-key
# DB_URL: postgresql://user:pass@host:5432/db
volumes:
- ./pg-view:/app/.data
restart: unless-stoppedPersistence
Mount a volume at /app/.data to keep connections and SQL history.
Read-only mode
Set PGVIEW_READ_ONLY=true to block writes.
Frequently asked questions
Straight answers about compatibility, deployment, and security.
Support the project
pg-view is free. If you find it useful, you can buy me a coffee.
Ready to explore your data?
Free, open source, and ready to deploy on your infrastructure. No licenses, no vendor lock-in.