What are the best Mac OS X GUIs for PostgreSQL?

Question

15

Options
Considered

238

User
Recs.

Mar 8, 2019

Last
Updated

Here’s the Deal

The Best 2 of 14 OptionsWhy?

Best Mac OS X GUIs for PostgreSQL	Price	Platforms	Last Updated
93 DBeaver	FREE	Windows, Linux, Mac	Mar 7, 2019
91 DataGrip	$ 89/Y	-	Feb 12, 2019
78 pgAdmin 4	Free	-	Dec 20, 2018
68 Postico	$39.99	Mac	Jan 3, 2019
-- SEQUEL for PostgreSQL	59.99	-	Oct 25, 2018

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

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

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

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

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

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

See All

12 Other Options Considered

pgAdmin 4

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

Top Pro

Open source

pgAdmin is open source and actively contributed to. 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 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

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

DetailedKastytis's Experience

GUI is hard to use, performance is slow, and shortcut design is very weird. 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

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

Mark's Experience

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

Top Con

Bloated

900MB installed, and for an unintuitive, and feature-lacking software. 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

ChattyPistis's Experience

has no ssl connection See More

Top Con

Non-native UI

Many "normal" key bindings don't work like in other apps. Scrolling behavior is terrible. 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

Lack of a schema - sql option

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

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

SEQUEL for PostgreSQL

Top Pro

Very powerful and extended autocomplete.

Top Con

No trial version

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

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

Top Con

Closed source

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 Pro

Great GUI layout for small screens

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

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

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

Induction

See flagged products

Request recommendations from the community

I Recommend...

Help millions of people make better decisions.

Each month, over 2.8 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.