DataGrip, our IDE for SQL and databases, has reached a new version. New features and improvements:

Amazon Redshift and Microsoft Azure support

Dedicated drivers, Incremental introspection, support for Redshift functions which are absent in PostgreSQL
and for specific grammar cases.

Several databases in one PostgreSQL data source

Evaluate expression

This will help you see data without writing a query to the console.

Transaction Control

This replaced the Auto-commit option. There are two modes of transaction control now: Auto and Manual.
It can also be defined for each query console along with the isolation level.

Table DDL

We have divided the Data and DDL tabs when viewing a table. Actually, there are no more tabs.
Now, when you open a table with a double-click, you just see the data. DDL can be opened by Edit Source on the toolbar.

Integration with restore tools for PostgreSQL and MySQL

Executing queries

Attach console action, notification when a large query is finished, auto-scroll to result-set and vice versa.

Coding assistance

Completion for table-valued functions, NEW and OLD references are resolved in PostgreSQL triggers,
support for MERGE statements, resolve for sequences. Your DataGrip Team

*JetBrains

The Drive to Develop*