pgAdmin is unclaimed —
pgAdmin
The Most Popular PostgreSQL Admin Tool·pgadmin.org
Free plan · Open source
pgAdmin is a feature-rich, open-source administration and development platform for PostgreSQL and EDB Postgres Advanced Server. It provides a graphical interface for creating, managing, and querying database objects, along with tools such as a query editor, schema diff, ERD designer, backup/restore, monitoring dashboard, and job scheduling. It can run as a desktop application or be deployed in server mode for multi-user access over the web.
What it's for
Creating, managing, and querying PostgreSQL database objectsWriting and optimizing SQL queries with graphical EXPLAIN plansManaging schema differences between databases with the Schema Diff toolDesigning and documenting database schemas with the ERD ToolPerforming backup, restore, vacuum, and analyze operationsScheduling SQL/shell/batch jobs via pgAgentMonitoring database activity via a dashboardDebugging procedural language code (pl/pgsql, edb-spl)Managing user roles and access control lists via the Grant Wizard
Features 18
- AI-powered configuration, chat agent, and EXPLAIN plan insights
- Auto-vacuum management
- Backup, restore, vacuum, and analyze on demand
- Cloud deployment support
- Create, view, and edit all common PostgreSQL objects
- Desktop mode and multi-user server/web mode
- ERD Tool for designing and documenting schemas
- Fast datagrid for data display and entry
- Grant Wizard for rapid ACL updates
- Graphical EXPLAIN for query plan visualization
- Monitoring dashboard
- Multibyte server-side encoding support
- OAuth2, LDAP, Kerberos, and webserver authentication support
- Powerful query tool with color syntax highlighting and auto-complete
- Procedural language debugger (pl/pgsql and edb-spl)
- Schema Diff tool for comparing and managing schema differences
- SQL/shell/batch job scheduling agent (pgAgent)
- Support for multiple PostgreSQL and EDB Postgres Advanced Server versions
Similar apps
AdminerOpen sourceDatabase management in a single PHP filePriceFreeTry freeFree planRuns onWebFeatures20
MathesarOpen sourceSecure, spreadsheet-like tool for Postgres dataPriceNot statedTry freeFree planRuns onWebFeatures10
DbGateOpen sourceSQL & noSQL database managerPrice$3.9–$15/moTry freeFree planRuns onWeb · Windows +2Features18
phpMyAdminOpen sourceBringing MySQL administration to the webPriceFreeTry freeFree planRuns onWebFeatures15
CloudBeaverSelf-hostableSecure browser-based data managementPriceNot statedTry free14-day trialRuns onWebFeatures20
DoltOpen sourceDolt is the Database for AgentsPrice$50–$5000/moTry freeFree planRuns onWebFeatures14