Community Guide to PostgreSQL GUI Tools

From PostgreSQL wiki

Jump to: navigation, search


Open Source / Free Software

This is the list of "open source and free" software:


browser-based, requires webserver

Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL and Oracle.


Eclipse/Java (multi-platform)

Eclipse-based environment, supporting many SQL databases from different vendors, as well as few NoSQL ones (Cassandra, etc). Good query editor with syntax highlighting, completion and autosave. Editing of query results. SSH tunneling support. Tons of other cool features. Quite good, but not 100% perfect PostgreSQL support (yet?). Regularly updated, as of 2018.


Linux, Unix


Database administration/user tool for GNOME, based on libgda/libgnomedb, which are a complete database-independent access layer for UNIX systems, with support for PostgreSQL, MySQL, Sybase, MS SQL Server, Oracle, Interbase/Firebird, MS Access files, xBase.

Last update: 2015


Kexi is part of the Calligra Suite and is released under the GNU General Public License (GPL) and LGPL.

available for FreeBSD & Linux, Apple, Windows, (Android) Does not support OS X.

Libre Office

New native driver for PostgreSQL databases (for versions > 8.4 - support for version 8.4 will be included in LibreOffice 3.5.1).


Linux, Windows and macOS

Open source full-featured tool for database management. Currently supports PostgreSQL (9.3 - 11), Oracle (11g - 18c), MySQL (5.6 - 8.0) and MariaDB (10.1 - 10.3). More RDBMS support coming soon, including the ability of converting databases from any supported RDBMS to PostgreSQL and back.

PASH-Viewer: PostgreSQL Active Session History Viewer

Java (multi-platform).

Open-source software which provides graphical view of active session history and help you to answer questions like "What wait events were taking most time?", "Which sessions were taking most time?", "Which queries were taking most time and what were they doing?". It also supports Active Session History extension by pgsentinel. Does not do DB inserts, modifications, etc.

pgAdmin 4

MS Windows, GNU/Linux, FreeBSD, Mac OS X, OpenBSD, Solaris


pgAdmin III is an Open Source management tool for PostgreSQL databases. Features full Unicode support, fast, multithreaded query and data editing tools and support for all PostgreSQL object types.

pgAdmin III is bundled with the Windows installer, and you can use that such a client to administer a remote server on another OS. Note that binary packages for platforms like RPM don't show up in every point release, you currently have to go back to v1.8.0 to get the last full set of packages.

Free Administration Centre for the PostgreSQL database. Includes a graphical administration interface, an SQL query tool, a procedural code editor and much more. pgAdmin III is designed to answer the needs of most users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. Available in more than 30 languages and for several operating systems.

pgrights: GUI for PostgreSQL roles, privileges and policies

MacOS (based on Electron, so versions for other OS can be build from source code).

