A free DataGrip alternative for PostgreSQL teams
DataGrip is a powerful IDE. pg-view gives your team browser access to PostgreSQL without JetBrains licenses or desktop installs.
Why teams switch from DataGrip
Not every team member needs a full IDE. pg-view covers daily PostgreSQL access in the browser.
MIT licensed — no per-developer subscription costs.
Browser access for analysts, support, and staging viewers without IDE setup.
Self-hosted: credentials never leave your infrastructure.
Read-only mode and SQL guardrails for safer production access.
pg-view vs DataGrip
DataGrip is a professional IDE. pg-view is a lightweight web client for shared team access.
| Feature | pg-view | DataGrip |
|---|---|---|
| Free and open source (MIT) | ||
| Native web — no desktop install | ||
| SQL editor with history and favorites | ||
| Global read-only mode | ||
| Self-hosted with Docker | ||
| No JetBrains license required |
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.
DataGrip alternative FAQ
Ready to explore your data?
Free, open source, and ready to deploy on your infrastructure. No licenses, no vendor lock-in.