PostgreSQL Clients

From PostgreSQL wiki

Jump to: navigation, search

This page is a partial list of interactive SQL clients - that doesn't include reporting engines, ETL data loaders, visual design tools, just interactive clients that you can type SQL in to and get results from them.

Contents

CLI Clients

psql

https://www.postgresql.org/docs/current/static/app-psql.html

The standard command line client, maintained by the postgresql development group and typically distributed as part of the server installation.

pgcli

https://www.pgcli.com

A command line client with syntax highlighting and pop-up command completion.

macOS GUI Clients

Open Source / Free Software / Zero Cost

PSequel

http://www.psequel.com/

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

Postbird

https://github.com/paxa/postbird

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

pgEdit

http://pgedit.com

Not a standalone client, rather a plugin for Textmate for using psql.

Postico

https://eggerapps.at/postico/

A nice native client by the developers of Postgres.app. A free "demo" version of an inexpensive commercial app, but it has very reasonable limits and no time limit.

SQLPro for Postgres

http://www.macpostgresclient.com/SQLProPostgres

macOS 10.8 and above

100% native OS X app with a clean and simple to use interface. Query editor with syntax highlighting and autocomplete.

Commercial

SEQUEL for PostgreSQL

http://www.sequel.tech

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.

Windows GUI Clients

Open Source / Free Software / Zero Cost

AnySQL Maestro

http://www.sqlmaestro.com/products/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.

Marshal SQL Utility

http://www.risetobloome.com/Page_1_S.aspx?ITEM=1756

The Marshal SQL Utility is a generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns.

EMS SQL Manager for PostgreSQL Freeware

http://www.sqlmanager.net/en/tools/free

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.

There is a commercial version available with significantly more functionality.

DBTools Manager

http://www.dbtools.com.br

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.

Commercial

PostgreSQL Maestro

https://www.sqlmaestro.com/products/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.

Access

https://products.office.com/en-us/access

Yes, you can use MS Access as a PostgreSQL database interface. Supports data access to PostgreSQL tables and views; many ODBC-based limitations and errors.

VSQL++ for PostgreSQL

http://www.sqlpp.com/products/postgresql-management/

A powerful Postgresql database management tool to help DBA sto manage the database objects easy and quickly.

Nucleon Database Master

http://nucleonsoftware.com/products/database-master

Supports PostgreSQL MongoDB, Oracle, DB2, Informix, Ingres, SQL Server, SQL Azure, MySQL, FireBird, SQLite

SQLPro

http://www.vive.net/products/sqlpro.htm

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.

Obsolete or End-of-Life

PGExplorer

http://www.PGExplorer.com

Hasn't been significantly updated in many years, but latest downloads suggest it may support Postgresql 9.* to some extent.


Linux / Unix GUI Clients

Open Source / Free Software / Zero Cost

Gnome DB

http://www.gnome-db.org

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.

Has an experimental Windows build available too.

Kexi

http://www.kexi-project.org/

A visual database application creator, c.f. Access or FileMaker

Cross-platform GUI Clients

Open Source / Free Software / Zero Cost

pgAdmin 3

http://www.pgadmin.org/

Windows, Linux, FreeBSD, macOS, OpenBSD, Solaris

For many years the "standard" freely available GUI client for Postgresql, and so is bundled in many packaged installers. It provides a SQL query tool, an editor for procedural languages and a CRUD interface. It's also one of the few clients to provide a GUI front end to the plpgsql debugger.

Development has been discontinued by pgadmin.org, but it is still being maintained by BigSQL who are doing basic maintenance to support current versions of PostgreSQL and packaging it for current OS releases [here]

pgAdmin 4

http://www.pgadmin.org/

Windows, macOS, rpm, Python

pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it's primarily a web application that's also packaged as desktop web shell. At the time of writing it's considered inferior to pgAdmin 3 both in terms of functionality and stability.

LibreOffice Base

http://www.libreoffice.org/discover/base/

Supports MySQL/MariaDB, Adabas D, MS Access and PostgreSQL, as well as other JDBC/ODBC databases.

Tora

http://tora.sf.net/

Linux, Windows, macOS

Oracle, MySQL, and PostgreSQL, as well as limited support for ODBC targets. Inspired by the commercial Toad client.

SQL Workbench/J

http://www.sql-workbench.net