Open-source software which allows you to easily understand what can do (and what can't) a PostgreSQL user with a table's data. In other words, it's a viewer of results of GRANT commands and row-level security rules applied for a particular table and for a particular role. Only modifies user rights, no other capability.


browser-based, requires webserver


Similar to the ever-popular phpMyAdmin, enhanced for PostgreSQL, supports browsing and modification of most types of PostgreSQL database objects, plus execution of ad-hoc queries. Maintained by (who else?) the phpPgAdmin team. (JMB 11.2002).

phpPgAdmin (and the required Apache and PHP packages) may be easily installed using Stack Builder if you are running a one-click-installer PostgreSQL distribution.


macOS, Linux and Windows

Open source, desktop application to manage your local or remote PostgreSQL databases.

SQL Workbench/J

Java (multi-platform)

An OpenSource SQL GUI tool similar to Squirrel. Data can be edited directly in the result set. It has strong support for exporting and importing data between databases using its own SQL command extension. It can be used in GUI mode or as a console application. All SQL Workbench specific commands can also be run in batch mode to automate export and import task. It supports schema comparison ("diff") and copying data between databases.


Platforms that support Java


SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. The minimum version of Java supported is 1.8.x as of SQuirreL version 3.8.1.

Sohag Developer

Sohag Developer

Gnu/Linux Windows (Other OS can compile from source code).

Build a powerful database applications following few steps using Sohag Developer . Sohag Developer currently supports PostgreSQL database and has a set of generators that generates (Qt/C++ code and ui forms - PHP web applications uses web forms and bootstrap framework ) to manipulate the data in the database tables or views.

TOra, an Oracle tool with some PostgreSQL support

Linux & Windows


An Oracle database administration interface, with limited ability to browse PostgreSQL databases (tables, views, and functions only). I'm told that if you have the Oracle libraries, Tora's sophisticated function editor will work for PostgreSQL as well. Developed by Henrik Johnson as a Quest Toad clone. (JMB 11.2002)


This is a list of "closed source" projects, some might have some manner of free version.



SQLGate is a simple but powerful IDE for multiple Database including PostgreSQL.

  • Powerful Data Grid and ERD
  • Multiple SQL Execution
  • Auto-Complete
  • Intuitive UI/UX
  • Multiple Themes
  • Fast processing speed

Use SQLGate to maximize your productivity!

dbForge Studio for PostgreSQL

PostgreSQL GUI tool for managing and developing databases and objects. The IDE for PostgreSQL allows users to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. It comes in two editions - Standard and Express (free).

Key features:

  • SQL Development
  • Database Explorer
  • Data Editor
  • Query Profiler
  • Data Export and Import
  • Pivot Table
  • Master-Detail Browser
  • Data Reports

EMS SQL Manager for PostgreSQL Freeware


EMS SQL Manager for PostgreSQL Freeware (EMS SQL Manager Lite for PostgreSQL) is an excellent and easy-to-use freeware graphical tool for PostgreSQL database administration. It has the minimal required set of tools for those users who are new to PostgreSQL server and need only its basic functionality. EMS SQL Manager for PostgreSQL Freeware allows you to work with servers, databases and schemas, view, edit, search, group, sort and filter any data stored in a database, create and execute SQL queries with powerful SQL editor, handle multiple selected objects at a time and much more.

WaveMaker Ajax GUI Design Tool

Windows, Macintosh, Linux

WaveMaker is an Ajax-based GUI design tool for Postgres. WaveMaker is built using itself! WaveMaker generates a standard Java WAR file based on Spring, Hibernate and Dojo. WaveMaker supports Postgres schema creation and import and includes a visual query editor.

AnySQL Maestro


AnySQL Maestro is a freeware tool for administering any database engine (PostgreSQL, SQL Server, Oracle, MySQL, MS Access, etc.), which is accessible via ODBC driver or OLE DB provider. Includes Database Designer, Visual Query Builder, BLOB Viewer/Editor, SQL Editor, Data export/import and other features.


browser-based, webserver included

AJAX/JavaScript-powered web interface for PostgreSQL administration. Browse, maintain and create data and database objects from anywhere, in the web browser. Supports SSH for both the web interface and the database connections. Rich interface with tabbed SQL editor with auto-completion, inline row-editing widgets, click-through foreign key navigation between rows and tables, 'favorites' management for commonly used scripts, and more.

Installers available for Windows, Mac and Linux, alternatively download a simple cross-platform archive that runs anywhere with simple script.

Postgres Compare

Postgres compare.png

Windows, Mac & Linux

A comprehensive tool for identifying the differences between databases and generating an update script to synchronize them. Postgres Compare reads the system catalogs to determine the structure of the database and compares it to another to find the changes. Generate SQL and deploy the alterations, save snapshots for later. Automate the process via the command line.

JetBrains IDEs - DataGrip, IntelliJ IDEA, PHPStorm, PyCharm, RubyMine, etc ...

Windows, Mac OS X, Linux

JetBrains has a dedicated SQL IDE — DataGrip which can connect to PostgreSQL as well. It provides code completion, multi cursors, local query history, navigation, refactorings and language injection support.

Other JetBrains Products, for example, PHPStorm, IDEA, have built-in database plugin, and it has the same functionality as DataGrip.

After you configured the data sources of your project, you can easily create tables, foreign keys, indexes much easier than usual, because the IDE is very smart; for example by foreign keys it automatically sets the name of the key and the related columns. For me, it is so far the best experience by creating a basic database schema. Even with editable EER models was it slower... By the settings of pantun romantis terbaru your data source you can configure the SQL dialect of your database. After that, if you want to add stored procedures or triggers, you will have code completion which is favorable too. So I think JetBrains products speed up your work if you exactly know what you want, and how can you make it.

For any JetBrains IDE, there is a free license for open source projects. For enterprise usage there is a 30 days trial, after that, you can buy a personal or proprietary license which is very cheap compared to other products.

For PyCharm (even the Community Edition) you can install the free third-party plugin Database Navigator (Settings -> IDE Settings -> Plugins). It appears to deliver the same functionality described above for PHPStorm. You will get a new menu DB Navigator, left to the Help menu.



A modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases, including PostgreSQL.

  • True native built.
  • Workspace supports multiple tabs, multiple windows
  • Powerful SQL editor with full features: auto syntax highlight, auto-suggestion, split pane, favorite and history.
  • Data Filter & Sorting, import & export
  • Full-dark theme & modern shortcut

With plugin system, you can be able to write your own new features to work with database per your needs (export charts, pretty json…).


OS X Yosemite+ only, free, "Sequel Pro" inspired.

Last update: 2018

SQLPro for Postgres

Mac OS X 10.8 and above


  • 100% native OS X app with a clean and simple to use interface.
  • Query editor with syntax highlighting and autocomplete.
  • Support for multiple result set execution.
  • History feature, displaying your last ten executed queries.
  • Primary key detection for inline result set modifications.
  • Custom theme support allowing developers to work with style.


Mac OS X

Postico is a fully native Mac app for connecting to your PostgreSQL server. It supports encrypted connections via SSL and SSH to PostgreSQL 8.0 and later, including Amazon Redshift.

Postico has a powerful table content editor with in-cell editing and form-based row editing in a sidebar. You can quickly filter tables by keywords or even complex SQL expressions.

There's also a table structure editor for editing columns, types, default values, foreign keys, check constraints etc.

Finally, there's a convenient SQL Query Editor with support for query history and syntax highlighting. It also has convenience features like auto-indent and shortcuts for comment line etc.

SEQUEL for PostgreSQL


SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature-rich GUI that makes it the best assistant tool for developers and admins. SEQUEL is lightweight, fast and powerful that it can significantly simplify the DB management process. For those who cannot live without a CLI, SEQUEL offers a powerful Query Editor with syntax highlight, autocomplete and a Console log view that is always visible, so you can monitor the communication with your databases. It includes:

  • Database management forms for Schema, Table, Index, Foreign key, Trigger, Rule, Sequence, Collation, Domain, Enum type, Tablespace and Language objects with full parameters support
  • Assistant info views for Object information, Actions, Help, and Documentation
  • Jump bar for quick objects selection and navigation
  • Taskbar with multi-task monitoring support
  • Console log view
  • Syntax highlight, autocomplete, current and selection query execution and explain, line numbering and working statement detection
  • Direct editing in the results view, query results explanation
  • Powerful Field editor
  • Transaction based database updates
  • Code preview and Content editing

dbForge Data Compare for PostgreSQL

Microsoft Windows 2000/XP/2003/Vista and Windows 7, 8, 10

dbForge Data Compare for PostgreSQL by Devart is a tool for table data comparison and synchronization. When using PostgreSQL data compare tool developer can detect data differences in compared PostgreSQL tables; generate data synchronization script and execute it to eliminate all these differences.

Key features:

  • Identify the differences between two databases
  • Compare separate tables or table groups by table name mask
  • Compare tables with different structure
  • Generate a report embodying data diff and save it for further analysis
  • Sync data in tables and views in full or in part
  • Generate SQL script for database synchronization
  • Organize database synchronization according to the schedule

Full Convert

Database conversion and synchronization between PostgreSQL and Microsoft Access, dBase, FoxPro, Microsoft Excel, Firebird, Interbase, MySQL, Oracle, Paradox, Microsoft SQL Server, SQL Server, SQL Server Azure, SQL Server Compact(SQLCE), SQLite, Delimited text files (CSV), XML and many more via ODBC.

Replicator Pro

Replicator allows table data comparison and sync - even with heterogeneous databases. It is unique in the fact it can replicate changes only even if source is non-relational (CSV, DBF, Excel documents, Paradox...). Replicator has a built-in scheduler for easy periodic change replication.

Nucleon Database Master for PostgreSQL and Others

Nucleon Database Master is a modern, powerful, intuitive, easy to use and all in one PostgreSQL MongoDB, Oracle, DB2, Informix, Ingres, SQL Server, SQL Azure, MySQL, FireBird, SQLite client application with a consistent interface that simplifies managing, querying, editing, visualizing, designing and harga tablet axioo reporting relational and schema-free (NoSQL) database systems. You can connect any database system via ODBC and OleDB connections.Using Database Master, you can execute SQL, LINQ, JSON queries or you can create, edit and delete all database objects such as tables, views, procedures, columns, indexes, collections, and triggers. You can execute SQL queries and scripts, view and edit table data including BLOBs (Image, Text or any file), represent tables and its relations as an ER(Entity Relationship) diagram.

Info: Windows, other platforms via WINE Admin

DBTools Manager



Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines. Developed by DBTools Software.


Windows, Linux version just released


Basically a proprietary, more powerful version of PGAdmin II or PGAccess. Adds support for trigger and constraint editing, metadata logging, and query monitoring. Also includes multiple-format data import/export tools, which are also available on their own for Linux. Developed by EMS Hitech. (JMB 4.2003).

DeZign for Databases



DeZign is a database development tool using an entity relationship diagram. It visually supports the layout of the entities and relations and automatically generates SQL schemas for most leading databases including PostgreSQL.

Case Studio 2 / Toad Data Modeler



Commenter 1: I just downloaded the trial version, so far it looks really promising and claims to support PostgreSQL. Handles reverse engineering of existing databases, and has a really nice interface for setting up tables, relationships etc. You can get a lite or full version. The description from the website... Professional database modeling tool for various databases. CASE Studio 2 includes following key features:

LITE version features + Reverse Engineering from various database systems Version Manager Data Flow Diagrams Definition of user-defined variables Large COM interface Users, User groups and User permission support and many more.

Case Studio was acquired, and renamed 'Toad Data Modeler'.

Commenter 2: I've used the licensed version before and after the name change. PostgreSQL support is excellent.

PostgreSQL PHP Generator


PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.


Macintosh pgEdit is a high-performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.

pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.

pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.



RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool that supports PostgreSQL and any other JDBC or ODBC compliant database. Some of the major features are tools for creating, dropping, and altering objects such as tables, views, indexes, triggers, functions, users, and databases; a programming editor that supports 20 different programming languages; import and export tools; auto column and table lookup; and a query builder, query scheduler, and SQL formatter.

MicroOLAP Database Designer

Windows ODBC

Database Designer for PostgreSQL is an easy CASE tool with an intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.

Import / Export and synchronization tools for PostgreSQL

Microsoft Windows 8 / 7 / Vista / XP / 2000 / NT. The software is able to connect to remote PostgreSQL 9.x/7.4 located on Linux, Solaris, Mac OS X, and Windows.

ConvertDB cross-database migration tools assist in data conversion and synchronization among PostgreSQL, MySQL, MS SQL Server, MS Windows SQL Azure, and MS Access databases

  • 1 Million of records can be transferred in 5-10 minutes.
  • Bi-directional synchronization between PostgreSQL, MS SQL, MySQL and Oracle
  • Scheduling migration and synchronization jobs.

dbForge Studio for PostgreSQL

Microsoft Windows 7, 8, 10

dbForge Studio for PostgreSQL is a brand new tool for PostgreSQL databases development, management, and editing process enjoyable and easy by Devart. The PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to the requirements in a convenient and UI. The tool provides the PostgreSQL data editor functionality for queries customization and property window for the viewing all the required information of PostgreSQL database objects.

Key features:

  • Code Completion helps to improve code quality when creating and editing queries with List Members, Parameter Info, Quick Info, Complete Word.
  • Object Explorer for easy navigation through the object tree. You can retrieve data from the database on a single SQL document, truncate a table, select Properties to view some information on the object.
  • Data Editor for management settings of tables, such as adjust column width, set either paginal or auto-search mode by default. Color and format rows and cells using a rich set of fonts and size. The tool has predefined data type formats to meet your own needs.

dotConnect for PostgreSQL


dotConnect for PostgreSQL, formerly known as PostgreSQLDirect .NET, is an enhanced ORM enabled data provider for PostgreSQL that builds on ADO.NET technology to present a complete solution for developing PostgreSQL-based database applications. It introduces new approaches for designing application architecture, boosts productivity, and leverages database applications.

Key features:

  • Direct Mode
  • Database Application Development Extension
  • PostgreSQL Advanced Features Support
  • Optimized Code
  • ORM Support
  • BIS Support

PostgreSQL Data Access Components


PostgreSQL Data Access Components (PgDAC) is a library of components that provides native connectivity to PostgreSQL from Delphi, C++Builder, Lazarus (and Free Pascal) on Windows, Mac OS X, iOS, Android, Linux, and FreeBSD for both 32-bit and 64-bit platforms. PgDAC is designed to help programmers develop really lightweight, faster and cleaner PostgreSQL database applications without deploying any additional libraries.

Native Connectivity to PostgreSQL PgDAC is a complete replacement for standard PostgreSQL connectivity solutions and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to PostgreSQL. It provides direct access to PostgreSQL without PostgreSQL Client.

ODBC Driver for PostgreSQL


Devart ODBC Driver for PostgreSQL provides high-performance and feature-rich connectivity solution for ODBC-based applications to access PostgreSQL databases from Windows, both 32-bit and 64-bit. Full support for standard ODBC API functions and data types implemented in our driver makes the interaction of your database applications with PostgreSQL fast, easy and extremely handy.

Excel Add-in for PostgreSQL


Devart Excel Add-in for PostgreSQL allows you to quickly and easily connect Microsoft Excel to PostgreSQL, load data from PostgreSQL to Excel, instantly refresh data in an Excel workbook from the database, edit these data, and save them back to PostgreSQL. It enables you to work with PostgreSQL data like with usual Excel worksheets, easily perform data cleansing and de-duplication, and apply all the Excel's powerful data processing and analysis capabilities to these data.

EMS Database Management Tools for PostgreSQL


PostgreSQL Tools Products Family:

  • SQL Management Studio for PostgreSQL - a single workbench for administering PostgreSQL databases, managing database schema and objects as well as for database design, migration, extraction, query building, data import, export, and database comparison.
  • SQL Manager for PostgreSQL - high performance graphical tool for PostgreSQL database administration and development. It makes creating and editing PostgreSQL database objects easy and fast, and allows you to run SQL scripts, visually design databases, build SQL queries, extract, print and search metadata, import and export PostgreSQL database data and much more.
  • Data Export for PostgreSQL - tool to export PostgreSQL database data quickly to any of 19 available formats, including MS Access, MS Excel, MS Word, RTF, HTML, TXT, ODF and more. Data Export for PostgreSQL has a kata kata lucu friendly wizard, which allows you to set various options of PostgreSQL export process visually and a command-line utility to automate your PostgreSQL export jobs using the configuration file.
  • Data Import for PostgreSQL - tool to import data to PostgreSQL tables from MS Excel 97-2007, MS Access, DBF, TXT, CSV, MS Word 2007, RTF, ODF and HTML files. This utility allows you to quickly import data to one or several PostgreSQL tables or views at once, save all PostgreSQL import parameters set on current wizard session, use special batch insert mode to import PostgreSQL data at the maximum possible speed and much more.
  • Data Pump for PostgreSQL - migration tool for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to PostgreSQL databases.
  • Data Generator for PostgreSQL - tool for generating test data to PostgreSQL database tables. The utility can help you to simulate the database production environment and allows you to populate several PostgreSQL database tables with test data simultaneously, define tables for generating data, set value ranges, control a wide variety of generation parameters for each field type and much more.
  • DB Comparer for PostgreSQL - a tool for comparing PostgreSQL database schemas and discovering differences in their structures. You can view all the differences in compared database objects and execute an automatically generated script to synchronize structure of PostgreSQL databases and eliminate these differences.
  • DB Extract for PostgreSQL - easy-to-use tool for creating PostgreSQL database backups in a form of SQL scripts. This database script utility allows you to save metadata of all PostgreSQL database objects as well as PostgreSQL table data as database snapshots.
  • SQL Query for PostgreSQL - a useful tool that lets you quickly and simply build SQL queries to PostgreSQL databases. Visual PostgreSQL query building, as well as direct editing of a query text, is available.
  • Data Comparer for PostgreSQL - tool for PostgreSQL data comparison and synchronization. Using this utility you can view all the differences in compared PostgreSQL tables and execute an automatically generated script to eliminate these differences.

SQL Maestro Group products for PostgreSQL


SQL Maestro Group offers a number of tools for PostgreSQL.

  • PostgreSQL Maestro allows you to create, edit, copy, drop and dump database objects easy and fast. You can also design your database as ER diagram, build queries visually, execute SQL queries and scripts, debug PL/pgSQL functions, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), manage PostgreSQL roles, users, groups and privileges, and use a lot of other admin tools designed for making your work with PostgreSQL database server comfortable and efficient.
  • PostgreSQL Data Wizard provides you with a number of easy-to-use wizards to transfer any database to PostgreSQL, export data from PostgreSQL tables, views and queries to most popular formats, and import data from various sources into PostgreSQL tables.
  • PostgreSQL Data Sync is a powerful and easy-to-use tool for database contents comparison and synchronization.

