

It also has convenience features like auto-indent and shortcuts for comment line etc. There's also a table structure editor for editing columns, types, default values, foreign keys, check constraints etc.įinally, there's a convenient SQL Query Editor with support for query history and syntax highlighting. You can quickly filter tables by keywords or even complex SQL expressions. Postico has a powerful table content editor with in-cell editing and form-based row editing in a sidebar.

It supports encrypted connections via SSL and SSH to PostgreSQL 8.0 and later, including Amazon Redshift. Postico is a fully native Mac app for connecting to your PostgreSQL server. A free "demo" version of an inexpensive proprietary app, but it has very reasonable limits ("only one tab") and no time limit. With plugin system, you can be able to write your own new features to work with database per your needs (export charts, pretty json…).Ī nice native client by the developers of Postgres.app.


