Code insight

DataGrip makes your SQL coding as easy and effective as possible. It completes keywords and identifiers, generates SQL, detects probable bugs in your SQL code and suggests the best options to fix them on the fly.

Code completion

Code completion is pretty fast in DataGrip. You get a list of suggestions as you type: our main goal is zero-latency here. Completion is automatic, but you can invoke it at any moment by pressing Ctrl+Space. It is also context-aware, which means that it tries to only suggest the objects and keywords you may need at any particular moment.

Learn more about code completion

Live templates

Use built-in live templates to generate repetitive parts of SQL code, and create custom templates for even greater efficiency. Press Ctrl+J to see all the Live Templates.

Every live template has its own abbreviate — just type it and press Tab to paste the whole part of the code. For example, selw can be used for SELECT * FROM with WHERE


DataGrip detects probable bugs in your SQL code and suggests the best options to fix them on the fly. The IDE will notify you if there are:

  • Unresolved objects: invalid objects in a query;
  • Ambiguous names in a query;
  • Unused parameters in procedure or function;
  • Mismatching number of columns in queries used in set operators;
  • Mismatching number of values in INSERT statement.

Qualify and quote

Try to select several objects and press Alt+EnterQualify object. If some objects are already qualified the others will be qualified to the same level.

Another intention action here: when you use keywords to name a table or column, DataGrip can quote identifiers with reserved symbols in the appropriate SQL dialect.

Expand wildcard

Since using wildcards is not recommended in many cases, DataGrip can expand it to list all columns of the table for you. In the case of conflicts, identifiers will be qualified.

Parameter info

DataGrip can give you information about the names and types of parameters for functions and procedures as well. To see this tooltip press Ctrl+P.

Column names tooltip for INSERT statement

To assist you in inserting valid values, the IDE hints at the name and type of corresponding columns. Invoke it by pressing Ctrl+P.

Column names hints for INSERT statement

Try enabling Settings → Editor → General → Appearance → Show parameter name hints: DataGrip will prompt you with information about the column names in INSERT statements.