Follow
DevelopmentOSX

What are the best Mac OS X GUIs for PostgreSQL?

13
Options 
Considered
180
User 
Recs.
Last 
Updated
Related Questions
Activity
Ad
Have feedback or ideas?
Discord logoJoin our community
on Discord
Here’s the Deal
Slant is powered by a community that helps you make informed decisions. Tell us what you’re passionate about to get your personalized feed and help others.

The Best 2 of 13 OptionsWhy?

13 Options ConsideredPriceLast Updated
Excellent
DataGrip
Apr 21, 2018
Excellent
DBeaver
Apr 8, 2018
pgAdmin 4
Apr 17, 2018
Postico
Apr 11, 2018
Navicat for PostgreSQL
Apr 8, 2018
See Full List
Excellent

DataGrip

Add Video or Image
Endi Sukaj
Omar
Laura Kyle
Top Pro

Supports multiple languages

•••
DataGrip is not a language-specific IDE. It supports a wide variety of languages by default, such as PostgreSQL, MySQL, Oracle, Microsoft SQL Server, Derby, H2, Sqlite, and many more. You can also specify your own JDBC drivers to get support for additional platforms.
Endi Sukaj
Laura Kyle
Top Pro

Beautiful and customizable UI

•••
DataGrip currently provides two theme options, light and dark. The UI is intuitive to navigate and provides powerful features such as a diagram view of table relationships.
Ray
Top Pro

Refactoring support

•••
You can refactor SQL code with DataGrip — it resolves all references automatically and when an object/variable is renamed, you can choose to update all references to it in your project.
Ryan
Top Pro

Helps you avoid mistakes

•••
It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers.
Laura Kyle
Omar
Top Pro

Version control support

•••
DataGrip supports a wide variety of VCS tools out of the box so that you can edit, test, and commit changes without ever leaving the tool.
Maxim Sobolewski
Top Pro

Powerful data editor

•••
A powerful table editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited...
Ryan
Maxim Sobolewski
Top Pro

Excellent code completion

•••
DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code.
Ray
Top Pro

Much more powerful than its counterparts

•••
DataGrip is a full-featured IDE for working with databases and SQL. It includes commonly found features in database clients, and offers IDE-specific features beyond that — version control, autocompletion, refactoring support, etc.
amir
Top Con

Not user friendly

•••
Matt McElheny
Top Con

Expensive

•••
This is an annual subscription with tiered pricing that diminishes a small amount year over year. But there are other much cheaper or free alternatives. This is the premium priced product of the bunch.
Ray
Top Con

Performance can be slow/sluggish when working with high-volume databases

•••
As with all other IDEs, DataGrip is powerful and thus requires more resources than usual. It can use up to several GB's of memory when working with high-volume databases, and this has an impact on performance if your system is not equipped to handle it.
See 5 more ProsSee 9 more Pros & Cons
Excellent

DBeaver

Add Video or Image
Peter Carter
Top Pro

Supports a range of common and less common database types

•••
For a free product the range of technologies supported is excellent, meaning if you end up switching database technologies, you don't have to learn a new GUI.
Peter Carter
Top Pro

Free and open source

•••
Peter Carter
Top Pro

Works easily out of the box

•••
Setup is simple and program even prompted to create a sample database to help beginners.
CromulentLotan
Top Pro

Free

•••
It it licensed under GPL v2.
WhiteLilac
CromulentLotan
Top Pro

Easy to use, clean neat interface

•••
DetailedKastytis
Top Pro

Cross-Platform

•••
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86)
DetailedKastytis
Top Pro

Follow foreign key to their primary key

•••
If you have a table with a foreign key you can click on it to see the table row where this key references to.
DetailedKastytis
Top Pro

Works for many types of databases

•••
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source
Monika
Mark
Top Con

Requires Java

•••
Java is insecure, and adds load that's unecessary.
Monika
Mark
Top Con

Open source

•••
Open Source software DOES NOT mean superior, or even good. It's a feel good (read political) argument that has no merit, and basis in reality.
See 5 more ProsSee 8 more Pros & Cons
Ad

11 Other Options Considered

pgAdmin 4

Add Video or Image
Laura Kyle
Andris Pelcbergs
Top Pro

Open source

•••
pgAdmin is open source and actively contributed to.
Ray
WhiteLilac
CT
Top Pro

