PostgreSQL GUI Tools

A list of PostgreSQL tools for database administration, management and migration. This list will include open-source, free and proprietary software. It's divided into three sections: desktop, web and CLI software.

PostgreSQL GUI Tools

• pgAdmin – Open source management and administration tool for the PostgreSQL database:
• The oldest tool in this list;
• Outdated and complex interface;
• Most features and compatibility with PostgreSQL;
• pgModeler – Database modeler for PostgreSQL:
• Multiplatform software;
• Generate models from existing databases;
• Export data;
• Datazenit – Cross-platform PostgreSQL GUI:
• Query builder;
• Database content and schema editor;
• Charts from query;
• SQL Tabs – Rich SQL console for PostgreSQL:
• Database explorer;
• Rich scripts output;
• Charts from query result;
• DbVisualizer –  Universal database tool for multiple databases:
• Table data viewer and editor;
• Data export/import;
• SQL editor with auto-complete;

Web-Based PostgreSQL Tools

• phpPgAdmin – Web-based admin tool for PostgreSQL, similar to phpMyAdmin:
• Supports the Slony master-slave replication engine;
• Translation available for multiple languages;
• Latest release: 2013.

Command-line PostgreSQL Tools

• pgcli – Postgres CLI with autocompletion and syntax highlighting.
• psql2csv – Run a query in psql and output the result as CSV.