Ask HN: Best native postgres client for Mac

by stevepike on 9/13/2016, 5:51 PM with 5 comments

I'm pretty happy with metabase (https://github.com/metabase/metabase) for sharing SQL queries across my team, but their SQL IDE leaves something to be desired.

What's the best native postgres client for Mac for writing SQL queries?

Things I care about:

* Native keybindings / feel

* "Smart" autocomplete (knows what columns are in scope)

* Easy to use for non-engineers (so should be GUI)

Don't care:

* DBA tools

* GUI query builder

  • by craigkerstiens on 9/13/2016, 6:07 PM

    I'd echo psql, it can be quite powerful if you learn to use it (http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Pos...).

    But if you're looking for a graphical client then Postico. It's by the maintainer of Postgres.app, so in a sense if you're using Postico you're helping to support Postgres.app as well.

  • by zepolen on 9/13/2016, 6:02 PM

    I use psql most of the time...it's autocomplete features are scope aware, only problem is editing large queries - so I copy/paste from a text editor (which has syntax highlighting as well).

  • by sotojuan on 9/13/2016, 5:55 PM

    Postico, but it costs money.