Features

Features

Writing SQL

Just as any decent IDE should do, DataGrip provides smart code completion, code inspections,

on-the-fly error highlighting, quick-fixes, and refactoring capabilities. It saves you time

by making the process of writing SQL code more efficient.

Smart text editor

Just as with any IntelliJ platform IDE, DataGrip includes a code editor that helps you be

more productive. Transform and move blocks of code, use multi-cursors to manage selections,

and much more.

Learn more

Code completion

DataGrip provides context-sensitive, schema-aware code completion, helping you write code

faster. Completion is aware of the tables structure, foreign keys, and even database objects

created in the code you're editing.

Learn more

Code generation

Forget about writing typical code manually: DataGrip will do that for you. It generates code

for changing objects like tables, columns, etc., based on the UI. Moreover, it helps you to

get a DDL for any object and provides DML queries from result-sets and updates.

Learn more

Code analysis and quick-fixes

DataGrip detects where bugs are likely to occur in your SQL code and suggests the best

options to fix them on-the-fly. It will immediately let you know about unresolved objects,

the use of keywords as identifiers, and always offers you a way to fix the problem.

Learn more

Refactoring and finding usages

DataGrip correctly resolves all references in your SQL files. When you're renaming database

objects from SQL, they will also be renamed in the database. You can quickly find out in

which stored procedures, functions and views your tables are used.

Learn more

Code formatter

Since each database developer has their own slightly unique style, the ability to configure

each individual option in the code formatter helps ensure that all their individual needs are met.