DataGrip
A professional tool for unified database operations, revolutionizing database work from SQL creation to execution and analysis
Ctrl+/
Toggle line comment
Toggles line comment on the caret or selected block.
💡 Hint: / = comment character
Ctrl+Shift+/
Toggle block comment
Toggles block comment on/off for the selected block.
💡 Hint: Shift + / = block comment
Ctrl+Shift+U
Toggle case
Toggles the case of the word at the caret or selected block.
💡 Hint: Shift + U = toggle uppercase
Ctrl+F4
Close active console/editor tab
Closes the active console or editor tab.
💡 Hint: F4 = close tab
Ctrl+Enter
Submit changes
Submits changes in the data editor.
💡 Hint: Ctrl + Enter = submit changes
Ctrl+Alt+Z
Revert changes
Reverts changes in the data editor.
💡 Hint: Alt + Z = revert changes
Ctrl+Space
Value completion
Provides completion for values in the data editor.
💡 Hint: Ctrl + Space = value completion
Ctrl+F
Text search
Searches for text within the data editor.
💡 Hint: Ctrl + F = find
F4
Go to related data
Moves to related data.
💡 Hint: F4 = related data
Alt+F7
Go to referencing data
Moves to data referencing the current data.
💡 Hint: Alt + F7 = referencing data
Ctrl+Q
Quick cell/row view
Shows a quick view of a cell or row.
💡 Hint: Ctrl + Q = quick view
Shift+Enter
Maximize cell view
Maximizes the cell view.
💡 Hint: Shift + Enter = maximize
Ctrl+F12
Column list
Shows the list of columns.
💡 Hint: Ctrl + F12 = column list
Shift+Space
Select row
Selects the current row.
💡 Hint: Shift + Space = select row
Ctrl+N
Go to table/procedure, etc.
Goes to table, procedure, etc.
💡 Hint: Ctrl + N = go to object
Ctrl+Alt+Shift+N
Go to any object
Goes to any object in the workspace.
💡 Hint: Ctrl + Alt + Shift + N = any object
Ctrl+Shift+N
Go to file
Opens dialog to navigate to files.
💡 Hint: Ctrl + Shift + N = go to file
Esc
Return focus to editor
Returns focus to the editor.
💡 Hint: Esc = return focus
Ctrl+Shift+E
Show recently edited files
Shows a list of recently edited files.
💡 Hint: Ctrl + Shift + E = recent files
Alt+1
Show database explorer
Shows the database explorer.
💡 Hint: Alt + 1 = database explorer
Ctrl+F12
Show file structure popup
Shows the file structure popup.
💡 Hint: Ctrl + F12 = structure popup
Alt+F1
Show current file or object in any view
Highlights the current file or object in any view.
💡 Hint: Alt + F1 = show current file
Ctrl+E
Show recent locations
Shows a list of recent locations.
💡 Hint: Ctrl + E = recent locations
Ctrl+Alt+Left
Go back
Goes back to the previous view or location.
💡 Hint: Ctrl + Alt + Left = go back
Ctrl+Alt+Right
Go forward
Goes forward to the next view or location.
💡 Hint: Ctrl + Alt + Right = go forward
F4
Jump to table's data
Jumps to the table's data.
💡 Hint: F4 = jump to data
Ctrl+B
Jump to DDL
Jumps to the DDL definition.
💡 Hint: Ctrl + B = jump to DDL
Ctrl+F6
Modify object
Modifies the selected object.
💡 Hint: Ctrl + F6 = modify object
Ctrl+F
Find
Searches for text in the current context.
💡 Hint: Find
Ctrl+R
Replace
Replaces text in the current context.
💡 Hint: Replace
Ctrl+Shift+F
Find in path
Finds text in path.
💡 Hint: Ctrl + Shift + F = find in path
Ctrl+Shift+R
Replace in path
Replaces text in path.
💡 Hint: Ctrl + Shift + R = replace in path
Alt+F7
Find usages
Finds usages of a symbol.
💡 Hint: Alt + F7 = find usages
Ctrl+Alt+F7
Show usages
Shows usages of a symbol.
💡 Hint: Ctrl + Alt + F7 = show usages
Shift → Shift
Search everywhere
Searches everywhere in the IDE.
💡 Hint: Press Shift twice = search everywhere
Ctrl+Shift+A
Find action
Finds any action inside the IDE.
💡 Hint: Ctrl + Shift + A = find action
Ctrl+Enter
Execute statement
Executes the current SQL statement.
💡 Hint: Ctrl + Enter = execute
Ctrl+Alt+G
Generate SQL for object
Generates SQL for the selected object.
💡 Hint: Ctrl + Alt + G = generate SQL
Ctrl+Space
Code completion
Shows code completion.
💡 Hint: Ctrl + Space = code completion
Ctrl+B → Ctrl+Click
Go to declaration
Goes to the declaration of the selected element.
💡 Hint: Ctrl + B / Ctrl+Click = go to declaration
Shift+F6
Rename
Renames the selected element.
💡 Hint: Shift + F6 = rename
Ctrl+E
Recent files/consoles popup
Shows a popup of recent files and consoles.
💡 Hint: Ctrl + E = recent files
Ctrl+Shift+F12
Show only editor
Hides all tool windows and shows only the editor.
💡 Hint: Ctrl + Shift + F12 = show only editor
Ctrl+Alt+Shift+F
Full-text search in database
Performs a full-text search in the database.
💡 Hint: Ctrl + Alt + Shift + F = full-text search
Alt+Insert
Generate code (Tables, functions, procedures)
Generates code for tables, functions, procedures, etc.
💡 Hint: Alt + Insert = generate code
Alt+Enter
Show intention actions and quick-fixes
Shows the intention actions and quick-fixes popup.
💡 Hint: Alt + Enter = intentions/quick-fixes
Ctrl+P
Parameter info
Shows parameter info for method call arguments.
💡 Hint: Ctrl + P = parameter info
Ctrl+P
Column names info
Shows column names info within VALUES clause.
💡 Hint: Ctrl + P = column names info
Ctrl+D
Duplicate
Duplicates the current line or selected block.
💡 Hint: Ctrl + D = duplicate
Ctrl+Y
Delete
Deletes the current line or selected block.
💡 Hint: Ctrl + Y = delete
Ctrl+X
Cut to clipboard
Cuts the current line or selected block to the clipboard.
💡 Hint: Ctrl + X = cut
Ctrl+C
Copy to clipboard
Copies the current line or selected block to the clipboard.
💡 Hint: Ctrl + C = copy
Ctrl+Shift+V
Paste from recent buffers
Pastes content from recent buffers.
💡 Hint: Ctrl + Shift + V = paste
Alt+Shift+Click
Place multicarets
Places multiple carets with Alt+Shift+Click.
💡 Hint: Alt + Shift + Click = place multicarets
Alt+J
Add selection to next occurrence
Adds another caret to the next occurrence.
💡 Hint: Alt + J = add to next
Alt+Shift+J
Remove selection from next occurrence
Removes caret from the next occurrence.
💡 Hint: Alt + Shift + J = remove next
Ctrl+W
Expand selection
Expands the syntax-aware selection.
💡 Hint: Ctrl + W = expand selection
Ctrl+Shift+W
Shrink selection
Shrinks the syntax-aware selection.
💡 Hint: Ctrl + Shift + W = shrink selection
Ctrl+Alt+L
Reformat code
Automatically reformats code.
💡 Hint: Ctrl + Alt + L = reformat code
Ctrl+Shift+J
Join lines
Joins multiple lines into one.
💡 Hint: Ctrl + Shift + J = join lines
Shift+Enter
Start new line
Starts a new line at the current position.
💡 Hint: Shift + Enter = start new line
Ctrl+Q
Quick info lookup
Shows quick information for code elements.
💡 Hint: Ctrl + Q = quick info lookup