Dashboard displays useful overview of server activity

•••
The dashboard tab includes server load visualizations and other useful details on database activity, such as connected sessions, database locks, and prepared transactions.
Ray
Top Pro

Can be deployed on a server and accessed remotely from browser

•••
As pgAdmin 4 is a web application, it can be easily deployed on any server and accessed remotely using any web browser.
Ray
Top Pro

UI can be re-organized to user's liking

•••
pgAdmin 4's user interface elements are detachable panels that can be dragged around and re-arranged to be displayed standalone or in the tabbed browser.
Ray
Top Pro

Tabbed views to accomodate different screen/window sizes

•••
The tabbed browser in pgAdmin 4 is excellent for accomodating different screen/window sizes. If you're on a small screen, the tabbed browser can save you screen estate by displaying the different panels in different tabs. If you're on a big screen, you can make full use of your screen esta...
Laura Kyle
Top Pro

Portable version available

•••
There is a portable version of pgAdmin available, pgAdminPortable that allows you to easily move your info between machines.
Ray
Top Con

Resource intensive

•••
pgAdmin4 is a web application. The native binary is a wrapped version of the web app that runs a webserver and web browser, thus it has a high memory footprint and other possible impacts on system resources a native application wouldn't have.
Ray
Top Con

UI is slow

•••
The user interface is slow, especially when interacting with query results. While queries execute fast, the user interface can lag behind — selecting a row from a table, scrolling through data, and performing other UI operations can have some delays.
Yoshiyuki
DynamicPyrrhichos
WhiteLilac
Top Con

UI for Mac is very different from other Mac apps

•••
The file navigation seems homegrown and is very hard to use. It resets you to the root directory every time you open a new file browser. Actively frustrating to use.
Monika
Mark
Top Con

Bloated

•••
900MB installed, and for an unintuitive, and feature-lacking software.
PassionateAtlas
Top Con

Non-native UI

•••
Many "normal" key bindings don't work like in other apps. Scrolling behavior is terrible.
PersonableEcne
Top Con

Lack of a schema - sql option

•••
See 10 more Pros & ConsSee 10 more Pros & Cons

Postico

Add Video or Image
Laura Kyle
Alexander
Top Pro

Native experience and clean user interface

•••
Postico is a native OS X app which is available through Mac App Store. The UI is fast, responsive and integrates seamlessly with the OS.
Endi Sukaj
Alexander
Top Pro

Created by an experienced developer in the field

•••
Postico is the successor of PG Commander, an older Mac Posgres GUI tool which is also widely used. They are both maintained by the same person.
Monika
GregariousZagreus
mcastillon
Top Con

No multiple query tabs in the free trial version

•••
To be fair, multiple windows / tabs IS a feature. It's just part of the paid version.
Yoshiyuki
Monika
Laura Kyle
Top Con

Commercial

•••
Postico is a commercial app, with a one-time fee of $35. There is a free trial available.
See 2 more Pros & ConsSee 2 more Pros & Cons

Navicat for PostgreSQL

Add Video or Image
Laura Kyle
Top Pro

Fast UI

•••
The Navicat UI is extremely quick to respond to requests.
Laura Kyle
Top Pro

Good autocomplete

•••
Navicat offers a strong code completion feature.
Laura Kyle
Alison Stanton
Top Pro

Saves queries by name

•••
Deryk Wenaus
Top Pro

Very stable

•••
Laura Kyle
Top Con

Expensive

•••
Navicat is quite expensive at $149 for the standard edition, and $199 for enterprise.
See 3 more ProsSee 3 more Pros

SEQUEL for PostgreSQL

Add Video or Image
Danail
Top Pro

Very powerful and extended autocomplete.

•••
Laura Kyle
ivailon
Top Pro

Customisable interface, feature rich SQL Editor with syntax highlight and autocomplete

•••
Monika
Prokofyev Stanislav
Top Pro

Thought-out object editors

•••
There is no need to jump around tabs, etc. Everything is always available on the same page.
Prokofyev Stanislav
Top Pro

Great GUI layout for small screens

•••
Perfectly fits on a Macbook Pro 13's screen. Very comfortable to work with.
Endi Sukaj
ivailon
Top Pro

Provides detailed control over every database element

