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.

Powerful SQL editor with full features: auto syntax highlight, auto-suggestion, split pane, favorite and history.

Workspace supports multiple tabs, multiple windows.

Custom theme support allowing developers to work with style.Ī modern, native tool with an elegant UI that allows you to simultaneously manage multiple databases, including PostgreSQL.

Primary key detection for inline result set modifications.

History feature, displaying your last ten executed queries.

Support for multiple result set execution.

Query editor with syntax highlighting and autocomplete.

100% native OS X app with a clean and simple to use interface.

Some of these have a 'free' tier (typically somewhat crippled).

3.2.5 JetBrains IDEs - DataGrip, IntelliJ IDEA, PHPStorm, P圜harm, RubyMine, etc.

2.2.5 EMS SQL Manager for PostgreSQL Freeware.

1.1 Open Source and Completely Free Software.

Toad sql server portable