Java

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.

Druid III

http://druid.sourceforge.net/

Java

The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information.

Power*Architect

http://www.sqlpower.ca/page/architect

Java

Power*Architect is an ERD modelling tool that is based on Java and JDBC. Support for forward and reverse engineering PostgreSQL databases is supported. It's OpenSource with a GPL license.

DBeaver

http://dbeaver.jkiss.org/

Eclipse/Java

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 2015.

RazorSQL

http://www.razorsql.com/

Macintosh/Windows/Linux/Solaris

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.


Valentina Studio (Free)

http://www.valentina-db.com/valentina-studio-overview

Windows/OS X/Linux

Valentina Studio is a powerful PostgreSQL Database Server administration and development tool.

There is a commercial version available with additional functionality.

Postage

https://github.com/workflowproducts/postage

Claims not to be maintained, but has had recent repo updates and is fixing bugs. Is a web app, but also available as a packaged desktop app.

Commercial

JetBrains DataGrip

https://www.jetbrains.com/datagrip/

Windows, macOS, Linux

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

Other JetBrains IDEs have plugins available to provide similar functionality.

Aqua Data Studio

http://www.aquafold.com/index-postgresql.html

Java: Windows/Linux/macOS/Solaris

Aqua Data Studio is a management tool for the PostgreSQL relational database w/ administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects, database storage and maintain database security. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio also provides an import and export tool to allow users to easily move data in and out of the PostgreSQL database in and from different data formats.

Navicat

https://www.navicat.com/en/products/navicat-for-postgresql

Windows, macOS, iOS

Navicat is a powerful PostgreSQL Database Server administration and development tool. It works with PostgreSQL 8.0 version or above and supports most of the PostgreSQL features including Trigger, Function, View, Manage User, and so on. It is also not only sophisticated enough for professional developers, but also easy to learn for new users. With its well-designed GUI, Navicat lets you quickly and easily create, organize, access and share information in a secure and easy way.

DbVisualizer

http://www.dbvis.com/

Windows/macOS/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.

Datazenit

https://datazenit.com/

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.

Web-based, but available packaged as a desktop app.

Android

Commercial

SQLTool Pro Database Editor

http://www.sqltoolpro.com

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

Web Clients

Open Source / Free Software / Zero Cost

franchise

https://franchise.cloud/

Web client, either hosted (free) or running locally, connects to a local postgresql instance via a small bridge application.

Can share the interface with others, rather like sqlfiddle.com, but accessing your database.

pgAdmin 4

http://www.pgadmin.org/

Python

pgAdmin 4 is a ground-up rewrite of pgAdmin 3. Rather than being a native application it's primarily a web application that's also packaged as desktop web shell. At the time of writing it's considered inferior to pgAdmin 3 both in terms of functionality and stability.

TeamPostgreSQL

http://www.teampostgresql.com

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.

Adminer

http://www.adminer.org

PHP

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

OmniDB

https://github.com/OmniDB/OmniDB

Django/Python

Open source full-featured web tool for database management. Currently supports PostgreSQL only. More RDBMS support coming soon, including the ability of converting databases from any supported RDBMS to PostgreSQL and back.

Tadpole DB Hub

https://github.com/hangum/TadpoleForDBTools/wiki

Tadpole DB Hub is Unified infrastructure tool, 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.

SIDU

http://topnew.net/sidu/

PHP

Schema and data browser and editor.

Commercial

JackDB

http://www.jackdb.com/

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.

A hosted service, so it requires external access to your database.

DBHawk

https://www.datasparc.com/dbhawk/

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.

Query editor, report builder, schema and data browser.

Datazenit

https://datazenit.com/

Java

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.

Web-based, but available packaged as a desktop app.

Obsolete or End-of-Life

phpPgAdmin

http://phppgadmin.sourceforge.net/doku.php

PHP

Similar to phpMyAdmin, enhanced for PostgreSQL, supports browsing and modification of most types of PostgreSQL database objects, plus execution of ad-hoc queries.

(last updated 2013, 9.2.x)

Other Resources

Community Guide to PostgreSQL GUI Tools - the source for a lot of this page. Includes many non-client tools, such as bulk loaders, schema diff, schema design, etc.

Database Administration, Reporting, and Light application development - from 2009

GUI Database Design Tools - tools for designing database schemas

Personal tools