SQL Maestro Group also produces similar tools for MySQL, Oracle, MS SQL Server, SQLite, Firebird, DB2, SQL Anywhere, and MaxDB.

Datanamic DataDiff for PostgreSQL


Datanamic DataDiff for PostgreSQL is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization. DB Data Difftective can be used for data migrations, verification of (corrupt) data, data auditing etc.

Datanamic SchemaDiff for PostgreSQL


Datanamic SchemaDiff for PostgreSQL is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.

DB MultiRun PostgreSQL Edition


DB MultiRun is a simple tool to execute multiple SQL scripts on multiple databases quickly. Define a list of databases, add SQL scripts to execute on these databases and click "execute" to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts, you can examine the results of the executed scripts on each database.



SqlPro is an easy to use database GUI tool for six popular databases (Oracle, MySQL, PostgreSQL, SQL Server, SQLite, and Access). One IDE makes database administration and development faster and error free. SQLPro Key Features: color-coding of the SQL, drag-and-drop of objects into the editor pane to save you from typing their names, retrieval of SQL code for things like stored procedures and triggers from the underlying database, and one-click creation of SELECT and INSERT statements. You can open, save and print SQL scripts. SQLPro uses native drivers to connect to the databases (no ODBS or third party engines to install).

DB Doc


