DBeaver Documentation

DOWNLOAD

Shortcuts

Here is a complete list of default hotkeys in DBeaver UI for Windows, Linux, and macOS users. It will help you work in DBeaver faster and more efficiently. Remember that you can always change the keyboard shortcut in the DBeaver settings. Go through: Window - Preferences - User Interface - Keys. Select command and add a keyboard shortcut to the Binding row.

Connection

Shortcut for Windows/LinuxShortcut for macOSAction
F4F4Open object editor
Ctrl+Shift+D⌃⇧DOpen database meta-object
Ctrl+Alt+Enter⌃⌥↩Open a new SQL console. No script file will be created.
Ctrl+]⌃]Create a new SQL script(***)
F3F3Open existing SQL script (***)
Ctrl+Enter⌃↩Open most recent SQL script(***) for an active connection
Ctrl+Alt+Shift+K⌃4Commit changes in current session
Alt+`⌃VShows context menu with database tools
Ctrl+Alt+Shift+U⌃⌥⇧UGenerates UUID/GUID and inserts into an active text editor or data editor
Ctrl+Alt+Shift+B⌃⌥⇧BOpen database dashboard
Ctrl+Alt+Shift+R⌃8Rollback changes in current session
Ctrl+0⌃0Select active schema for current database
Ctrl+9⌃9Select connection for current editor

Result Set

Shortcut for Windows/LinuxShortcut for macOSAction
Alt+Insert⌥InsertAdd new row
Ctrl+D⌃DCopy values from row above to current row
Ctrl+Alt+D⌃⌥DCopy values from row below to current row
Alt+Delete⌥⌦Delete current row
Ctrl+Alt+Insert⌃⌥InsertDuplicate current row
EnterEdit cell value with inline editor
EscEscReset cell to original value
Ctrl+S⌃SApply data changes
Ctrl+Alt+Shift+T⌃⌥⇧TSet focus to filter editor/data editor
Ctrl+Shift+7⌃⇧7Switch focus to results viewer/active panel
Ctrl+Alt+Shift+Enter⌃⌥⇧↩Apply cell changes
Shift+Enter⇧↩Edit cell value in separate dialog/editor
Ctrl+Shift+=⌃⇧=Fetch all rows
Ctrl+Alt+;⌃⌥;Fetch next page of results
Ctrl+F11⌃F11Filter by unique attribute values
F11F11Filter context menu
Ctrl+Alt+Shift+Left⌃⌥⇧←Move to first row
Ctrl+Alt+Shift+Right⌃⌥⇧→Move to last row
Alt+Space⌥SpaceFollow foreign key link
Ctrl+Alt+Right⌃⌥→Move to next row
Ctrl+Alt+Left⌃⌥←Move to previous row
Ctrl+1⌃1Foreign keys and tables referencing current table
Ctrl+R⌃RReject data changes
Ctrl+Backspace⌃⌫Set cell to default value
Ctrl+`⌃`Switch results presentation
TabTabToggle results Grid/Record view
F7F7Toggle extra result panels
Ctrl+2⌃2Toggle results sort order (ascending/descending/default)

Data Editor

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+Space⌃SpaceEnable autocomplete
Ctrl+F⌘FFind and replace text
Ctrl+Shift+Space⌃⇧SpaceShow Context Information in DIalogs and Windows
Ctrl+Alt+Space⌃⌥SpaceShow Context Information (SQL Editor Context)
Ctrl+X⌘XCut the selection to the clipboard
Ctrl+C⌘CCopy the selection to the clipboard
Ctrl+V⌘VPaste from the clipboard
DeleteDelete the selection
Ctrl+O⌘OExport Diagram
Ctrl+K⌘KFind next item
Ctrl+Shift+K⇧⌘KFind previous item
Ctrl+J⌘JIncremental find
Ctrl+Shift+J⇧⌘JIncremental find reverse
Ctrl+Shift+Q⌃⇧QToggles quick diff information display on the line number ruler
Ctrl+1⌘1Suggest possible fixes for a problem
Ctrl+Y⇧⌘ZRedo the last operation
Ctrl+Z⌘ZUndo the last operation
Shift+Delete⇧⌦Remove selected Pictogram Elements
Ctrl+A⌘ASelect all
Alt+Shift+A⌥⌘AToggle block/column selection in the current text editor
Ctrl+Shift+Insert⇧⌘InsertToggle insert mode
Alt+Shift+Y⌥⌘YToggle word wrap in the current text editor
Ctrl+F5⌘F5Update selected Pictogram Elements
Alt+/⌃.Context insensitive completion
Ctrl+Shift+Space⌃⇧SpaceContext insensitive completion (SQL Editor Context)

Text Editor

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+Shift+Y⇧⌘YChanges the selection to lowercase
Ctrl+Shift+X⇧⌘XChanges the selection to uppercase
Ctrl+Numpad_Subtract⌘Numpad_SubtractCollapses the folded region at the current selection
Ctrl+Shift+Numpad_Divide⇧⌘Numpad_DivideCollapses all folded regions
Ctrl+Alt+Down⌥⌘↓Duplicates the selected lines and moves the selection to the copy
Ctrl+D⌘DDelete 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_AddExpands the folded region at the current selection
Ctrl+Numpad_Multiply⌘Numpad_MultiplyExpands 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+JJoin lines of text (Editing Text)
Ctrl+Shift+J⌃⇧JJoin 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_MultiplyResets the folding structure
Ctrl+DownScroll down one line of text
Ctrl+UpScroll 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
F2F2Displays information for the current caret location in a focused hover
Ctrl+EndGo to the end of the text
Ctrl+HomeGo to the beginning of the text
Ctrl+Numpad_Divide⌘Numpad_DivideToggles folding in the current editor
InsertInsertToggle 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/LinuxShortcut for macOSAction
Alt+X⌥XExecute script(**)
Ctrl+Enter⌃↩Execute SQL statement(*)
Ctrl+Execute SQL statement in a new tab
Ctrl+Alt+Shift+X⌃⌥⇧XExecute script's statements in separate results tabs
Ctrl+/⌃/Add or remove single line comment
Ctrl+Shift+/⌃⇧/Add or remove multi line comment
Alt+6⌥6Switch active SQL editor panel
Ctrl+6⌃6Show/hide results panel
Ctrl+Shift+⌃⇧Close results tab
Ctrl+Shift+F⌃⇧FFormat text
Ctrl+Alt+'⌃⌥'Select value of the selected SQL expression
Ctrl+Shift+E⌃⇧EExplain execution plan
Ctrl+Shift+P⌃⇧PPosition cursor on the matching bracket
Ctrl+Alt+Shift+O⌃⌥⇧OLoad SQL script from file system
Ctrl+Shift+6⌃⇧6Maximize/normalize results panel
Alt+Down⌥↓Switch to the next query
Alt+Up⌥↑Switch to the previous query
Ctrl+F2⌃F2Rename current SQL script
F4F4Open editor of current (highlighted) database object
Ctrl+Alt+Shift+A⌃⌥⇧ASelect and show all rows (no fetch size limit)
Ctrl+Alt+Shift+C⌃⌥⇧CSelect row count for query under cursor
Ctrl+Shift+.⌃⇧.Set active connection from database navigator selection
Ctrl+Shift+O⌃⇧OShow server output console
Ctrl+Alt+Shift+W⌃⌥⇧WToggles text editor soft word wrap

Visual Query Builder

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+B⌃BOpen Visual Query Builder
Ctrl+Shift+B⌃⇧BShow/hide generated SQL query text

Search

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+H⌃HOpen the Search dialog
Ctrl+Alt+G⌥⌘GSearches the files in the workspace for specific text
Ctrl+Alt+Shift+F⌥⇧⌘LQuick search in Windows

Data viewer

Shortcut for Windows/LinuxShortcut for macOSAction
TabTabCycle through hand tool and previously used tool
Ctrl+=⌘=Zoom In
Ctrl+-⌘-Zoom Out
Alt+Shift+Q, Q⌥⌘Q QShows a particular view
Alt+Shift+Q, B⌥⌘Q BShows a particular view (Breakpoints)
Alt+Shift+Q, C⌥⌘Q CShows a particular view (Console)
Alt+Shift+Q, L⌥⌘Q LShows a particular view (Error Log)
Alt+Shift+Q, Z⌥⌘Q ZShows a particular view (History)
Alt+Shift+Q, O⌥⌘Q OShows a particular view (Outline)
Alt+Shift+Q, X⌥⌘Q XShows a particular view (Problems)
Alt+Shift+Q, S⌥⌘Q SShows a particular view (Search)
Alt+Shift+Q, Y⌥⌘Q YShows a particular view (Synchronize)
Alt+Shift+Q, V⌥⌘Q VShows a particular view (Variables)

Window

Shortcut for Windows/LinuxShortcut for macOSAction
F12⌘F12Activate Editor
⌘WCloses the active Dialog
Ctrl+3⌘3Find actions. Quickly access UI elements
Ctrl+M⌃MMaximize/restore a state of active view or editor
Ctrl+F6⌘F6Switch to the next editor
Ctrl+F8⌘F8Switch to the next perspective
Ctrl+F7⌘F7Switch to the next view
Ctrl+Shift+F6⇧⌘F6Switch to the previous editor
Ctrl+Shift+F8⇧⌘F8Switch to the previous perspective
Ctrl+Shift+F7⇧⌘F7Switch to the previous view
Ctrl+E⌘EOpen the editor drop-down list
⇧F10Show the context menu
Alt+Shift+F3⌥⇧F3Shows contribution information for the currently selected element
Ctrl+Shift+L⇧⌘LShow the key assist dialog
Ctrl+F10⌘F10Show the context menu for the ruler
Alt+-⇧⌘F10Show the system menu
Ctrl+F10⌘F10Show the view menu
Ctrl+Shift+E⇧⌘ESwitch to an editor
Alt+F11⌃⌘FToggles 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/LinuxShortcut for macOSAction
Ctrl+Shift+,⌃⇧,Link with editor
Ctrl+Alt+Shift+D⌃⌥⇧DAdd Bookmark
EnterOpens task configuration
Ctrl+Shift+A⌃⇧ASet as default object

Navigation tree

Shortcut for Windows/LinuxShortcut for macOSAction
Alt+Left⌘[Move backward in the editor navigation history
Ctrl+Shift+Numpad_Divide⇧⌘Numpad_DivideCollapse the current tree
Ctrl+Shift+Numpad_Multiply⇧⌘Numpad_MultiplyExpand the current tree
Alt+Right⌘]Move forward in the editor navigation history
Ctrl+G⌃GGo to a specified line of text in Windows
Ctrl+L⌘LGo to a specified line of text (Editing Text)
Ctrl+.⌘.Navigate to the next item
Ctrl+Alt+Right⌃⌥→Next edit location
Alt+F7⌥F7Switch to the next page
Alt+PageDown⌥⇟Switch to the next sub-tab
Ctrl+PageDown⌃⇟Switch to the next tab
Ctrl+Shift+R⇧⌘ROpen an editor on a particular item
Ctrl+,⇧⌘.Navigate to the previous item
Ctrl+Alt+Left⌃QPrevious edit location
Alt+Shift+F7⌥⇧F7Switch to the previous page
Alt+PageUp⌥⇞Switch to the previous sub-tab
Ctrl+PageUp⌃⇞Switch to the previous tab
Alt+Shift+W⌥⌘WOpen the Show In menu

File

Shortcut for Windows/LinuxShortcut for macOSAction
F2F2Rename the selected item
F5F5Refresh the selected items
Ctrl+S⌘SSave the changes in current file
Ctrl+Shift+S⇧⌘SSave changes in all open files
Ctrl+F4⌘WClose the active editor
Ctrl+Shift+F4⇧⌘WClose all editors
Ctrl+N⌘NOpen the New item wizard
Alt+Shift+N⌥⌘NOpen the New menu
Ctrl+O⌃OOpen a file
Ctrl+P⌘PPrint
Alt+Enter⌘IDisplay the properties of the selected item

Run/Debug

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+Alt+M⌥⌘MAdd memory block
Ctrl+W⌘WClose the selected rendering
F11⌘F11Launch in debug mode
Ctrl+Z⌃DSend end of file
Ctrl+G⌘GGo to Address
Ctrl+N⌘NAdd a new rendering
Ctrl+Alt+N⌥⌘NShow renderings from next memory monitor.
Ctrl+Shift+.⇧⌘.Load next page of memory
Ctrl+Shift+,⇧⌘,Load previous page of memory
Ctrl+F11⇧⌘F11Launch in run mode
Ctrl+R⌘RResume and break when execution reaches the current line
Ctrl+Alt+B⌃⌥BSets whether or not any breakpoint should suspend execution
F5F5Step into
F6F6Step over
F7F7Step return
F8F8Resume
Ctrl+F2⌘F2Terminate
Ctrl+Shift+B⇧⌘BCreates or removes a breakpoint
Ctrl+T⌘TToggle visibility of the Memory Monitors Pane
Shift+F5⇧F5Toggles enablement of debug step filters

Git

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+Left⌘←Collapse Working Tree
Ctrl+#⌥⌘3Commit
Ctrl+C⌘CCopy Path to Clipboard
Ctrl+O⌘OShow the quick outline for a unified diff
F2F2Rename Branch
Ctrl+Shift+K⌃⇧KCommit changes to Git
Ctrl+Shift+U⌃⇧UUpdate changes from Git

Project

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+B⌘BBuild all projects

Oracle

Shortcut for Windows/LinuxShortcut for macOSAction
Ctrl+F9⌃F9Compile

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

Help

Shortcut for Windows&LinuxShortcut for macOSAction
F1F1Open 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 DBeaver will ask you to choose the connection explicitly.

Did we resolve your issue?