Direct editing in the results view, query results explanation.Syntax highlight, autocomplete, current and selection query execution and explain, line numbering and working statement detection.Taskbar with multi-task monitoring support.Jump bar for quick objects selection and navigation.Assistant info views for Object information, Actions, Help, and Documentation.Database management forms for Schema, Table, Index, Foreign key, Trigger, Rule, Sequence, Collation, Domain, Enum type, Tablespace and Language objects with full parameters support.

For those who cannot live without a CLI, SEQUEL offers a powerful Query Editor with syntax highlight, autocomplete and a Console log view that is always visible, so you can monitor the communication with your databases. SEQUEL is lightweight, fast and powerful that it can significantly simplify the DB management process. SEQUEL for PostgreSQL is a professional DB administration and management tool, with extremely intuitive and feature-rich GUI that makes it the best assistant tool for developers and admins. 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.

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.6 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.

Postico table