DB Doc helps you document your database structure and objects. Documents can be generated as PDF reports, HTML pages, Microsoft Word (docx) file, or a single compiled HTML file. The layout is fully customizable, and you can quickly view inter-object dependencies using hyperlinks.

DB Doc supports PostgreSQL 8.3 to 9.4.

SQL Blob Export


SQL Blob Export exports unlimited images and files from your tables or queries in 5 simple steps.

SQL File Import


SQL File Import allows you to upload files, images, and other data into your database, without having to write any SQL statements. SQL File Import supports PostgreSQL, Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL).

A scripting engine allows you to transform data before importing them into your database. A command line version is also included to allow you to perform unattended upload/import tasks.

SQL Image Viewer


SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.

It also allows you to export binary data and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.

A command line version is also included to allow you to perform unattended scheduled exports of binary data.

SQL Multi Select


SQL Multi Select is a query tool that allows you to run multiple scripts on multiple servers with a single click. Result sets from different servers are consolidated into a single view, allowing for easy comparison and analysis.

SQLTool Pro Database Editor


SQLTool Pro is a professional Android SQL editor for MySQL, SQL Server, PostgreSQL, Sybase, and Oracle Databases.

SSIS Data Flow Components for PostgreSQL


Devart SSIS Data Flow Components for PostgreSQL allow you to integrate database and cloud data via SQL Server Integration Services (SSIS).

