DBeaver keyboard shortcuts

DBeaver groups shortcuts by connections, result sets, editors, search, windows, files, and debugging. Focused view and the active key scheme affect which command receives a key.

Windows, macOS, Linux · 114 shortcuts

Connections and SQL scripts

Connection shortcuts open database objects, consoles, scripts, and session actions.

ActionWindowsmacOSLinux
Open the object editorF4F4F4
Open the Connect to a database windowCtrlShiftNCtrlShiftNCtrlShiftN
Open the database meta-objectCtrlShiftDCtrlShiftDCtrlShiftD
Open a new SQL consoleNo script file is created.CtrlAltEnterCtrlOptionReturnCtrlAltEnter
Create a new SQL scriptCtrl]Ctrl]Ctrl]
Open an existing SQL scriptF3F3F3
Open the most recent SQL scriptCtrlEnterCmdReturnCtrlEnter
Commit the current sessionCtrlAltShiftKCtrl4CtrlAltShiftK
Show the database tools context menuAlt`CtrlVAlt`
Generate and insert a UUID or GUIDCtrlAltShiftUCtrlOptionShiftUCtrlAltShiftU
Open the database dashboardCtrlAltShiftBCtrlOptionShiftBCtrlAltShiftB
Roll back the current sessionCtrlAltShiftRCtrl8CtrlAltShiftR
Select the active schemaCtrl0Ctrl0Ctrl0
Select the connection for the current editorCtrl9Ctrl9Ctrl9

Result sets

Result-set commands add and edit rows, move through pages, and change result presentation.

