A modern Adminer alternative built for PostgreSQL
Adminer is minimal and multi-database. pg-view offers a polished PostgreSQL experience with saved connections, SQL history, and safer defaults.
Why teams switch from Adminer
Adminer is lightweight but basic. pg-view adds the features teams need daily.
Modern UI with dark mode, resizable sidebar, and responsive layout.
SQL history, favorites, and auto-save drafts — not just a single query box.
Connection labels for prod/staging and persistent saved connections.
Destructive SQL guardrails and configurable read-only mode.
pg-view vs Adminer
Both are web-based and self-hosted. pg-view adds PostgreSQL-focused polish and team features.
| Feature | pg-view | Adminer |
|---|---|---|
| Native web interface | ||
| SQL editor with history and favorites | ||
| Environment labels (prod/staging) | ||
| Global read-only mode | ||
| Destructive SQL confirmation | ||
| Visual row editing with JSON support |
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.
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.
Adminer alternative FAQ
Ready to explore your data?
Free, open source, and ready to deploy on your infrastructure. No licenses, no vendor lock-in.