Devart SSIS Data Flow Components provide easy to set up cost-effective data integration using SSIS ETL engine. They provide high performance data loading, convenient component editors, SQL support for cloud data sources and lots of data source specific features.


Windows/OS X/Linux/UNIX

DbVisualizer is a feature rich, intuitive multi-database tool for developers, database administrators, and increasingly for advanced analysts providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most cost effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.

Valentina Studio (Free)

Windows/OS X/Linux/

Valentina Studio is a powerful PostgreSQL Database Server administration and development tool. It offers for free many advanced editors:

  • Schema Editor with Tree and Column views
  • Diagram Editor with reverse engineering
  • SQL Editor with auto-completion, syntax-highlighting, recent and favorite queries, templates of commands, many result tab-panels, ...
  • Data Editor with easy sorting and filtering of records without SQL, in-cell editing.
  • Related Data Editor that allow s you to learn related records in different modes.
  • Import/Export
  • SQL dumps
  • and so on ...

Valentina Studio PRO - adds additional advanced features as:

  • Report Editor to developer reports based on Valentina Report Engine with datasources from PostgreSQL and other databases.
  • Diagrams forward engineering
  • Data Transfer


Html5 Web Browser (Linux/Mac OS X/Windows)

JackDB is a database client that runs entirely in your web browser. There's no software to install locally so you can use it on Mac OS X, Linux, and Windows and it works on all major modern browsers (eg. Chrome, Firefox, IE, Safari, and Opera). It supports connecting to PostgreSQL, as well as MySQL, Oracle, and SQL Server databases.


  • Html5 interface with no client installation
  • Query editor with syntax highlighting
  • Scrolling result sets
  • Schema/Object browser
  • SSL connections with certificate pinning
  • Eliminates password sharing
  • Two-factor authentication
  • BLOB display (images and Html5 audio/video)

