SQL editor shortcuts that accelerate SQL creation, execution, and debugging to maximize database development productivity

Ctrl+Enter

Execute statement

Executes the current SQL statement.

💡 Hint: Ctrl + Enter = execute

🎯 Instantly execute SQL statements to quickly check query results

Ctrl+Space

Code completion

Shows code completion.

💡 Hint: Ctrl + Space = code completion

🎯 Prevent typos and create SQL quickly with table and column name completion

Ctrl+Alt+G

Generate SQL for object

Generates SQL for the selected object.

💡 Hint: Ctrl + Alt + G = generate SQL

🎯 Auto-generate SQL for objects to significantly reduce time for creating complex queries

Alt+Insert

Generate code (Tables, functions, procedures)

Generates code for tables, functions, procedures, etc.

💡 Hint: Alt + Insert = generate code

🎯 Auto-generate definition code for tables and functions to streamline DDL creation work

Alt+Enter

Show intention actions and quick-fixes

Shows the intention actions and quick-fixes popup.

💡 Hint: Alt + Enter = intentions/quick-fixes

🎯 Display SQL improvement suggestions and quick-fixes to enhance code quality

Ctrl+P

Parameter info

Shows parameter info for method call arguments.

💡 Hint: Ctrl + P = parameter info

🎯 Display function parameter information to quickly write accurate function calls

Ctrl+Alt+L

Reformat code

Automatically reformats code.

💡 Hint: Ctrl + Alt + L = reformat code

🎯 Auto-format SQL code to unify into readable and maintainable queries

Ctrl+D

Duplicate

Duplicates the current line or selected block.

💡 Hint: Ctrl + D = duplicate

🎯 Duplicate lines or blocks to significantly reduce time when creating similar SQL statements

Ctrl+W

Expand selection

Expands the syntax-aware selection.

💡 Hint: Ctrl + W = expand selection

🎯 Expand selection along syntax to efficiently select parts of SQL statements

DataGrip