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

Database tree view

— Ability to group data sources

— More convenient managing schemas

— Users and roles are now displayed in PostgreSQL and AWS Redshift

— Foreign data wrappers are now displayed in PostgreSQL

— Drag-and-drop multiple objects to the editor

SQL coding

— SQL generator

— Better JOIN statement completion

— PostgreSQL 10 grammar support

Executing queries

— Ability to choose a schema when running an SQL file

— The list of data sources/consoles is available when attaching the console to a file

— Three independent Execute actions

— Foreign data wrappers are now displayed in PostgreSQL

— Set Current Schema action

Connectivity

— OpenSSH config files are supported (~/.ssh/config и /etc/ssh/ssh_config)

— Dialog added for One Time Password

— Ability to use SSH-agent and Pageant for authentication

— Exasol support

Data editor

— Paste data in a DSV format (i.e. from Excel)

— Numerical data are now right-aligned by default

— Tabs are restored after re-opening DataGrip

— Cells can be compared

Navigation

— Navigate references to DDL editor options

— Jump to Console in the context menu of the data source

— Replace the selected occurrences in the Replace In Path dialog

— Scratches and Consoles are now placed in Files

Your DataGrip Team

*JetBrains

The Drive to Develop*