Postico is an excellent PostgreSQL client for Mac that supports local and remote cloud services, such as Heroku Postgres, Amazon Redshift, Amazon RDS, etc
Application Description:
PostgreSQL is a powerful database. But there is no reason why the use of it should require an advanced degree of relational theory. Postico offers an easy-to-use interface that makes Postgres easier for novices and experts alike.
Official Introduction
Postico provides an easy to use interface, making Postgres more accessible for newcomers and specialists alike. Postico will look familiar to anyone who has used a Mac before. Just connect to a database and begin working with tables and views. Start with the basics and learn about advanced features of PostgreSQL as you go along. Postico is an intuitive app for looking at data. Filter rows, sort them, rearrange columns. You can examine long text or images conveniently in the sidebar. Even related rows from referenced tables are shown. Edit rows directly, or use the sidebar, a great choice for long text. You can even change multiple rows at once. Batch saving (with SQL preview) lets you commit changes to multiple rows in a single transaction. Postico sports a query view inspired by Sequel Pro, the popular MySQL client. But with sophisticated features like multiple query results, Postico goes even beyond its role model.
Screenshot of the app
Activation method
Direct installation
"The app is corrupted and won't open. You should move it to the Trash", see:The "Mac app" is corrupted and the solution cannot be opened