Writing SQL

Just as any decent IDE should, 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 which helps you be more productive. Transform and move blocks of code, use multi-cursors to manage selection, format code according to a specific style, and much more. Learn more

Code completion DataGrip provides context-sensitive, schema-aware code completion, helping you to 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 UI. Moreover, it helps you to get DDL for tables and provides DML queries from result-sets. Learn more

Code analysis and quick-fixes DataGrip detects where probable bugs may 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 in which stored procedures, functions and views your tables are used. Learn more