Postgres.app

The easiest way to get started with PostgreSQL on the Mac

GUI Client Apps

There are many clients for PostgreSQL on the Mac. You can find many of them in the Community Guide to PostgreSQL GUI Tools in the PostgreSQL wiki. Some of them are quite powerful; some are still a bit rough. Here’s a list of all the Mac Apps I found (in alphabetic order):

The default connection parameters are described here. If you need to provide an URL, use postgresql://YOURUSERNAME@localhost/YOURUSERNAME