I thing it all depends on use case. I think pgAdmin3 is a good tool for management end exploding the database/s but I DO NOT like if for sql development. The fact that it open the query editor in a new window and does not have a project/file tree explorer sucks. For more it does not have a proper support on HiDpi screens. (I did not try the just released version) I'm using dbeaver and so far it is the best I could find for sql development which comes as open source.
#1 - MySQL Workbench Pros: Intuitive and very easy to use user interface. Free to download, licensed under GPL. Cross platform - versions available for Windows, Linux and Mac OS. Visual schema and query builder. This is the only SQL client which is supported and developed by My. Psequel is a PostgreSQL GUI tool for macOS. In the good old MySQL world, my favorite client is Sequel Pro, but its support for PostgreSQL doesn't seem to be.
For more it seams like the upcoming version (3.6) will be even better for postgresql users. I'm using it a an extension of eclipse as it has a much better HiDpi support then the stand alone. When editing a function in DataGrip that was originally stored with a return type of TABLE the DDL code that is displayed alters the function to return a SETOF instead. (This is an open bug) The second issue was 'losing' part of a foreign key relationship.
(Missing from the object browser, not showing in the database diagram, GUI keeps blanking out the reference table.) The key is enforced, and shows up fine in pgAdmin III and Navicat. Haven't had time to dig into it more / fill out a bug report. If I hit those issues in the short trial period, what other bugs are lurking?
![Gui Gui](http://www.dodownload.com/image/free-navicat-postgresql-lite-mac-os-x-1-postgresql-gui-tool-for-mac-os-x-compatible-for-leopard.png)
It's got a much, much nicer UX than Navicat but just not worth the risk at this point. I'll wait til it's matured more.