Alternatives to pgAdmin
The standard open-source administration tool for PostgreSQL. The listings below can replace it for an important use case. Each note says what changes if you switch.
The original
pgAdmin
The standard open-source administration tool for PostgreSQL.
Replacements
Listings that take over the same core job as pgAdmin.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
DBeaver Community is a desktop client for more than a hundred databases with ER diagrams, but it is Eclipse-based, slow to start, and has no shared web mode.
DataGrip
Multi-database IDE with an intelligent SQL console and schema navigation.
DataGrip adds schema-aware SQL completion and schema comparison across many engines, but it is a paid, closed-source subscription with no free tier and no web version.
DbGate
One database client for MySQL, PostgreSQL, SQL Server, MongoDB, SQLite, Redis and a dozen more, on desktop or as a web app.
DbGate covers PostgreSQL alongside many SQL and NoSQL engines and can run as a desktop or self-hosted web app, though it offers less PostgreSQL depth than a specialist tool.
Beekeeper Studio
A SQL client that is pleasant to look at and works the same on Windows, macOS and Linux.
Beekeeper Studio offers a cleaner interface for day-to-day querying across many databases, but it has fewer administration tools and some features are paid.
TablePlus
Native database client for many engines with a clean interface.
TablePlus is a closed-source native client for many engines with a safe mode for commits, while its free tier limits open tabs and connections.
Adminer
Database management in a single PHP file.
Adminer is a single PHP file for web-based management of many engines, with fewer conveniences and a need to protect it on public servers.
Similar software
Related functionality, not a direct replacement.
PostgreSQL
The open-source relational database with 35 years behind it, known for correctness, extensibility and a long feature list.
pgBackRest
Parallel backup and restore for PostgreSQL with delta restore.
Barman
Backup and recovery manager for PostgreSQL disaster recovery.
TimescaleDB
PostgreSQL extension that turns Postgres into a scalable time-series database.
usql
Use one command-line interface for many database systems.
phpMyAdmin
Web-based administration for MySQL and MariaDB.