ActionWindowsmacOSLinux
Add a new rowAltInsertOptionInsertAltInsert
Copy values from the row aboveCtrlDCtrlDCtrlD
Copy values from the row belowCtrlAltDCtrlOptionDCtrlAltD
Delete the current rowAltDeleteOptionDeleteAltDelete
Duplicate the current rowCtrlAltInsertCtrlOptionInsertCtrlAltInsert
Edit the cell value inlineEnterReturnEnter
Reset the cell to its original valueEscEscEsc
Apply data changesCtrlSCtrlSCtrlS
Focus the filter editor or data editorCtrlAltShiftTCtrlOptionShiftTCtrlAltShiftT
Switch focus to the results viewer or active panelCtrlShift7CtrlShift7CtrlShift7
Switch focus between the Grid view and Value panelCtrlTabCtrlTabCtrlTab
Apply cell changesCtrlAltShiftEnterCtrlOptionShiftReturnCtrlAltShiftEnter
Edit a cell in a separate editorShiftEnterShiftReturnShiftEnter
Fetch all rowsCtrlShift=CtrlShift=CtrlShift=
Fetch the next page of resultsCtrlAltNCtrlOptionNCtrlAltN
Filter by unique attribute valuesCtrlF11CtrlF11CtrlF11
Open the filter context menuF11F11F11
Move to the first rowCtrlAltShiftLeftCtrlOptionShiftLeftCtrlAltShiftLeft
Move to the last rowCtrlAltShiftRightCtrlOptionShiftRightCtrlAltShiftRight
Show foreign keys and referencing tablesCtrlShift1CtrlShift1CtrlShift1
Reject data changesCtrlRCtrlRCtrlR
Set the cell to its default valueCtrlBackspaceCtrlBackspaceCtrlBackspace
Switch result presentationCtrl`Ctrl`Ctrl`
Toggle Grid and Record viewTabTabTab
Toggle result panelsF7F7F7
Cycle result sort orderCtrl2Ctrl2Ctrl2

Data and text editors

Editor shortcuts cover autocomplete, clipboard work, search, quick fixes, line edits, and folding.

ActionWindowsmacOSLinux
Add a row before the current rowShiftAltInsertShiftOptionInsertShiftAltInsert
Duplicate a row before the current rowCtrlShiftAltInsertCtrlShiftOptionInsertCtrlShiftAltInsert
Enable autocompleteCtrlSpaceCtrlSpaceCtrlSpace
Find and replace textCtrlFCmdFCtrlF
Show context informationCtrlShiftSpaceCtrlShiftSpaceCtrlShiftSpace
Show SQL editor context informationCtrlAltSpaceCtrlOptionSpaceCtrlAltSpace
Cut the selectionCtrlXCmdXCtrlX
Copy the selectionCtrlCCmdCCtrlC
Paste from the clipboardCtrlVCmdVCtrlV
Delete the selectionDeleteDeleteDelete
Export a diagramCtrlOCmdOCtrlO
Find the next itemCtrlKCmdKCtrlK
Find the previous itemCtrlShiftKShiftCmdKCtrlShiftK
Start incremental findCtrlJCmdJCtrlJ
Start reverse incremental findCtrlShiftJShiftCmdJCtrlShiftJ
Toggle quick diff informationCtrlShiftQCtrlShiftQCtrlShiftQ
Suggest possible fixesCtrl1Cmd1Ctrl1
Redo the last operationCtrlYShiftCmdZCtrlY
Undo the last operationCtrlZCmdZCtrlZ
Change the selection to lowercaseCtrlShiftYShiftCmdYCtrlShiftY
Change the selection to uppercaseCtrlShiftXShiftCmdXCtrlShiftX
Delete the line at the caretCtrlDCmdDCtrlD
Delete the next wordCtrlDeleteOptionDeleteCtrlDelete
Delete the previous wordCtrlBackspaceOptionBackspaceCtrlBackspace
Duplicate selected lines downwardCtrlAltDownOptionCmdDownCtrlAltDown
Duplicate selected lines upwardCtrlAltUpOptionCmdUpCtrlAltUp
Add a line above the current lineCtrlShiftEnterShiftCmdReturnCtrlShiftEnter
Add a line below the current lineShiftEnterShiftReturnShiftEnter
Go to the end of the lineEndCmdRightEnd
Go to the start of the lineHomeCmdLeftHome
Move selected lines downAltDownCtrlShiftDownAltDown
Move selected lines upAltUpCtrlShiftUpAltUp
Show information at the caretF2F2F2
Go to the end of the textCtrlEndCmdDownCtrlEnd
Go to the beginning of the textCtrlHomeCmdUpCtrlHome
Zoom in textCtrl+Cmd+Ctrl+
Zoom out textCtrl-Cmd-Ctrl-

Search and window navigation

Search and window commands move across workbench actions, editors, views, perspectives, and panels.

ActionWindowsmacOSLinux
Open the Search dialogCtrlHCtrlHCtrlH
Search workspace files for textCtrlAltGOptionCmdGCtrlAltG
Activate the editorF12CmdF12F12
Find actionsCtrl3Cmd3Ctrl3
Maximize or restore the active view or editorCtrlMCtrlMCtrlM
Switch to the next editorCtrlF6CmdF6CtrlF6
Switch to the next perspectiveCtrlF8CmdF8CtrlF8
Switch to the next viewCtrlF7CmdF7CtrlF7
Switch to the previous editorCtrlShiftF6ShiftCmdF6CtrlShiftF6
Switch to the previous perspectiveCtrlShiftF8ShiftCmdF8CtrlShiftF8
Switch to the previous viewCtrlShiftF7ShiftCmdF7CtrlShiftF7
Open the editor drop-down listCtrlECmdECtrlE
Show the context menuShiftF10ShiftF10ShiftF10
Show the key assist dialogCtrlShiftLShiftCmdLCtrlShiftL
Show the ruler context menuCtrlF10CmdF10CtrlF10
Toggle full-screen modeAltF11CtrlCmdFAltF11

Files, projects, and run controls

File and project bindings create, save, rename, print, build, run, and debug workspace content.

ActionWindowsmacOSLinux
Rename the selected itemF2F2F2
Refresh selected itemsF5F5F5
Save the current fileCtrlSCmdSCtrlS
Save all open filesCtrlShiftSShiftCmdSCtrlShiftS
Close the active editorCtrlF4CmdWCtrlF4
Close all editorsCtrlShiftF4ShiftCmdWCtrlShiftF4
Open the New item wizardCtrlNCmdNCtrlN
Open the New menuAltShiftNOptionCmdNAltShiftN
Open a fileCtrlOCtrlOCtrlO
PrintCtrlPCmdPCtrlP
Display selected item propertiesAltEnterCmdIAltEnter
Launch in debug modeF11CmdF11F11
Launch in run modeCtrlF11ShiftCmdF11CtrlF11
Step into while debuggingF5F5F5
Step over while debuggingF6F6F6
Step return while debuggingF7F7F7
Resume while debuggingF8F8F8
Terminate the debug sessionCtrlF2CmdF2CtrlF2
Create or remove a breakpointCtrlShiftBShiftCmdBCtrlShiftB
Build all projectsCtrlBCmdBCtrlB
Open the documentationF1F1F1

Make a printable DBeaver sheet