•••
Every database element has it's own management form, providing all available settings and parameters modification.
Laura Kyle
Iliya Stankov
Top Pro

Easy update table data from custom query

•••
Easy to edit sql query result data and push back to database.
Monika
TrustingTalos
Top Con

No trial version

•••
ivailon
Top Con

Closed source

•••
See 6 more Pros & ConsSee 6 more Pros & Cons

TablePlus

Add Video or Image
Monika
Huy Phạm
Top Pro

Native Mac application

•••
TablePlus is a native Mac application that helps you edit relational database easily.
Paolo
tungtono
Top Pro

Connects fast

•••
tungtono
Top Pro

Lean app, small size

•••
tungtono
Top Pro

Nice UI

•••
tungtono
Top Pro

One app for all databases

•••
tungtono
Top Pro

Easy to use

•••
Dmitry ZZZ
Top Pro

Native, beautiful and friendly

•••
TablePlus is a native app which helps you easily edit database data and structure.
Paolo
Han Ngo
Top Pro

Shortcut support & seamless navigation

•••
Paolo
tungtono
Top Con

Currently doesn't support Oracle

•••
See 7 more ProsSee 7 more Pros

SQLPro for Postgres

Add Video or Image
Laura Kyle
Kyle Hankinson
Top Pro

Easy to use interface with advanced features

•••
Know any negative aspects of this option?

PSequel : PostgreSQL GUI tool for Mac OS X

Add Video or Image
Nitin
Top Pro

Fast, native UI

•••
The UI is clean, simple and elegant
Laura Kyle
Nitin
Top Pro

Free

•••
PSequel is currently free to use.
Endi Sukaj
Boyd Hemphill
Top Con

No way to save files

•••
You cannot save a file. Makes it way to easy to lose work.
Laura Kyle
Nitin
Top Con

Closed source

•••
PSequel is currently closed source and the developer has stated there is no plans to open source it in the near future.
See 2 more Pros & ConsSee 2 more Pros & Cons

Datazenit

Add Video or Image
Lauris Dziļums
Top Pro

Lightweight interface

•••
Lauris Dziļums
Top Pro

Database content editor

•••
Support for adaptive editors.
Lauris Dziļums
Top Pro

Cross-platform

•••
Lauris Dziļums
Top Pro

Query builder

•••
Know any negative aspects of this option?
See 3 more ProsSee 3 more Pros

Valentina Studio

Add Video or Image
Lynn Fredricks
Top Pro

Cross Platform

•••
Available for Windows, Linux and Mac OS X
Lynn Fredricks
Top Pro

All Databases Supported in Free Version

•••
All databases are supported in a single version, so you don't have to pay for individual DB support.
Lynn Fredricks
Laura Kyle
Matteo Ronchi
Top Pro

Free Version is Feature Packed

•••
Many features in the free version are only available in other paid versions.
Lynn Fredricks
Laura Kyle
Top Pro

Easy to use UI

•••
Many features are understandable without using the docs.
Know any negative aspects of this option?
See 3 more ProsSee 3 more Pros

Postbird

Add Video or Image
Pavel Evstigneyev
Top Pro

Free

•••
Pavel Evstigneyev
Top Pro

Easy to use

•••
Know any negative aspects of this option?
See 1 more ProSee 1 more Pro

PG Commander

Add Video or Image
Laura Kyle
askedrelic
Top Pro

Powerful SQL terminal

•••
PG Commander offers a built-in SQL terminal.
Laura Kyle
askedrelic
Top Pro

Fast, native UI

•••
The UI is clean and simple with a native feel.
Laura Kyle
Top Con

No longer developed

•••
PG Commander is by the same developer who is developing Postico. Therefore PG Commander is no longer being developed, and the developer suggests using Postico instead.
See 1 more ProSee 1 more Pro
Flagged

Induction

See flagged products

180 Community Recommendations

Onze
ivailon
Deryk Wenaus
Ryan Munro
Aryel Tupinambá
Tom Diethe
Javor Nikolov
Peter Carter
gabeio
Michael Howitz
Krasimir Karabenchev
+125
Request recommendations from the community
DetailedKastytis
DetailedKastytis
Contributor for a month
3
Total 
Recs.
135
Total 
Karma
DBeaver
Recommended a month ago
After survey some Free and cross-platform Database Management, I Choose DBeaver instead of pgAdmin4. GUI is not bad, Just a Java Swing Style. Functionality is enough for a developer, SQL Statement autocomplete, Explain, History etc..., but not enough for a database administrator, I can't find performa...
Pro
 Free and open source
