What are the best Mac OS X GUIs for PostgreSQL?

Question

16

Options
Considered

320

User
Recs.

Dec 4, 2019

Last
Updated

Here’s the Deal

The Best 2 of 14 OptionsWhy?

Best Mac OS X GUIs for PostgreSQL	Price	Platforms	Auto Complete
94 DBeaver	FREE	-	-
90 DataGrip	$ 89/Y	-	-
78 pgAdmin 4	Free	-	-
-- SEQUEL for PostgreSQL	59.99	-	-
-- Navicat for PostgreSQL	-	-	-

See Full List

DataGrip

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. See More

Top Con

Not user friendly

Maxim Sobolewski's Experience

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. See More

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. See More

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. See More

Top Pro

Powerful data editor

A powerful data 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 at once. See More

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 More

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. See More

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. See More

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. See More

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. See More

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. See More

See All

12 Other Options Considered

pgAdmin 4

Top Pro

Open source

pgAdmin is open source and actively contributed to. See More

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. See More

DynamicPyrrhichos's Experience

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 disappointing. See More

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. See More

Top Con

Non-native UI

Many "normal" key bindings don't work like in other apps. Scrolling behavior is terrible. See More

Mark's Experience

Bloated, and lacks usable features that can be found other software. The latest version weighs in at 900MB. See More

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. See More

Top Con

Not Intuitive

Dated and obtuse UI design. See More

DetailedKastytis's Experience

GUI is hard to use, performance is slow, and shortcut design is very weird. See More

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. See More

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. See More

ChattyPistis's Experience

has no ssl connection See More

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 estate by detaching the panels and moving it where you like. See More

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. See More

Paul Kogan's Experience

On mac pgAdmin4 for is SUPER clunky, unresponsive and unintuitive. Only part of this can be blamed for running in-browser. Its hard to run multiple scripts simultaneously, windows dont resize, etc. The king has fallen! See More

Top Pro

Portable version available

There is a portable version of pgAdmin available, pgAdminPortable that allows you to easily move your info between machines. See More

Top Con

Bloated

900MB installed, and for an unintuitive, and feature-lacking software. See More

Top Con

Lack of a schema - sql option

See All

SEQUEL for PostgreSQL

Top Pro

Very powerful and extended autocomplete.

Top Con

No Support documentation

VigilantBodbDerg's Experience

No free trial, won't connect to remote db servers via a passphrase SSH. No refunds allowed via the App Store. See More

Top Pro

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

Top Con

No Passphrase for SSH keys

No ability to add a passphrase for an ssh key, refuses to connect to remote server without it. See More

Prokofyev Stanislav's Experience

I've been using SEQUEL for the past year and find it the closest best match to my expectations of a PostgreSQL client. See More

Top Pro

Thought-out object editors

There is no need to jump around tabs, etc. Everything is always available on the same page. See More

Top Con

No trial version

Top Pro

Great GUI layout for small screens

Perfectly fits on a Macbook Pro 13's screen. Very comfortable to work with. See More

Top Con

Closed source

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. See More

Top Pro

Easy update table data from custom query

Easy to edit sql query result data and push back to database. See More

See All

Postico

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. See More

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. See More

Specs

Platforms:Mac

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. See More

Top Con

Commercial

Postico is a commercial app, with a one-time fee of $35. There is a free trial available. See More

See All

TablePlus

Top Pro

Native Mac application

TablePlus is a native Mac application that helps you edit relational database easily. See More

Top Con

Currently doesn't support Oracle

Nick Handel's Experience

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. See More

Top Pro

Nice UI

Top Pro

One app for all databases

Top Pro

Connects fast

Top Pro

Lean app, small size

Top Pro

Easy to use

Top Pro

Multi-tabs & code review

TablePlus supports multi-tab and multi-window viewing, as well as generates code review whenever you make a change to your database. See More

Top Pro

Native, beautiful and friendly

TablePlus is a native app which helps you easily edit database data and structure. See More

Top Pro

Customizable appearance

TablePlus' smartly designed interface not only gives you powerful functions, but also allows you to personalize your database workspace by changing themes and font sizes. Our shortcut keys also help you work faster and be more efficient. See More

Top Pro

Powerful SQL editor

Equipped with the following features: •Highlight syntax •Indent SQL Command •Split Results into Tabs •Save favorite SQL to snippet •Customize font size See More

Top Pro

Shortcut support & seamless navigation

See All

QueryPie

Top Pro