Tadpole DB Hub

Tadpole DB Hub is Unified infrastructure tool, a various environment based interface for managing Apache Hive, Amazon RDS, CUBRID, MariaDB, MySQL, Oracle, SQLite, MSSQL, PostgreSQL and MongoDB databases. It enables you to handle typical DB over the World Wide Web.


  • Intuitive web interface (Safari, Chrome, IE 10, Firefox)
  • User Management (Admin, Manager, User)
  • Select, Insert, Update, Delete
  • Download query result
  • SQL Syntax Highlighting
  • SQL Formatting
  • SQL Statement <-> Java, PHP String Literal Each Convert
  • SQL Assist
  • Execute SQL Statement
  • SQL Result Set to CSV
  • SQL History And Export text
  • Generate SQL Statement (Select, Insert, Update, Delete, Table, View, Index, Procedure, Function, Trigger)
  • Generate ER Diagram (Auto Layout)


Vertabelo is an online database designer working under Chrome. It free to use for smaller projects and have a proprietary version for larger database projects.


  • Intuitive HTML5 web interface (Chrome)
  • OS independent
  • Sharing DB model with team members
  • Support for PostgreSQL, MySQL, Oracle, MS SQL Server, DB2, SQLite, HSQLDB,
  • Model versioning
  • Dynamic/Visual search
  • Live model validation
  • Reverse engineering


