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
Alt+9
⌘+⌥+9
Zoom out (decrease default font size)
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
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.
