Desktop client
Shortcuts
Here is a complete list of default hotkeys in Team Edition UI for Windows, Linux, and macOS users. It will help you work in
Team Edition faster and more efficiently. Remember that you can always change the keyboard shortcut in the Team Edition settings.
Go through: Window -> Preferences -> User Interface -> Keys . Select command and add a keyboard shortcut to the Binding
row .
If you mostly use keyboard, to get more shortcuts you can switch default key scheme to DBeaver Keyboard Only key
scheme in Window -> Preferences -> User Interface -> Keys settings.
Connection
Shortcut for Windows/Linux
Shortcut for macOS
Action
F4
F4
Open object editor
Ctrl+Shift+N
Ctrl+Shift+N
Open Connect to a database window
Ctrl+Shift+D
āā§D
Open database meta-object
Ctrl+Alt+Enter
āā„ā©
Open a new SQL console. No script file will be created.
Ctrl+]
ā]
Create a new SQL script
F3
F3
Open existing SQL script
Ctrl+Enter
āā©
Open most recent SQL script for an active connection
Ctrl+Alt+Shift+K
ā4
Commit changes in current session
Alt+`
āV
Shows context menu with database tools
Ctrl+Alt+Shift+U
āā„ā§U
Generates UUID/GUID and inserts into an active text editor or data editor
Ctrl+Alt+Shift+B
āā„ā§B
Open database dashboard
Ctrl+Alt+Shift+R
ā8
Rollback changes in current session
Ctrl+0
ā0
Select active schema for current database
Ctrl+9
ā9
Select connection for current editor
Alt+Shift+Down/Up
Alt+ā„+Down/Up
Switch vertical tabs
Result Set
Shortcut for Windows/Linux
Shortcut for macOS
Action
Alt+Insert
ā„Insert
Add new row
Ctrl+D
āD
Copy values from row above to current row
Ctrl+Alt+D
āā„D
Copy values from row below to current row
Alt+Delete
ā„ā¦
Delete current row
Ctrl+Alt+Insert
āā„Insert
Duplicate current row
Enter
ā©
Edit cell value with inline editor
Esc
Esc
Reset cell to original value
Ctrl+S
āS
Apply data changes
Ctrl+Alt+Shift+T
āā„ā§T
Set focus to filter editor/data editor
Ctrl+Shift+7
āā§7
Switch focus to results viewer/active panel
Ctrl+Tab
Ctrl+Tab
Switch focus between the Grid view and the Value panel
Ctrl+Alt+Shift+Enter
āā„ā§ā©
Apply cell changes
Shift+Enter
ā§ā©
Edit cell value in separate dialog/editor
Ctrl+Shift+=
āā§=
Fetch all rows
Ctrl+Alt+N
āā„N
Fetch next page of results
Ctrl+F11
āF11
Filter by unique attribute values
F11
F11
Filter context menu
Ctrl+Alt+Shift+Left
āā„ā§ā
Move to first row
Ctrl+Alt+Shift+Right
āā„ā§ā
Move to last row
Alt+Space
ā„Space
Follow foreign key link
Ctrl+Alt+Right
āā„ā
Move to next row
Ctrl+Alt+Left
āā„ā
Move to previous row
Ctrl+Shift+1
āā§1
Foreign keys and tables referencing current table
Ctrl+R
āR
Reject data changes
Ctrl+Backspace
āā«
Set cell to default value
Ctrl+`
ā`
Switch results presentation
Tab
Tab
Toggle results Grid/Record view
F7
F7
Toggle extra result panels
Ctrl+2
ā2
Toggle results sort order (ascending/descending/default)
Ctrl+Alt+C
Select column(s)
Ctrl+Alt+R
Select row(s)
Shift+F11
Show context menu for column
Ctrl+G
Go to row
Ctrl+Shift+G
Go to column
Ctrl+Alt+9
ā+ā„+9
Zoom out (decrease default font size)
Ctrl+Alt+0
ā+ā„+0
Zoom in (increase default font size)
Result Set (Additional shortcuts for DBeaver Keyboard Only key scheme)
Shortcut for Windows/Linux
Shortcut for macOS
Action
Alt+Shift+Right
Move column(s) right
Alt+Shift+Left
Move column(s) left
Alt+Shift+C
Copy column names
Alt+Shift+H
Hide columns
Alt+Shift+T
Show hidden columns
Alt+Shift+F
Open filters settings
Ctrl+Alt+F6
Show/hide results panel (Calc)
Ctrl+Alt+F5
Show/hide results panel (Grouping)
Ctrl+Alt+F4
Show/hide results panel (Metadata)
Ctrl+Alt+F3
Show/hide results panel (References)
Ctrl+Alt+F2
Show/hide results panel (Value)
Data Editor
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+Space
āSpace
Enable autocomplete
Ctrl+F
āF
Find and replace text
Ctrl+Shift+Space
āā§Space
Show Context Information in DIalogs and Windows
Ctrl+Alt+Space
āā„Space
Show Context Information (SQL Editor Context)
Ctrl+X
āX
Cut the selection to the clipboard
Ctrl+C
āC
Copy the selection to the clipboard
Ctrl+V
āV
Paste from the clipboard
Delete
ā¦
Delete the selection
Ctrl+O
āO
Export Diagram
Ctrl+K
āK
Find next item
Ctrl+Shift+K
ā§āK
Find previous item
Ctrl+J
āJ
Incremental find
Ctrl+Shift+J
ā§āJ
Incremental find reverse
Ctrl+Shift+Q
āā§Q
Toggles quick diff information display on the line number ruler
Ctrl+1
ā1
Suggest possible fixes for a problem
Ctrl+Y
ā§āZ
Redo the last operation
Ctrl+Z
āZ
Undo the last operation
Shift+Delete
ā§ā¦
Remove selected Pictogram Elements
Ctrl+A
āA
Select all
Alt+Shift+A
ā„āA
Toggle block/column selection in the current text editor
Ctrl+Shift+Insert
ā§āInsert
Toggle insert mode
Alt+Shift+Y
ā„āY
Toggle word wrap in the current text editor
Ctrl+F5
āF5
Update selected Pictogram Elements
Alt+/
ā.
Context insensitive completion
Ctrl+Shift+Space
āā§Space
Context insensitive completion (SQL Editor Context)
Text Editor
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+Shift+Y
ā§āY
Changes the selection to lowercase
Ctrl+Shift+X
ā§āX
Changes the selection to uppercase
Ctrl+Numpad_Subtract
āNumpad_Subtract
Collapses the folded region at the current selection
Ctrl+Shift+Numpad_Divide
ā§āNumpad_Divide
Collapses all folded regions
Ctrl+Alt+Down
ā„āā
Duplicates the selected lines and moves the selection to the copy
Ctrl+D
āD
Delete a line of text
Ctrl+Delete
ā„ā¦
Delete the next word
Ctrl+Backspace
ā„ā«
Delete the previous word
Ctrl+Shift+Delete
ā§āā¦
Delete to the end of the line of text
Ctrl+Alt+Up
ā„āā
Duplicates the selected lines and leaves the selection unchanged
Ctrl+Numpad_Add
āNumpad_Add
Expands the folded region at the current selection
Ctrl+Numpad_Multiply
āNumpad_Multiply
Expands all folded regions
Ctrl+Shift+Enter
ā§āā©
Adds a new line above the current line
Shift+Enter
ā§ā©
Adds a new line below the current line
Ctrl+Alt+J
Join lines of text (Editing Text)
Ctrl+Shift+J
āā§J
Join lines of text (SQL Editor Context)
End
āā
Go to the end of the line of text
Home
āā
Go to the start of the line of text
Alt+Down
āā§ā
Moves the selected lines down (Editing Text)
Ctrl+Shift+Down
ā„ā
Moves the selected lines down (SQL Editor Context)
Alt+Up
āā§ā
Moves the selected lines up (Editing Text)
Ctrl+Shift+Up
ā„ā
Moves the selected lines up (SQL Editor Context)
Ctrl+Right
ā„ā
Go to the next word
Ctrl+Left
ā„ā
Go to the previous word
Ctrl+Shift+Numpad_Multiply
ā§āNumpad_Multiply
Resets the folding structure
Ctrl+Down
Scroll down one line of text
Ctrl+Up
Scroll up one line of text
Shift+End
ā§āā
Select to the end of the line of text
Shift+Home
ā§āā
Select to the beginning of the line of text
Ctrl+Shift+Right
ā„ā§ā
Select the next word
Ctrl+Shift+Left
ā„ā§ā
Select the previous word
ā§ā
Select to the end of the text
ā§ā
Select to the beginning of the text
F2
F2
Displays information for the current caret location in a focused hover
Ctrl+End
ā
Go to the end of the text
Ctrl+Home
ā
Go to the beginning of the text
Ctrl+Numpad_Divide
āNumpad_Divide
Toggles folding in the current editor
Insert
Insert
Toggle overwrite mode
Ctrl++
ā+
Zoom in text, increase default font size for text editors
Ctrl+=
ā=
Zoom in text, increase default font size for text editors
Ctrl+-
ā-
Zoom out text, decrease default font size for text editors
SQL Editor
Shortcut for Windows/Linux
Shortcut for macOS
Action
Alt+X
ā„X
Execute SQL script
Alt+N
ā„N
Execute SQL script natively
Ctrl+Enter
āā©
Execute SQL statement
Ctrl+
ā
Execute SQL statement in a new tab
Ctrl+Alt+Shift+X
āā„ā§X
Execute script's statements in separate results tabs
Ctrl+/
ā/
Add or remove single line comment
Ctrl+Shift+/
āā§/
Add or remove multi line comment
Ctrl+Alt+T
āā„T
Switch active SQL editor panel
Ctrl+T
āT
Show/hide results panel
Ctrl+Shift+\
āā§\
Close results tab
Ctrl+Shift+F
āā§F
Format text
Ctrl+Alt+'
āā„'
Select value of the selected SQL expression
Ctrl+Shift+E
āā§E
Explain execution plan
Ctrl+Shift+[
āā§[
Jump to the corresponding bracket
Ctrl+Shift+]
āā§]
Select the text between brackets
Ctrl+Alt+Shift+O
āā„ā§O
Load SQL script from file system
Ctrl+Shift+T
āā§T
Maximize/normalize results panel
Alt+Down
ā„ā
Switch to the next query
Alt+Up
ā„ā
Switch to the previous query
Ctrl+F2
āF2
Rename current SQL script
F4
F4
Open editor of current (highlighted) database object
Ctrl+Alt+Shift+A
āā„ā§A
Select and show all rows (no fetch size limit)
Ctrl+Alt+Shift+C
āā„ā§C
Select row count for query under cursor
Ctrl+Shift+.
āā§.
Set active connection from database navigator selection
Ctrl+Shift+O
āā§O
Show server output console
Ctrl+Alt+Shift+W
āā„ā§W
Toggles text editor soft word wrap
Ctrl+Shift+I
āā§I
Switch presentation to (AI Chat)
Diagrams
See Diagrams documentation for a list of shortcuts.
Visual Query Builder
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+B
āB
Open Visual Query Builder
Ctrl+Shift+B
āā§B
Show/hide generated SQL query text
Ctrl+Alt+PageUP/PageDown Ctrl+Shift+PageUP/PageDown
Ctrl+ā„+PageUP/PageDown Ctrl+ā§+PageUP/PageDown
Switch vertical tabs
Alt+1
ā„1
Changes focus to the main tab
Alt+2
ā„2
Changes focus to the palette
Alt+3
ā„3
Changes focus to the outline
Alt+4
ā„4
Changes focus to parameters
Alt+5
ā„5
Switches to Visual Query Builder settings part
Alt+6
ā„6
Switches to query preview
Important
The shortcuts Alt+1 through Alt+6 are only effective in the DBeaver Keyboard Scheme.
Search
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+H
āH
Open the Search dialog
Ctrl+Alt+G
ā„āG
Searches the files in the workspace for specific text
Ctrl+Alt+Shift+F
ā„ā§āL
Quick search in Windows
Data viewer
Shortcut for Windows/Linux
Shortcut for macOS
Action
Tab
Tab
Cycle through hand tool and previously used tool
Ctrl+=
ā=
Zoom In
Ctrl+-
ā-
Zoom Out
Alt+Shift+Q, Q
ā„āQ Q
Shows a particular view
Alt+Shift+Q, B
ā„āQ B
Shows a particular view (Breakpoints)
Alt+Shift+Q, C
ā„āQ C
Shows a particular view (Console)
Alt+Shift+Q, L
ā„āQ L
Shows a particular view (Error Log)
Alt+Shift+Q, Z
ā„āQ Z
Shows a particular view (History)
Alt+Shift+Q, O
ā„āQ O
Shows a particular view (Outline)
Alt+Shift+Q, X
ā„āQ X
Shows a particular view (Problems)
Alt+Shift+Q, S
ā„āQ S
Shows a particular view (Search)
Alt+Shift+Q, Y
ā„āQ Y
Shows a particular view (Synchronize)
Alt+Shift+Q, V
ā„āQ V
Shows a particular view (Variables)
Window
Shortcut for Windows/Linux
Shortcut for macOS
Action
F12
āF12
Activate Editor
āW
Closes the active Dialog
Ctrl+3
ā3
Find actions. Quickly access UI elements
Ctrl+M
āM
Maximize/restore a state of active view or editor
Ctrl+F6
āF6
Switch to the next editor
Ctrl+F8
āF8
Switch to the next perspective
Ctrl+F7
āF7
Switch to the next view
Ctrl+Shift+F6
ā§āF6
Switch to the previous editor
Ctrl+Shift+F8
ā§āF8
Switch to the previous perspective
Ctrl+Shift+F7
ā§āF7
Switch to the previous view
Ctrl+E
āE
Open the editor drop-down list
ā§F10
Show the context menu
Alt+Shift+F3
ā„ā§F3
Shows contribution information for the currently selected element
Ctrl+Shift+L
ā§āL
Show the key assist dialog
Ctrl+F10
āF10
Show the context menu for the ruler
Alt+-
ā§āF10
Show the system menu
Ctrl+F10
āF10
Show the view menu
Ctrl+Shift+E
ā§āE
Switch to an editor
Alt+F11
āāF
Toggles the window between full screen and normal
Ctrl+_
ā§ā-
Split or join the currently active editor (Horizontal)
Ctrl+_
ā§ā[
Split or join the currently active editor (Vertical)
Database Navigator
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+Shift+,
āā§,
Link with editor
Ctrl+Alt+Shift+D
āā„ā§D
Add Bookmark
Enter
ā©
Opens task configuration
Ctrl+Shift+A
āā§A
Set as default object
Properties Entity Editor
Shortcut for Windows/Linux
Shortcut for macOS
Action
Alt+Shift+Up
Alt+Shift+Up
Switch to the next entity property left-side tab
Alt+Shift+Down
Alt+Shift+Down
Switch to the previous entity property left-side tab
Ctrl+Alt+PageUP/PageDown Ctrl+Shift+PageUP/PageDown
Ctrl+ā„+PageUP/PageDown Ctrl+Shift+PageUP/PageDown
Switch vertical tabs
Navigation tree
Shortcut for Windows/Linux
Shortcut for macOS
Action
Alt+Left
ā[
Move backward in the editor navigation history
Ctrl+Shift+Numpad_Divide
ā§āNumpad_Divide
Collapse the current tree
Ctrl+Shift+Numpad_Multiply
ā§āNumpad_Multiply
Expand the current tree
Alt+Right
ā]
Move forward in the editor navigation history
Ctrl+G
āG
Go to a specified line of text in Windows
Ctrl+L
āL
Go to a specified line of text (Editing Text)
Ctrl+.
ā.
Navigate to the next item
Ctrl+Alt+Right
āā„ā
Next edit location
Alt+F7
ā„F7
Switch to the next page
Alt+PageDown
ā„ā
Switch to the next sub-tab
Ctrl+PageDown
āā
Switch to the next tab
Ctrl+Shift+R
ā§āR
Open an editor on a particular item
Ctrl+,
ā§ā.
Navigate to the previous item
Ctrl+Alt+Left
āQ
Previous edit location
Alt+Shift+F7
ā„ā§F7
Switch to the previous page
Alt+PageUp
ā„ā
Switch to the previous sub-tab
Ctrl+PageUp
āā
Switch to the previous tab
Alt+Shift+W
ā„āW
Open the Show In menu
File
Shortcut for Windows/Linux
Shortcut for macOS
Action
F2
F2
Rename the selected item
F5
F5
Refresh the selected items
Ctrl+S
āS
Save the changes in current file
Ctrl+Shift+S
ā§āS
Save changes in all open files
Ctrl+F4
āW
Close the active editor
Ctrl+Shift+F4
ā§āW
Close all editors
Ctrl+N
āN
Open the New item wizard
Alt+Shift+N
ā„āN
Open the New menu
Ctrl+O
āO
Open a file
Ctrl+P
āP
Print
Alt+Enter
āI
Display the properties of the selected item
Run/Debug
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+Alt+M
ā„āM
Add memory block
Ctrl+W
āW
Close the selected rendering
F11
āF11
Launch in debug mode
Ctrl+Z
āD
Send end of file
Ctrl+G
āG
Go to Address
Ctrl+N
āN
Add a new rendering
Ctrl+Alt+N
ā„āN
Show renderings from next memory monitor.
Ctrl+Shift+.
ā§ā.
Load next page of memory
Ctrl+Shift+,
ā§ā,
Load previous page of memory
Ctrl+F11
ā§āF11
Launch in run mode
Ctrl+R
āR
Resume and break when execution reaches the current line
Ctrl+Alt+B
āā„B
Sets whether or not any breakpoint should suspend execution
F5
F5
Step into
F6
F6
Step over
F7
F7
Step return
F8
F8
Resume
Ctrl+F2
āF2
Terminate
Ctrl+Shift+B
ā§āB
Creates or removes a breakpoint
Ctrl+T
āT
Toggle visibility of the Memory Monitors Pane
Shift+F5
ā§F5
Toggles enablement of debug step filters
Git
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+Left
āā
Collapse Working Tree
Ctrl+#
ā„ā3
Commit
Ctrl+C
āC
Copy Path to Clipboard
Ctrl+O
āO
Show the quick outline for a unified diff
F2
F2
Rename Branch
Ctrl+Shift+K
āā§K
Commit changes to Git
Ctrl+Shift+U
āā§U
Update changes from Git
Project
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+B
āB
Build all projects
Oracle
Shortcut for Windows/Linux
Shortcut for macOS
Action
Ctrl+F9
āF9
Compile
Utility
Shortcut for Windows&Linux
Shortcut for macOS
Action
Ctrl+Shift+C
āā§C
Advanced Copy
Ctrl+Shift+V
āā§V
Paste with extra settings
CTRL+ALT+PAGE_UP CTRL+ALT+PAGE_DOWN
Switch between tabs in database object Properties view
Alt+Insert
ā+N
Create Object It is available both in the Database Navigator and the Properties Editor .
Help
Shortcut for Windows&Linux
Shortcut for macOS
Action
F1
F1
Open the documentation
References
*
- Current query is the query under cursor or the selected text. Query is separated from other script queries by delimiter (; by default) or by empty lines.
**
- Current script is a set of all queries in the current SQL file. If there is a text selection then only queries in this selection are processed. Queries are separated from each other with a delimiter (; by default).
***
- Current connection detected from active window and selection. If active (focused) window is SQL editor or database object editor then the current connection is the same as in this editor. If the active window is the database navigator then the active connection is the "owner" connection of the currently selected element. In other cases there is no current connection and Team Edition will ask you to choose the connection explicitly.