Free!

Top Con

Still in beta

Melissa's Experience

I use their other product (SQLGate) and enjoy it, so I wanted to check out this one too! I wasn't disappointed! I love their little pie theme and the details in the visuals. It's definitely a pretty IDE, which is refreshing. Because developers care about design too! :P See More

Specs

Platforms:Mac, Windows, Linux

Auto Complete:Fast auto-complete on queries

Database management:PostgreSQL, MariaDB, MySQL, AWS Aurora

Top Pro

Multiple Query Tabs!

The multi-tab and multi-SQL-runs are great. It's always good to be able to compare results in one window instead of having to go through and re-run stuff. See More

Top Con

No visualization

SQLViking's Experience

It's still in beta version so it has its kinks, but it's really really pretty. Response time is pretty quick on query runs and the functions are easy to use/figure out. It works on windows and mac, which is nice. :] And you don't get those nasty random errors that Sequel Pro sneezes everywhere after updating to the latest OS. See More

Top Pro

Fast Auto-complete

Thomas Jang's Experience

it's beautiful UI/UX See More

Top Pro

Multiple Databases

They only support 2 at the moment (MySQL and MariaDB) but their social site says they'll be updating with more DBMSes in the near future which is pretty nice because I hate learning new GUIs~ See More

Geonguk Han's Experience

That's amazing exprience and design! See More

Top Pro

Clean and pretty UI/UX

The default color is dark and comfortable for the eyes. See More

Top Pro

Cross-Platform

Not sure about Linux but it works on Windows and Mac just fine! See More

See All

TeamSQL

Induction

See flagged products

I Recommend...

Built By the Slant team

We find the best product for your budget

Our AI does all the product research work so you don’t have to.

Add to Chrome Try it now

score 71 · Accepted Answer

DBeaver

Top Pro

Free and open source

Top Con

Requires Java

Java is insecure, and adds load that's unecessary. See More

DetailedKastytis's Experience

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 performance overview. The Shortcut is like a general text editor. See More

Top Pro

Works easily out of the box

Setup is simple and program even prompted to create a sample database to help beginners. See More

PoliteHannahannah's Experience

Good to start. See More

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. See More

Top Pro

Free

It it licensed under GPL v2. See More

Top Pro

Easy to use, clean neat interface

Top Pro

Cross-Platform

Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86) See More

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. See More

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 See More

See All

The Best 2 of 14 OptionsWhy?

My Recommendation for DBeaver

My Recommendation for DBeaver

Free and open source

Requires Java

Works easily out of the box

Supports a range of common and less common database types

Free

Easy to use, clean neat interface

Cross-Platform

Follow foreign key to their primary key

Works for many types of databases

My Recommendation for DataGrip

My Recommendation for DataGrip

Supports multiple languages

Not user friendly

Beautiful and customizable UI

Expensive

Powerful data editor

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

Version control support

Helps you avoid mistakes

Refactoring support

Much more powerful than its counterparts

Excellent code completion

12 Other Options Considered

My Recommendation for pgAdmin 4

My Recommendation for pgAdmin 4

Open source

UI is slow

Dashboard displays useful overview of server activity

Non-native UI

Can be deployed on a server and accessed remotely from browser

Not Intuitive

UI can be re-organized to user's liking

Resource intensive

Tabbed views to accomodate different screen/window sizes

UI for Mac is very different from other Mac apps

Portable version available

Bloated

Lack of a schema - sql option

My Recommendation for SEQUEL for PostgreSQL

My Recommendation for SEQUEL for PostgreSQL

Very powerful and extended autocomplete.

No Support documentation

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

No Passphrase for SSH keys

Thought-out object editors

No trial version

Great GUI layout for small screens

Closed source

Provides detailed control over every database element

Easy update table data from custom query

My Recommendation for Navicat for PostgreSQL

My Recommendation for Navicat for PostgreSQL

Expensive

Fast UI

Good autocomplete

Saves queries by name

Very stable

My Recommendation for Postico

My Recommendation for Postico

Native experience and clean user interface

No multiple query tabs in the free trial version

Created by an experienced developer in the field

Commercial

My Recommendation for TablePlus

My Recommendation for TablePlus

Native Mac application

Currently doesn't support Oracle

Nice UI

One app for all databases

Connects fast

Lean app, small size

Easy to use

Multi-tabs & code review

Native, beautiful and friendly

Customizable appearance

Powerful SQL editor

Shortcut support & seamless navigation