![Wizard [Immich]](https://store.elfhosted.com/wp-content/uploads/2025/09/wizard-immich-150x150.avif)
![YouTarr [Standalone]](https://store.elfhosted.com/wp-content/uploads/2025/09/youtarr-150x150.avif)
pgAdmin
$9.00 / month with 1 day free trial and a $7.00 sign-up fee
The official PostgreSQL admin UI on your subdomain — connect to any Postgres database (Supabase, RDS, on-prem, home-lab) without exposing each instance to the public internet.
A managed instance of pgAdmin on ElfHosted — the official, full-featured PostgreSQL administration tool. Browser-based query editor, schema explorer, backup/restore wizard, server health dashboard. Add server connections from any reachable Postgres instance: managed databases (RDS, Supabase, Neon, Crunchy Bridge), on-prem clusters, home-lab containers. PostgreSQL Licence (BSD-style).
Out of stock
This product is currently sold out.
No worries! Enter your email, and we'll let you know as soon as it's back in stock.
Postgres ships with psql; pgAdmin is what you reach for when "psql" stops being enough — schema visualisation, query plans, backup wizards, role management.
What is pgAdmin?
pgAdmin is the official PostgreSQL administration and development platform — a full-featured web app for managing Postgres databases. It's been the canonical Postgres GUI since the project began in 1998 and ships in step with every Postgres release. Originally a desktop app; pgAdmin 4 (the current major version) is web-based, which is what makes hosting it on a subdomain useful.
Common workflows it covers: connect to multiple Postgres servers, browse schemas and tables, run ad-hoc queries with EXPLAIN/ANALYZE plans, edit data inline, manage roles and grants, run backups and restores, monitor connection counts and slow queries. The browser-based UI means you don't need a desktop install on every machine you connect from.
Features
- 📋 Multi-server management — connect to any number of Postgres servers; switch between them in the same session; group by environment (prod / staging / dev) for safety.
- 📝 Query tool — full-featured SQL editor with syntax highlighting, autocomplete, query history, query plans (EXPLAIN ANALYZE rendered visually).
- 🗂️ Schema browser — tables, views, materialised views, functions, triggers, indexes — all clickable; right-click for "Edit", "Properties", "Drop".
- 📊 Data editor — view and edit table data in a spreadsheet-like grid; updates wrapped in transactions you can roll back.
- 🔐 Role & privilege management — visual UI for `CREATE ROLE` / `GRANT` / `REVOKE`; the syntax is annoying enough that the GUI saves real time.
- 💾 Backup & restore — guided pg_dump / pg_restore wizards; format selection, table filtering, compression options.
- 📈 Server dashboard — connection counts, slow query log, lock monitoring, transactional activity.
- 🔧 Procedural language editing — pl/pgSQL functions with debugger support; useful when stored procedures get complex.
- 🔓 FOSS & PostgreSQL Licence — official PostgreSQL Global Development Group project, no vendor variant.
pgAdmin vs Other Postgres GUI Options
- vs. DBeaver — DBeaver is multi-database (Postgres, MySQL, Oracle, etc.) and desktop-app. If you're managing only Postgres, pgAdmin's depth on Postgres-specific features (procedural language debugger, vacuum/analyze visualisations, pgAgent) goes further. If you need multi-DB, DBeaver wins.
- vs. TablePlus / Postico — commercial polished desktop apps with cleaner UI. Pick those if you live on a single Mac and want polish; pick pgAdmin if you need browser access (any device, including iPads and locked-down laptops).
- vs. psql — psql is unbeatable for one-off queries and CI scripts. pgAdmin is for the visual / exploratory / backup-wizard workflows where the GUI is faster than the CLI.
- vs. pgcli — pgcli is psql with autocomplete and syntax highlighting. Same CLI/GUI trade-off; not really a competitor — many users run both.
- vs. exposing your DB's web admin to the public internet directly — running pgAdmin once on a managed subdomain is structurally safer than exposing each Postgres instance's admin port. The Postgres servers themselves stay on private networks.
Why Run pgAdmin on ElfHosted?
pgAdmin self-hosts cleanly (Python web app + SQLite for its own metadata), but the operational details around an admin-grade UI matter:
- HTTPS with auto-renewing TLS — required for the auth flow and for not leaking server-connection passwords in transit.
- Single instance for multiple Postgres servers — bring N connection strings; pgAdmin keeps them organised.
- Your databases stay on private networks (or behind tunnels); only this pgAdmin instance is publicly reachable.
- SSO via your ElfHosted account adds an auth layer in front of pgAdmin's own login.
- Updates handled — pgAdmin tracks Postgres releases regularly, and major-version compatibility matters.
- Persistent storage for connection profiles and saved queries.
Technical Specifications
- 🛠️ Software: pgAdmin 4 (FOSS, PostgreSQL Licence)
- 🐘 Postgres versions supported: tracks upstream pgAdmin compatibility — typically Postgres 12+
- 🌐 Connections supported: standard libpq connections; TCP/IP, Unix socket; SSL/TLS modes; SSH tunnel for hop-host scenarios
- 📋 Connection types: direct, SSH-tunneled, socket-relayed
- 🔐 Auth: ElfHosted SSO; pgAdmin's own user database; password-saving with master-password protection
- 📊 Backup tools: pg_dump / pg_restore wizards built in
- 🌐 Access: HTTPS on your own ElfHosted subdomain
- 🔄 Updates: handled by ElfHosted, tracking upstream pgAdmin releases
Frequently Asked Questions
What Postgres providers can pgAdmin connect to?
Anything that speaks the PostgreSQL protocol — managed services (RDS, Supabase, Neon, Crunchy Bridge, DigitalOcean, ElephantSQL), on-prem clusters, home-lab Postgres in Docker, k3s-deployed Postgres, etc. The connection is just a libpq client; pgAdmin doesn't care where the server is hosted.
Can pgAdmin connect to a database behind a private network?
Yes — pgAdmin supports SSH tunnel connections, so you can hop through a bastion host to reach Postgres instances that aren't publicly reachable.
How is this different from DBeaver?
DBeaver is multi-database and desktop. pgAdmin is Postgres-only and browser-based. If you only manage Postgres and want browser access from any device, pgAdmin. If you also touch MySQL/Oracle/etc., DBeaver.
Why does the WC product page say sold-out?
This product is currently provisioned by direct arrangement only (it's deployed for specific use cases rather than self-service). The page exists for reference and search-engine visibility; if you'd like a managed pgAdmin instance, get in touch via the ElfHosted Discord.
Is the connection metadata stored encrypted?
pgAdmin can encrypt saved connection passwords with a master password (which you set on first login). The metadata storage is on ElfHosted's encrypted storage backend; the master password adds a defence-in-depth layer.
pgAdmin is the official PostgreSQL admin UI — schema browser, query tool with execution plans, backup wizards, role management. Browser-based, multi-server, runs on any Postgres-compatible database. Hosted on ElfHosted on your subdomain so the databases themselves stay on private networks; currently provisioned by direct arrangement.
Only logged in customers who have purchased this product may leave a review.
Related products
code-server
Run VS Code in a browser tab — full extension support, integrated terminal, persistent dotfiles, accessible from any device including iPads and Chromebooks.
A managed instance of code-server on ElfHosted — full Visual Studio Code running on your subdomain, accessible from any browser. Same UI, same keybindings, same extension marketplace, same integrated terminal. The dev environment lives on the server, so an iPad / Chromebook / borrowed laptop becomes a full development environment in one URL. MIT-licensed; built by Coder.
Reviews
Clear filtersThere are no reviews yet.