pgAdmin is unclaimed —
P
pgAdmin
The Most Popular PostgreSQL Admin Tool·pgadmin.org
pgAdmin is a feature-rich, open-source administration and development platform for PostgreSQL and EDB Postgres Advanced Server. It provides tools for creating, managing, and querying database objects through a graphical interface, including a query tool with syntax highlighting, graphical EXPLAIN plans, a schema diff tool, an ERD design tool, and a procedural language debugger. It also offers routine maintenance features such as backup/restore, auto-vacuum management, a monitoring dashboard, and SQL/shell/batch job scheduling via pgAgent. It can run in desktop mode using a dedicated runtime or in server mode as a multi-user web application.
What it's for
Creating, managing, and querying PostgreSQL database objectsRunning and optimizing SQL queries with graphical EXPLAIN plansBacking up, restoring, vacuuming, and analyzing databasesDebugging procedural language code (pl/pgsql and edb-spl)Comparing and managing schema differences with the Schema Diff toolDesigning and documenting database schemas with the ERD ToolScheduling SQL/shell/batch jobs with pgAgentMonitoring database activity via a monitoring dashboard
Features 15
- Auto-vacuum management
- Backup, restore, vacuum and analyze on demand
- Create, view and edit all common PostgreSQL objects
- ERD Tool for designing and documenting schemas
- Fast datagrid for display/entry of data
- Grant Wizard for rapid updates to ACLs
- Graphical query plan display
- Monitoring dashboard
- Multibyte server-side encoding support
- Multiple deployment models: desktop mode and server (web) mode
- Powerful query tool with colour syntax highlighting
- Procedural language debugger (pl/pgsql and edb-spl)
- Schema diff tool for managing differences between schemas
- SQL/shell/batch job scheduling agent (pgAgent)
- Support for multiple PostgreSQL versions and EDB Postgres Advanced Server