DBeaver Documentation

Shortcuts

Brief list of the most important DBeaver shortcuts.
Of course you can redefine any (or almost any) of these shortcuts, here is the list of the default values.
Most of the following commands are accessible from DBeaver main menu, context menu or editor toolbar (or from all of them).
Use context menu wherever it is possible - it usually shows all actions accessible at this moment.

SQL Editor

ShortcutAction
CTRL+EnterExecute current query (*)
CTRL+\Execute current query in a new tab
ALT+XExecute current script (**)
CTRL+ALT+'Execute selected SQL expression and print results
CTRL+SHIFT+EExplain current query execution plan
CTRL+ALT+SHIFT+XExecute queries of current script simultaneously, showing results in separate tabs
CTRL+9Switch active connection (for SQL script)
CTRL+Space Option+SpaceSQL completion proposals popup
CTRL+ALT+SpaceSQL templates proposals popup
CTRL+SHIFT+FFormat current script (**) using current formatter
CTRL+/ CTRL+SHIFT+/Toggle single/multi line comment
ALT+Up ALT+DownJump to previous/next query
CTRL+6 CTRL+SHIFT+6 ALT+6Toggle editor/results panels (maximize/minimize/switch)
CTRL+SHIFT+X CTRL+SHIFT+YConvert selected text into upper/lower case

Data viewer

ShortcutAction
TABSwitch to record/grid mode
CTRL+~Switch presentation (grid, plain text, json ,etc)
CTRL+1Foreign keys navigation menu
ALT+SpaceNavigate to the link in active cell
ALT+LeftNavigate backward in history
ALT+RightNavigate forward in history
CTRL+2Toggle sorting by current column
F11Current column filters menu
CTRL+F11Current column filter dictionary panel
F7 CTRL+7Toggle right panels on/off
F5Refresh results (re-run query)

Data editor

ShortcutAction
EnterActivate inline editor
SHIFT+EnterOpen value editor dialog or separate value editor (for LOB values)
Delete ALT+DeleteDelete row
ALT+InsertAdd new row
CTRL+ALT+InsertCopy current row
EscapeCancel changes in current cell/row

Database Navigator

ShortcutAction
F2Rename current element (if supported)
F4Open editor of selected element(s)
F5Refresh selected element(s)
DeleteDelete selected element(s) (if supported)
CTRL+ALT+SHIFT+DAdd bookmark on selected element
Alt+EnterShow properties of selected element
F3 CTRL+[Open SQL editor for current connection (***). Shows script selector popup.
CTRL+F3 CTRL+]Open new SQL editor for current connection (***). Always creates new script.
CTRL+EnterOpen recent SQL editor for current connection (***). Opens last modified script or creates a new script.

Other

ShortcutAction
ALT+~Shows database tools context menu
CTRL+0Switch active schema/catalog (available if SQL/database editor is open)
CTRL+SHIFT+CAdvanced copy. Works in different contexts and performs "smart copy" operation (usually with parameters).
CTRL+SHIFT+VAdvanced paste. Same as "smart copy" but for "paste".

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 current connection is the same as in this editor. If active window is database navigator then active connection is "owner" connection of currently selected element. In other cases there is no current connection and DBeaver will ask you to choose connection explicitly.