Pro
 Works easily out of the box
Pro
 Supports a range of common and less common database types
Pro
 Free
Pro
 Easy to use, clean neat interface
Pro
 Works for many types of databases
Pro
 Follow foreign key to their primary key
Pro
 Cross-Platform
See full
PoliteHannahannah
PoliteHannahannah
Contributor for 2 months
1
Total 
Recs.
0
Total 
Karma
DBeaver
Recommended 2 months ago
Good to start.
See full
Maxim Sobolewski
Maxim
Contributor for 2 years
5
Total 
Recs.
670
Total 
Karma
DataGrip
Recommended 2 months ago
DataGrip's code completion is context-sensitive and schema-aware code completion. It will take into account tables structure, foreign keys, and even database objects created in your code.
Pro
 Supports multiple languages
Pro
 Beautiful and customizable UI
Pro
 Version control support
Pro
 Excellent code completion
Pro
 Helps you avoid mistakes
Pro
 Refactoring support
Pro
 Powerful data editor
See full
Nick Handel
Nick
Contributor for a month
1
Total 
Recs.
150
Total 
Karma
TablePlus
Recommended a month ago
Very very fast, very nice UI that apes Safari. Apple-return to execute queries (on a Mac I find F5 or Apple-E rather annoying). If they can work in a bit more admin stuff (users, grants etc.) without cluttering it it will be awesome.
Pro
 Native Mac application
Pro
 One app for all databases
Pro
 Easy to use
Pro
 Lean app, small size
Pro
 Connects fast
Pro
 Native, beautiful and friendly
See full
ChattyPistis
ChattyPistis
Contributor for 19 days
1
Total 
Recs.
0
Total 
Karma
pgAdmin 4
19 days ago
has no ssl connection
See full
DynamicPyrrhichos
DynamicPyrrhichos
Contributor for 2 months
1
Total 
Recs.
160
Total 
Karma
pgAdmin 4
2 months ago
pgAdmin4 is terrible. Nowhere near ready for prime time. It is a pale shadow of the very functional pgAdmin3, and is actively annoying to use. It doesn't help that the user community has been complaining about it's many faults for a couple years, and the dev team seems to be oblivious. Very disappoin...
Con
 UI for Mac is very different from other Mac apps
Con
 Resource intensive
Con
 UI is slow
Con
 Non-native UI
Con
 Bloated
1See full
Prokofyev Stanislav
Prokofyev
Contributor for a month
1
Total 
Recs.
50
Total 
Karma
SEQUEL for PostgreSQL
Recommended a month ago
I've been using SEQUEL for the past year and find it the closest best match to my expectations of a PostgreSQL client.
Pro
 Very powerful and extended autocomplete.
Pro
 Great GUI layout for small screens
Pro
 Thought-out object editors
See full
DetailedKastytis
DetailedKastytis
Contributor for a month
3
Total 
Recs.
135
Total 
Karma
pgAdmin 4
a month ago
GUI is hard to use, performance is slow, and shortcut design is very weird.
See full
Mark
Mark
Contributor for 2 months
4
Total 
Recs.
165
Total 
Karma
pgAdmin 4
2 months ago
Bloated, and lacks usable features that can be found other software. The latest version weighs in at 900MB.
Con
 UI for Mac is very different from other Mac apps
Con
 Resource intensive
Con
 Bloated
See full
tungtono
tungtono
Contributor for 4 months
34
Total 
Recs.
1K
Total 
Karma
TablePlus
Recommended a month ago
It's time saver, small piece of software and very universal
Pro
 Native Mac application
Pro
 One app for all databases
Pro
 Easy to use
Pro
 Nice UI
Pro
 Lean app, small size
Pro
 Connects fast
Con
 Currently doesn't support Oracle
See full
Currently displaying 10 out of 180 total recommendations.
I Recommend...
Help millions of people make better decisions.
Each month, over 1.7 million people use Slant to find the best products and share their knowledge. Pick the tags you’re passionate about to get a personalized feed and begin contributing your knowledge.
undefined