PostgreSQL Database Modeler

PostgreSQL Database Modeler, or simply, pgModeler is an open source tool for modeling databases that merges the classical concepts of entity-relationship diagrams with specific features that only PostgreSQL implements. The pgModeler translates the models created by the user to SQL code and apply them onto database clusters from version 8.0 to 9.1. $3.50 per copy as of 2014/04/09.


GenMyModel is an online modeling tool supporting database modeling. It is free to use for smaller projects and have a proprietary version for larger database projects.


  • Intuitive HTML5 web interface (Chrome, Firefox, Safari, Internet Explorer)
  • OS independent
  • Instant sharing and collaboration
  • Customizable SQL generators
  • Model versioning
  • Live model validation


Web Browser (Linux/Mac OS X/Windows)

DBHawk is a web based SQL tool and reporting software designed for PostgreSQL, Oracle, SQL Server and other databases. Its easy to deploy and use.


  • Web based interface with no client installation
  • Advanced Query editor with syntax highlighting and multi tabs results
  • Online visual query builder
  • Online SQL Report Builder
  • Online SQL Job Scheduler
  • Export results to html, csv, pdf, google docs, amazon s3
  • SQL Auditing and Security
  • Schema/Object browser
  • SQL and data snippet sharing
  • Blob data viewer and editor


Windows, Mac OS X, Linux

Datazenit is a cross-platform PostgreSQL and MySQL GUI with data grid, schema builder and interactive charts. It also has query builder, raw query editor with auto-complete, team collaboration features like connection, query and chart sharing among team members.

EDB Postgres Enterprise Manager

Windows, Mac OS X, Linux

Postgres Enterprise Manager is the only solution available today that allows you to intelligently manage, monitor, and tune large scale Postgres installations from a single GUI console.

Monitoring features include: server auto-discovery, over 225 pre-configured ready to run probes, custom probes, alert management, personalized alerts, remote monitoring, versatile charting, custom dashboards and web client.

DBA tools include: database objects management, Postgres Expert (best practice configuration settings), Audit Manager, Log Manager, Log Analysis Expert, Capacity Manager and Team Support.

Developer tools include: Query Tool, Data Grid, SQL Profiler, SQL Debugger and Import tools.

Tuning tools include: At-A-Glance performance dashboards, Tuning Wizard, Performance Diagnostics and Index Advisor.

ClusterControl by Severalnines

ClusterControl is an all-inclusive open source database management system that allows you to deplore, monitor, manage and scale your database environments. ClusterControl provides the basic functionality you need to get PostgreSQL up-and-running using our deployment wizard, monitoring and basic management abilities like automatic failover, backups, and restores.

  • Point and Click Replication Deployments - ClusterControl allows you to easily deploy and configure master/slave replication PostgreSQL instances.
  • Advanced Performance Monitoring - ClusterControl monitors queries and detects anomalies with built-in alerts.
  • Automated Failover Handling - ClusterControl detects master failures and automatically promotes a new master
  • Database Automation - ClusterControl lets you manage configurations, schedule, and restore backups.

