// the find
pgadmin-org/pgadmin4
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
pgAdmin 4 is the reference GUI for PostgreSQL — a Flask + ReactJS web app that doubles as an Electron desktop tool. It covers virtually every PostgreSQL object type, has a query editor with explain visualizer, a stored procedure debugger, ERD tooling, and built-in backup/restore. If you manage PostgreSQL databases and don't want to live in psql, this is the default answer.
The feature surface is genuinely complete: you can manage roles, RLS policies, FTS configurations, foreign data wrappers, and partition tables all through the UI, which saves a lot of DDL lookup time. The dual-mode deployment (desktop via Electron, server mode for teams) is well thought out — same codebase, different config, and the Docker image makes server mode trivial to stand up. The ERD tool for generating and visualizing schema diagrams is useful and rarely available for free in Postgres tooling. CI workflow is thorough — separate pipelines for Python tests, JS tests, style checks, and feature tests against both PostgreSQL and EPAS.
The dev setup is heavy: you need Node 20, yarn, Python 3.9+, a running PostgreSQL instance, and a build step to bundle JS assets before you can even launch it — not a quick spin-up. Performance degrades noticeably on large schemas; the object tree can feel sluggish when a database has hundreds of tables and schemas because it loads metadata eagerly. The Electron wrapper for desktop mode is an afterthought in practice — it's a browser window around a localhost Flask server, so it carries all of Python's startup time and none of a native app's feel. Server mode security defaults require careful reading: the master password and OAuth2 setup docs are dense, and a misconfigured multi-user deployment is a real risk if you're not paying attention.