Database Tour Pro

Database Tour Pro is a database tool with built-in report builder for Windows. It works with different types of relational databases including PostgreSQL.

Key features:

  • Creating tables.
  • Viewing and editing data.
  • Several ways to print data.
  • Built-in report engine and visual report designer with templates, expressions, preview etc.
  • Expression builder for report and export expressions.
  • Building and executing SQL queries. Support for execution of multi statement SQL scripts. Syntax highlighting in SQL editor. Support for parameterized SQL queries.
  • Enhanced database grids, which allow to view and manipulate the data in the most convenient way, including sorting by clicking column header, changing row heights, resizing columns etc.
  • Command line support for executing queries, opening tables, export-import operations, loading reports etc. with logging the performed operations.
  • Searching and replacing text in database with ability to choose fields, record range etc.
  • Importing data to table from another table or a query.
  • Exporting data from open table or query to file(s) like text, CSV, HTML, XLSX, XML, RTF, DBF or to another relational database of any supported type (i.e. ODBC, PostgreSQL, Oracle, SQL Server, dBase, Interbase, SQLite, MS Access, Firebird etc).
  • Copying data to clipboard.
  • Viewing and editing Blob data, such as large text and graphics.
  • Tools for editing text fields (trimming, changing case of symbols, replacing text).
  • Customized data view (font, background).
  • Conditional formatting data in database grids and reports.
  • Ability to control transactions.


Reportizer is a database reporting tool, which allows easy creating, modifying, and printing database reports from different types of databases, including PostgreSQL. Reports can be edited in convenient visual report builder or in text mode. It supports calculating fields, multi-column reports, expressions, grouping, displaying images etc. Reportizer can export reports to HTML, XLSX, image, or internal format. There is an ability to load and print reports from command line. Reportizer allows to manage report collections, which can be held either in files or in database tables.

Exportizer Enterprise

Exportizer Enterprise is a database export tool, which can work with PostgreSQL database either as source or destination. It allows to export data to database, file, clipboard, or printer.

  • Possible sources: ODBC data sources, files of DB (Paradox), DBF (dBase, FoxPro), MDB, ACCDB, XLS, XLSX, GDB, IB, FDB, HTML, UDL, DBC, TXT, CSV types, databases specified by ADO connection strings, and databases like Oracle, SQL Server, PostgreSql, DB2, Informix, SQLite, Interbase etc.
  • Possible destinations: file formats like text, CSV, XLS, XLSX, RTF, XML, HTML, PDF, DBF, SLK, SQL script, and relational database of any supported type including PostgreSQL.
  • It is possible to export all or selected tables from an open database at once.
  • The data migration can be done in super-fast batch mode.
  • Exportizer Enterprise can automatically detect the most known image types (JPEG, PNG, GIF, BMP, ICO) in BLOB fields and export them, for example, to HTML or XLSX.
  • Images and other BLOB data can be exported to multiple separate files during a single export operation.
  • There is an ability to specify the source-to-target field mappings.
  • Export operations can be performed either via the program interface or via command line.

TiCodeX SQL Schema Compare

TiCodeX SQL Schema Compare is a tools that allows database administrators to compare multiple database schema in order to manage versioning.
The software runs on Windows, Linux and Mac and supports Microsoft SQL (MS-SQL), MySQL, PostgreSQL, Azure SQL and MS-SQL on Amazon RDS.

Key Features:

  • Runs on Windows, Linux and MacOS
  • Localized in English, German and Italian
  • Compare changes between two SQL Database schemas (as example from development to test to production)
  • View database differences and explore schema changes to see what's going on
  • Automatically create full database migration scripts
  • Securely save database and server login details


pgMustard is a performance tool for PostgreSQL that provides a user interface for your EXPLAIN ANALYSE output, as well as tips on what to do to speed up your query.


  • Quickly see the slowest operations
  • Code snippets to tie operations back to the query
  • Tips to speed up your query💡
  • Does the arithmetic for you (including wall clock times)
  • Explanations of operation types and key concepts
  • Links to relevant documentation and blog posts


  • JSON format plans
  • Any supported version of PostgreSQL
  • English language only
  • Web application, no installation required

No longer Supported/Developed

To see the list of seemingly abandoned/unmaintained projects (no release in last 5 years) see Community_Guide_to_PostgreSQL_Tools_Abandoned

Personal tools