Connection
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| F4 | F4 | Open object editor | Open the object editor. Allows viewing and editing properties of a selected database object in a special editor. Used to modify parameters of tables, indexes, views, and other objects. |
| Ctrl + ⇧Shift + N | Ctrl + ⇧Shift + N | Connect to a database | Open database connection window. Opens a dialog to create a new connection, where you can select the DBMS type, specify connection parameters (host, port, database name, login, password), and save a profile for future use. |
| Ctrl + ⇧Shift + D | Ctrl + ⇧Shift + D | Open database meta-object | Open database meta-object. Opens a representation of metadata about the database, including its structure, dependencies, and service data. Useful for analyzing schemas and relationships between objects. |
| Ctrl + Alt + ⏎Enter | Ctrl + Alt + ⏎Enter | Open SQL console | Open SQL console. A quick way to execute SQL queries without creating and saving a separate script. The console is bound to the active connection and allows instantly getting query execution results. |
| Ctrl + ] | Ctrl + ] | Create SQL script | Create a new SQL script. Opens an editor with a new empty file for writing SQL code. Supports syntax highlighting, autocompletion, and error checking. The script can be saved and executed later. |
| F3 | F3 | Open SQL script | Open an existing SQL script. Opens a file selection dialog for opening. Supports files with .sql, .ddl, .dml extensions. Convenient for quick access to saved scripts. |
| Ctrl + ⏎Enter | ⌘Cmd + ⏎Enter | Open recent SQL script | Open the last SQL script for the active connection. Used for quick switching between recent SQL scripts created for the current database connection. The list of recent scripts is formed automatically based on work history. |
| Ctrl + Alt + ⇧Shift + K | Ctrl + 4 | Commit changes | Commit changes in the current session. Saves all uncommitted changes in the database, making them permanent. Changes can be rolled back after commit if needed. Used in auto-commit mode. |
| Alt + ` | Ctrl + V | Database tools menu | Show database tools context menu. Contains all available database actions, including connection management, script execution, metadata work, and import/export utilities. |
| Ctrl + Alt + ⇧Shift + U | Ctrl + Alt + ⇧Shift + U | Generate UUID/GUID | Generate UUID/GUID and insert into active editor. Generates a unique identifier in UUID (Universally Unique Identifier) format and automatically inserts it at the current cursor position. Useful when inserting unique values into unique identification fields. |
| Ctrl + Alt + ⇧Shift + B | Ctrl + Alt + ⇧Shift + B | Open database dashboard | Open database dashboard. Opens a dashboard with database overview information: performance, active connections, resource usage, process statuses, and other monitoring metrics. |
| Ctrl + Alt + ⇧Shift + R | Ctrl + 8 | Rollback changes | Rollback changes in the current session. Undoes all uncommitted changes in the database, returning data to its previous state. Used when canceling erroneous operations or needing to restore original data. |
| Ctrl + 0 | Ctrl + 0 | Select active schema | Select active schema for the current database. The schema defines a namespace where objects will be created and searched. Selecting a schema affects which tables and views will be available by default. |
| Ctrl + 9 | Ctrl + 9 | Select connection | Select connection for the current editor. Allows switching the database that the current SQL editor will work with. Useful when working with multiple databases simultaneously. |
| Alt + ⇧Shift + ↓Down / ↑Up | Alt + ⇧Shift + ↓Down / ↑Up | Switch vertical tabs | Switch vertical tabs. Allows navigating between vertically located tabs on the object panel. Works similarly to horizontal tab switching, but for the side panel. |
Result Set
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Main Keys | |||
| Alt + Insert | Alt + Insert | Add new row | Add a new row. Inserts a new empty row in the results table for entering new data. The new row is placed after the currently selected row and is ready to be filled with values. |
| Ctrl + D | Ctrl + D | Copy from row above | Copy values from the row above into the current one. Convenient for creating rows with similar data - copies all values from the row directly above the current one. |
| Ctrl + Alt + D | Ctrl + Alt + D | Copy from row below | Copy values from the row below into the current one. Similar to copying from the row above, but copies data from the row directly below the current one. |
| Alt + Delete | Alt + Delete | Delete current row | Delete the current row. Permanently deletes the selected row from the results table. May require confirmation before deletion to prevent accidental data loss. |
| Ctrl + Alt + Insert | Ctrl + Alt + Insert | Duplicate current row | Duplicate the current row. Creates an exact copy of the current row and inserts it immediately after the original. All values are copied, speeding up entry of repeating data. |
| ⏎Enter | ⏎Enter | Edit cell value | Edit cell value in inline mode. Allows changing a cell value directly in the table without opening an additional dialog. The cursor is placed in the cell for immediate editing. |
| Esc | Esc | Reset cell value | Reset cell to original value. Undoes all changes made to the cell and returns it to the previous saved value. Only works for uncommitted changes. |
| Ctrl + S | Ctrl + S | Apply data changes | Apply data changes. Saves all made data changes (inserted, updated, deleted rows) in the database. All changes accumulate and are applied in one statement. |
| Ctrl + Alt + ⇧Shift + T | Ctrl + Alt + ⇧Shift + T | Focus to filter/editor | Set focus on filter editor / data editor. Switches input focus between the filter row and data editor, allowing quick switching between searching and editing. |
| Ctrl + ⇧Shift + 7 | Ctrl + ⇧Shift + 7 | Switch focus to results | Switch focus to results view / active panel. Moves input focus to the panel with query execution results, allowing immediate work with the obtained data. |
| Ctrl + ⇥Tab | Ctrl + ⇥Tab | Switch Grid/Value panel | Switch focus between Grid view and Value panel cell representation. Useful for working with large text fields - in Value mode you can edit cell content in extended format. |
| Ctrl + Alt + ⇧Shift + ⏎Enter | Ctrl + Alt + ⇧Shift + ⏎Enter | Apply cell changes | Apply cell changes. Saves changes made to the current cell without needing to move to another row. Similar to pressing Enter, but fixes changes forcibly. |
| ⇧Shift + ⏎Enter | ⇧Shift + ⏎Enter | Edit cell in dialog | Edit cell value in a separate dialog. Opens an extended editing window for a cell with a larger input field. Convenient for working with long text and binary data. |
| Ctrl + ⇧Shift + = | Ctrl + ⇧Shift + = | Fetch all rows | Fetch all rows. Loads all records from the query result, ignoring limits on the number of displayed rows. Useful when pagination settings have a large limit. |
| Ctrl + Alt + N | Ctrl + Alt + N | Fetch next page | Fetch the next page of results. Loads the next portion of data if results are paginated. Allows viewing all data without loading the entire volume at once. |
| Ctrl + F11 | Ctrl + F11 | Filter by unique values | Filter by unique attribute values. Creates a filter by unique values in the current column, showing only unique records. Useful for finding duplicates and analyzing data distribution. |
| F11 | F11 | Filter context menu | Filter context menu. Opens a menu with filtering settings: filter types, comparison conditions, logical operators, and search patterns. |
| Ctrl + Alt + ⇧Shift + ←Left | Ctrl + Alt + ⇧Shift + ←Left | Move to first row | Move to the first row. Instantly moves the cursor to the first record in the query results, regardless of the total number of rows. |
| Ctrl + Alt + ⇧Shift + →Right | Ctrl + Alt + ⇧Shift + →Right | Move to last row | Move to the last row. Instantly moves the cursor to the last record in the query results, convenient for viewing the freshest data. |
| Alt + Space | Alt + Space | Follow foreign key | Follow foreign key reference. Opens related records from the table that the foreign key references. Allows quickly navigating relationships between tables. |
| Ctrl + Alt + ⇧Shift + →Right | Ctrl + Alt + ⇧Shift + →Right | Move to next row | Move to the next row. Moves the cursor one row down in the query results. Useful for sequential viewing of records. |
| Ctrl + Alt + ⇧Shift + ←Left | Ctrl + Alt + ⇧Shift + ←Left | Move to previous row | Move to the previous row. Moves the cursor one row up in the query results. Used for navigating results in reverse direction. |
| Ctrl + ⇧Shift + 1 | Ctrl + ⇧Shift + 1 | Foreign keys reference | Foreign keys and tables referencing the current table. Shows all foreign key constraint relationships for the selected table and tables that reference it. |
| Ctrl + R | Ctrl + R | Reject data changes | Reject data changes. Undoes all made data changes before commit. Returns the table to the state it was in before editing began. |
| Ctrl + Backspace | Ctrl + Backspace | Set default value | Set default value. Restores the cell's original value according to the table schema definition. Useful for resetting a changed value to its original. |
| Ctrl + ` | Ctrl + ` | Switch presentation | Switch results presentation. Changes the data display format between table, diagram, and other available presentations. Useful for visual data analysis. |
| ⇥Tab | ⇥Tab | Toggle Grid/Record view | Switch between presenting results as a table (Grid) and row-by-row presentation (Record). In Record mode, each column is displayed as a separate property with editing capability, convenient for working with a large number of columns. |
| F7 | F7 | Toggle result panels | Toggle results panels. Hides or shows the lower results panel, providing more space for the main editor when needed. |
| Ctrl + 2 | Ctrl + 2 | Toggle sort order | Toggle sort order of results (ascending/descending/default). Changes the sorting direction by the current column: ascending (ASC), descending (DESC), or resets to default value. |
| Ctrl + Alt + C | — | Select column(s) | Select column(s). Allows highlighting one or more columns in the results table. Selected columns can be moved, hidden, or other mass operations performed. |
| Ctrl + Alt + R | — | Select row(s) | Select row(s). Allows highlighting one or more rows in the results table. Selected rows can be copied, deleted, or other mass operations performed. |
| ⇧Shift + F11 | — | Column context menu | Show column context menu. Contains actions available for the column: sorting, filtering, changing data type, hiding, and other operations. |
| Ctrl + G | — | Go to row | Go to row. Opens a dialog to go to a specific row by its number in the query results. Useful when working with large data sets. |
| Ctrl + ⇧Shift + G | — | Go to column | Go to column. Opens a dialog to go to a specific column by its name or number. Useful when working with tables with a large number of columns. |
| Alt + 9 | ⌘Cmd + Alt + 9 | Zoom out | Decrease default font size in tables and query results. Use to improve readability when working with large volumes of data. Allows displaying more information on screen. |
| Alt + 0 | ⌘Cmd + Alt + 0 | Zoom in | Increase default font size in tables and query results. Useful when working with small font that is hard to read. Adjusts font scale within a comfortable range. |
| DBeaver Keyboard Only | |||
| Alt + ⇧Shift + →Right | — | Move column(s) right | Move column(s) right. Shifts selected columns one position to the right in the results table. Changes column display order without changing order in the database. |
| Alt + ⇧Shift + ←Left | — | Move column(s) left | Move column(s) left. Shifts selected columns one position to the left in the results table. Changes column display order without changing order in the database. |
| Alt + ⇧Shift + C | — | Copy column names | Copy column names. Copies to clipboard the names of all columns in the current selection in SQL list format. Useful when composing SELECT queries. |
| Alt + ⇧Shift + H | — | Hide columns | Hide columns. Hides selected columns from the results table without deleting them. Hidden columns can be shown again through a special recovery menu. |
| Alt + ⇧Shift + T | — | Show hidden columns | Show hidden columns. Restores visibility of previously hidden columns in the results table. All previously hidden columns become visible again. |
| Alt + ⇧Shift + F | — | Open filters settings | Open filters settings. Opens an extended filter settings window with the ability to set complex conditions, combine filters, and save filtering templates. |
Panels
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| F7 | F7 | Toggle results panels | Toggle results panels. Hides or shows all lower results panels, providing more space for the SQL editor when needed. |
| Ctrl + Alt + F6 | Ctrl + Alt + F6 | Show/hide Calc panel | Show/hide results panel (Calc). The calculations panel shows summary statistics: sums, average values, minimum, maximum, and other aggregate functions. |
| Ctrl + Alt + F5 | Ctrl + Alt + F5 | Show/hide Grouping panel | Show/hide results panel (Grouping). Grouping panel allows grouping data by certain columns with applying aggregate functions to each group. |
| Ctrl + Alt + F4 | Ctrl + Alt + F4 | Show/hide Metadata panel | Show/hide results panel (Metadata). Metadata panel shows information about data structure: column types, constraints, indexes, and other metadata. |
| Ctrl + Alt + F3 | Ctrl + Alt + F3 | Show/hide References panel | Show/hide results panel (References). Panel with foreign keys and related records from other tables, providing overview of object relationships. |
| Ctrl + Alt + F2 | Ctrl + Alt + F2 | Show/hide Value panel | Show/hide results panel (Value). Value panel shows detailed representation of the selected cell value, including binary data and long texts. |
Data Editor
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + Space | Ctrl + Space | Autocomplete | Enable autocompletion. Opens autocompletion list containing available identifiers, table names, columns, functions, and keywords. Speeds up code writing and reduces errors. |
| Ctrl + F | ⌘Cmd + F | Find and replace | Open text find and replace dialog. Supports search by regular expressions and replacing all matches in the document. Allows searching with case sensitivity and using patterns for complex patterns. |
| Ctrl + ⇧Shift + Space | Ctrl + ⇧Shift + Space | Context information | Show context information in dialogs and windows. Displays tooltips about available parameters, data types, and acceptable values in the current input field. |
| Ctrl + Alt + Space | Ctrl + Alt + Space | SQL Context info | Show context information (SQL Editor Context). Displays information about acceptable SQL elements at the current cursor position, helping write correct queries. |
| Ctrl + X | ⌘Cmd + X | Cut to clipboard | Highlight and delete selected text or data, placing it in clipboard for subsequent pasting. Clipboard content is available until the next copy. |
| Ctrl + C | ⌘Cmd + C | Copy to clipboard | Copy selection to clipboard without deleting the original text. Data is available for pasting elsewhere. In the data editor, supports formatting depending on context. |
| Ctrl + V | ⌘Cmd + V | Paste from clipboard | Paste clipboard content at the current cursor position. Supports validating pasted data, checking its compliance with the cell or field data type. |
| Delete | Delete | Delete selection | Delete selection. Permanently deletes the selected text fragment or data. When editing a table, deletes the content of the current cell. |
| Ctrl + O | ⌘Cmd + O | Export Diagram | Export ER diagram or database diagram to various formats (PNG, SVG, PDF). Available for table and relationship diagrams. Allows saving schema visualization for documentation. |
| Ctrl + K | ⌘Cmd + K | Find next | Find next match of the current search request. If search is not active, opens search dialog. Continues search from the current cursor position. |
| Ctrl + ⇧Shift + K | ⇧Shift + ⌘Cmd + K | Find previous | Find previous match of the current search request. Works in the direction opposite to Find next. Allows moving between all matches in the document. |
| Ctrl + J | ⌘Cmd + J | Incremental find | Start searching as you type text. Allows quickly finding an element by simply entering part of the search text. Search starts immediately after the first character. |
| Ctrl + ⇧Shift + J | ⇧Shift + ⌘Cmd + J | Incremental find reverse | Incremental search in reverse direction. Searches for matches against the document scroll direction. Useful for searching at the beginning of the document. |
| Ctrl + ⇧Shift + Q | Ctrl + ⇧Shift + Q | Quick diff | Toggle quick diff display on the line number ruler. Shows visual indicators of changes on the line number ruler, helping track made edits. |
| Ctrl + 1 | ⌘Cmd + 1 | Suggest fixes | Show context menu with suggestions for fixing errors and warnings. Available when there are problems in the code. Contains quick fixes for typical syntax and logic errors. |
| Ctrl + Y | ⇧Shift + ⌘Cmd + Z | Redo | Redo the last undone operation. Reverse function for Undo. Allows restoring previously undone changes. Can be repeated multiple times to restore a chain of changes. |
| Ctrl + Z | ⌘Cmd + Z | Undo | Undo the last editing operation. Can be repeated many times to undo a chain of changes. All undone changes can be restored through Redo. |
| ⇧Shift + Delete | ⇧Shift + Delete | Remove Pictogram | Delete selected diagram elements. Permanently deletes selected objects or relationships on the diagram. Useful for cleaning up the diagram of unnecessary elements. |
| Ctrl + A | ⌘Cmd + A | Select all | Select all content in the current editor or element. Can be used for copying or formatting all content. Works in all DBeaver panels. |
| Alt + ⇧Shift + A | Alt + ⌘Cmd + A | Block selection | Toggle block (rectangular) selection in the text editor. Allows highlighting text by columns, useful for editing tabular data in text form. |
| Ctrl + ⇧Shift + Insert | ⇧Shift + ⌘Cmd + Insert | Toggle insert mode | Switch input mode between Insert and Overwrite. In Overwrite mode, characters replace existing text when typed, rather than being inserted before it. |
| Alt + ⇧Shift + Y | Alt + ⌘Cmd + Y | Word wrap | Toggle word wrap in the text editor. When enabled, long lines are displayed on multiple lines, improving readability without horizontal scrolling. |
| Ctrl + F5 | ⌘Cmd + F5 | Update Pictogram | Update selected diagram elements, synchronizing them with actual properties from the database. Synchronizes the visual representation of the diagram with the actual state of objects in the DB. |
| Alt + / | Ctrl + . | Context completion | Completion without context awareness. Opens general code completion without considering the current cursor position. Shows all available elements for the current object type. |
| Ctrl + ⇧Shift + Space | Ctrl + ⇧Shift + Space | SQL Context completion | Completion without context awareness (SQL Editor Context). Opens intelligent autocompletion in SQL editor considering context: available fields, tables, functions at the current code position. |
Text Editor
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + ⇧Shift + Y | ⇧Shift + ⌘Cmd + Y | Lowercase | Convert selection to lowercase. All characters in the selected text will be converted to lowercase letters. Useful for bringing text to a unified format. |
| Ctrl + ⇧Shift + X | ⇧Shift + ⌘Cmd + X | Uppercase | Convert selection to uppercase. All characters in the selected text will be converted to uppercase letters. Useful for highlighting SQL keywords. |
| Ctrl + Num - | ⌘Cmd + Num - | Collapse region | Collapse code region in the current selection into a collapsible section. Pressing again expands the region back. Useful for hiding unused code blocks. |
| Ctrl + ⇧Shift + Num / | ⇧Shift + ⌘Cmd + Num / | Collapse all | Collapse all collapsed code regions in the current document. Useful for quickly reviewing file structure, hiding all implementation details. |
| Ctrl + Alt + ⇧Shift + ↓Down | Alt + ⌘Cmd + ↓Down | Duplicate line down | Duplicate selected lines and move selection to the copy. Useful for repeating code with minor changes. Copy is created below the original. |
| Ctrl + D | ⌘Cmd + D | Delete line | Delete the current line or selected lines without confirmation prompt. This action can be undone through Undo. Cursor moves to the next line. |
| Ctrl + Delete | Alt + Delete | Delete next word | Delete the next word from the cursor position. Deletes text to the end of the current word and to the beginning of the next, convenient for editing identifiers. |
| Ctrl + Backspace | Alt + Backspace | Delete previous word | Delete the previous word to the cursor position. Deletes text from the beginning of the previous word to the current position. Useful for quickly clearing incorrectly entered text. |
| Ctrl + ⇧Shift + Delete | ⇧Shift + ⌘Cmd + Delete | Delete to end of line | Delete all text from the cursor position to the end of the current line. The initial cursor position is preserved. Useful for deleting unwanted code to the right of the cursor. |
| Ctrl + Alt + ⇧Shift + ↑Up | Alt + ⌘Cmd + ↑Up | Duplicate line up | Duplicate selected lines and insert them above the current position. Copy is created above the original, and selection remains on the original text. |
| Ctrl + Num + | ⌘Cmd + Num + | Expand region | Expand the collapsed code region in the current selection. Collapses the region again on repeated press. Used together with collapsing for code navigation. |
| Ctrl + Num * | ⌘Cmd + Num * | Expand all | Expand all collapsed code regions in the current document. Reverse action for Collapse all. Used to fully display all code in the file. |
| Ctrl + ⇧Shift + ⏎Enter | ⇧Shift + ⌘Cmd + ⏎Enter | Add line above | Add a new empty line above the current cursor position preserving indentation. Indentation is copied from the current line to preserve code structure. |
| ⇧Shift + ⏎Enter | ⇧Shift + ⌘Cmd + ⏎Enter | Add line below | Add a new empty line below the current cursor position preserving indentation. Indentation is copied from the current line to preserve code structure. |
| Ctrl + Alt + J | — | Join lines | Join text lines (editing text). Joins selected lines into one, removing line break characters between them. Useful for forming long expressions into one line. |
| Ctrl + ⇧Shift + J | Ctrl + ⇧Shift + J | Join lines SQL | Join text lines (SQL Editor Context). Joins SQL queries from multiple lines into one, preserving correct SQL code syntax. |
| End | ⌘Cmd + →Right | Go to end of line | Move cursor to the very end of the current line. On macOS also works as a navigation key. Cursor is placed after the last character of the line. |
| Home | ⌘Cmd + ←Left | Go to start of line | Move cursor to the very beginning of the current line. On macOS also works as a navigation key. Cursor is placed before the first character of the line. |
| Alt + ⇧Shift + ↓Down | Ctrl + ⇧Shift + ↓Down | Move lines down | Move selected lines down (Editing Text). Moves text without changing its content. Useful for reorganizing code without copying. |
| Ctrl + ⇧Shift + ↓Down | Alt + ⇧Shift + ↓Down | Move lines down SQL | Move selected lines down (SQL Editor Context). Specialized version of line moving for SQL editor considering syntax. |
| Alt + ⇧Shift + ↑Up | Ctrl + ⇧Shift + ↑Up | Move lines up | Move selected lines up (Editing Text). Moves text up without changing its content. Useful for reorganizing code without copying. |
| Ctrl + ⇧Shift + ↑Up | Alt + ⇧Shift + ↑Up | Move lines up SQL | Move selected lines up (SQL Editor Context). Specialized version of line moving for SQL editor considering syntax. |
| Ctrl + ⇧Shift + →Right | Alt + ⇧Shift + →Right | Select next word | Select the next word. Expands selection from the current position to the beginning of the next word. Useful for quickly selecting individual words and identifiers. |
| Ctrl + ⇧Shift + ←Left | Alt + ⇧Shift + ←Left | Select previous word | Select the previous word. Expands selection from the current position to the beginning of the previous word. Useful for quickly selecting individual words and identifiers. |
| Ctrl + ⇧Shift + Num * | ⇧Shift + ⌘Cmd + Num * | Reset folding | Reset all code folding structure in the document. Expand all collapsed regions. Useful after making changes when you need to view all code. |
| Ctrl + →Right | — | Scroll down | Scroll down by one line. Performs scrolling of the editor content down by one screen or line, depending on settings. |
| Ctrl + ↑Up | — | Scroll up | Scroll up by one line. Performs scrolling of the editor content up by one screen or line, depending on settings. |
| ⇧Shift + End | ⇧Shift + ⌘Cmd + →Right | Select to end of line | Select text from the cursor position to the end of the current line. The cursor remains in place, and selection expands to the end of the line. |
| ⇧Shift + Home | ⇧Shift + ⌘Cmd + ←Left | Select to start of line | Select text from the cursor position to the beginning of the current line. The cursor remains in place, and selection expands to the beginning of the line. |
| Ctrl + ⇧Shift + →Right | Alt + ⇧Shift + →Right | Select next word | Select Next Word. Extends the selection from the current position to the beginning of the next word. Useful for quickly selecting individual words and identifiers. |
| Ctrl + ⇧Shift + ←Left | Alt + ⇧Shift + ←Left | Select previous word | Select Previous Word. Extends the selection from the current position to the beginning of the previous word. Useful for quickly selecting individual words and identifiers. |
| — | ⇧Shift + ↘ | Select to end of text | Select to the end of text. Expands selection from the current position to the very end of the document. Useful for selecting all content after the cursor. |
| — | ⇧Shift + ↖ | Select to start of text | Select to the start of text. Expands selection from the current position to the very beginning of the document. Useful for selecting all content before the cursor. |
| F2 | F2 | Caret info | Show information for the current cursor position. Displays information about the element the cursor is on: type, name, available actions, and context. |
| Ctrl + End | ↘ | Go to end of text | Go to the end of text. Instantly moves the cursor to the very last position of the document. Similar to sequentially pressing Ctrl + Down to the end. |
| Ctrl + Home | ↖ | Go to start of text | Go to the start of text. Instantly moves the cursor to the very first position of the document. Similar to sequentially pressing Ctrl + Up to the start. |
| Ctrl + Num / | ⌘Cmd + Num / | Toggle folding | Toggle collapsing/expanding code in the current editor. Creates or removes collapsible code blocks, allowing hiding and showing individual sections. |
| Insert | Insert | Toggle overwrite | Switch input mode between Insert and Overwrite. In Overwrite mode, characters replace existing text when typed, rather than being inserted before it. |
| Ctrl + + | ⌘Cmd + + | Zoom in | Increase font size in text editors. Improves code readability by increasing character size. Can be used multiple times for gradual increase. |
| Ctrl + = | ⌘Cmd + = | Zoom in | Increase font size in text editors (alternative method). Effect is similar to Ctrl + +. Alternative way to increase font scale. |
| Ctrl + - | ⌘Cmd + - | Zoom out | Decrease font size in text editors. Useful when viewing large blocks of code, allowing more information to fit on screen. |
SQL Editor
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Alt + X | Alt + X | Execute SQL script | Execute SQL script. Launches execution of the entire current SQL script in the editor. All queries are executed sequentially within one transaction (if not disabled). |
| Alt + N | Alt + N | Execute SQL natively | Execute SQL script natively. Sends the query directly to the database bypassing DBeaver's standard processing mechanism. Used for special queries requiring native execution. |
| Ctrl + ⏎Enter | ⌘Cmd + ⏎Enter | Execute SQL statement | Execute SQL statement. Launches execution of the current SQL statement where the cursor is located. Only one statement is executed, even if there are multiple queries in the document. |
| Ctrl + < | Ctrl + < | Execute in new tab | Execute SQL statement in a tab. Executes the selected query and opens results in a new tab, allowing comparison of results from multiple queries. |
| Ctrl + Alt + ⇧Shift + X | Ctrl + Alt + ⇧Shift + X | Execute in separate tabs | Execute script queries in results tabs. Each query in the script is executed separately and results open in their own tab for convenient comparison. |
| Ctrl + / | Ctrl + / | Toggle line comment | Add/remove single-line comment. Adds or removes a comment symbol (--) at the beginning of the current line. Useful for quickly disabling code lines when debugging. |
| Ctrl + ⇧Shift + / | Ctrl + ⇧Shift + / | Toggle block comment | Add/remove multi-line comment. Wraps selection in a comment /* ... */ or removes it. Useful for blocking large fragments of code. |
| Ctrl + Alt + ⇧Shift + T | Ctrl + Alt + ⇧Shift + T | Switch SQL panel | Switch active SQL editor panel. Changes focus between SQL editor panels: code editor, results, execution history. |
| Ctrl + T | Ctrl + T | Toggle results panel | Toggle results panel. Hides or shows the panel with the last executed query results in the SQL editor. |
| Ctrl + ⇧Shift + \ | Ctrl + ⇧Shift + \ | Close results tab | Close results tab. Closes the current active tab with SQL query results, freeing workspace. |
| Ctrl + ⇧Shift + F | Ctrl + ⇧Shift + F | Format text | Format text. Automatically formats SQL code according to settings: places keywords on new lines, aligns indentation and spaces. |
| Ctrl + Alt + ' | Ctrl + Alt + ' | Select value expression | Select the value of the selected SQL expression. Highlights the value of the current expression in SQL code, allowing quick copying or changing it. |
| Ctrl + ⇧Shift + E | Ctrl + ⇧Shift + E | Explain execution plan | Explain execution plan. Shows the query execution plan, including used indexes, table scan order, and cost estimation of operations. |
| Ctrl + ⇧Shift + [ | Ctrl + ⇧Shift + [ | Jump to bracket | Jump to the matching bracket. Finds and moves the cursor to the paired bracket (opening/closing) for the current position. Useful when working with nested queries. |
| Ctrl + ⇧Shift + ] | Ctrl + ⇧Shift + ] | Select between brackets | Select text between brackets. Highlights all content between the current pair of brackets. Useful for quickly selecting nested expressions or subqueries. |
| Ctrl + Alt + ⇧Shift + O | Ctrl + Alt + ⇧Shift + O | Load SQL from file | Load SQL script from the file system. Opens a file selection dialog to load SQL code from an external source into the current editor tab. |
| Ctrl + ⇧Shift + T | Ctrl + ⇧Shift + T | Maximize results panel | Maximize/normalize results panel. Expands the results panel to the full screen and returns to normal size. |
| Alt + ⇧Shift + ↓Down | Alt + ⇧Shift + ↓Down | Next query | Switch to the next query. Moves execution focus to the next SQL query in the current script. Useful for sequential execution of multiple queries. |
| Alt + ⇧Shift + ↑Up | Alt + ⇧Shift + ↑Up | Previous query | Switch to the previous query. Moves execution focus to the previous SQL query in the current script. Useful for navigating the script. |
| Ctrl + F2 | Ctrl + F2 | Rename SQL script | Rename the current SQL script. Opens a dialog to enter a new name for the current SQL file. Useful when organizing many scripts. |
| F4 | F4 | Open object editor | Open editor for the current (selected) database object. Opens the object properties editor for modifying its parameters. |
| Ctrl + Alt + ⇧Shift + A | Ctrl + Alt + ⇧Shift + A | Select all rows | Select all rows (without sample size limit). Loads and selects all available rows from the result, ignoring sample size limit settings. |
| Ctrl + Alt + ⇧Shift + C | Ctrl + Alt + ⇧Shift + C | Select row count | Select the number of rows for the query under the cursor. Allows setting a specific number of rows to fetch in the current query. |
| Ctrl + ⇧Shift + . | Ctrl + ⇧Shift + . | Set active connection | Set active connection from the database navigator selection. Connects the current SQL editor to the selected database via Database Navigator. |
| Ctrl + ⇧Shift + O | Ctrl + ⇧Shift + O | Show server output | Show server output console. Opens a panel with output from the database server: messages about completed operations, errors, and warnings. |
| Ctrl + Alt + ⇧Shift + W | Ctrl + Alt + ⇧Shift + W | Toggle word wrap | Toggle soft word wrap in the text editor. Enables or disables automatic line wrap of long SQL code lines. |
| Ctrl + ⇧Shift + I | Ctrl + ⇧Shift + I | Switch to AI Chat | Switch to AI Chat view. Switches the SQL editor to AI chat mode for getting help writing SQL queries using artificial intelligence. |
| Alt + Ctrl + ⇧Shift + →Right | Alt + ⌘Cmd + →Right | AI query suggestion | Invoke AI query suggestion. Press →Right, ⇥Tab, or ⏎Enter to insert the suggestion. Press Esc to close. AI generates an SQL query based on a task description in natural language. |
Diagrams
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| ⇧Shift + ⏎Enter | ⇧Shift + ⌘Cmd + ⏎Enter | Open table diagram | Open diagram for the selected table. Generates and displays an ER diagram for the selected table with relationships and dependencies. |
| Ctrl + P | ⌘Cmd + P | Print diagram | Print diagram. Opens a print dialog for outputting the database diagram to paper or PDF file. |
| ↑Up / ↓Down / ←Left / →Right | ↑Up / ↓Down / ←Left / →Right | Navigate tables | Navigate between tables. Moves focus between tables on the diagram. Allows navigating between diagram objects with keyboard arrows. |
| ⇧Shift + ↑Up / ↓Down / ←Left / →Right | ⇧Shift + ↑Up / ↓Down / ←Left / →Right | Select multiple tables | Select multiple tables. Allows simultaneously selecting multiple objects on the diagram for mass operations: moving, deleting, changing properties. |
| Ctrl + ⇧Shift + ↑Up / ↓Down / ←Left / →Right + Spacebar | Ctrl + ⇧Shift + ↑Up / ↓Down / ←Left / →Right + Spacebar | Add tables to selection | Add tables to selection. Adds a table to already selected objects on the diagram without removing current selection. |
| Spacebar | Spacebar | Select current table | Select the current table. Activates the current table on the diagram and highlights it for subsequent operations. |
. then ↑Up / ↓Down / ←Left / →Right + Enter |
. then ↑Up / ↓Down / ←Left / →Right + ⏎Enter |
Move/resize tables | Move/resize tables. Move/resize mode: press dot, then arrows to move or Shift+arrows to resize, Enter to confirm. |
| Enter | ⏎Enter | Focus attributes | Focus on attributes. Sets focus on attributes of the selected table, allowing editing column properties directly on the diagram. |
| Backspace | Backspace | Leave focus | Leave focus. Removes focus from the current diagram element, allowing switching to another object or action. |
| Alt + 1 | Alt / Fn + 1 | Focus diagram | Focus on diagram. Sets focus on the main diagram area for navigating and managing objects. |
| Alt + 2 | Alt / Fn + 2 | Focus palette | Focus on palette. Sets focus on the diagram tools palette for choosing actions with objects. |
| Alt + 3 | Alt / Fn + 3 | Focus outline | Focus/open outline. Sets focus on the outline panel showing the structure and relationships of diagram objects. |
| Alt + 4 | Alt / Fn + 4 | Focus parameter view | Focus on parameter panel. Sets focus on the parameter panel for configuring display and object properties. |
Additional association focus shortcuts
Use these hotkeys for navigating between relationship lines of the selected table:
|- focus on the next relationship. Switches focus to the next relationship line of the selected table.?- focus on the previous relationship. Switches focus to the previous relationship line of the selected table.\- cyclic view of all relationships of the selected table. Sequentially switches focus between all relationships of the selected table in a loop.
Note
On macOS, using move/resize mode (.) may require enabling access permissions in System Preferences -> Security & Privacy -> Accessibility to ensure hotkeys work correctly.
Visual Query Builder
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + B | Ctrl + B | Open Visual Query Builder | Open visual query builder. Launches visual SQL query creation mode using drag-and-drop of tables, columns, and conditions without writing code. |
| Ctrl + ⇧Shift + B | Ctrl + ⇧Shift + B | Show/hide SQL query | Show/hide the generated SQL query. Displays or hides the SQL code automatically generated by the visual query builder. |
| Ctrl + Alt + Pg Up / Pg Dn | Ctrl + Alt + Pg Up / Pg Dn | Switch vertical tabs | Switch vertical tabs of the visual query builder between settings, tables, and conditions tabs. |
| Ctrl + ⇧Shift + Pg Up / Pg Dn | Ctrl + ⇧Shift + Pg Up / Pg Dn | Switch vertical tabs | Alternative way to switch vertical tabs. Alternative navigation method for visual query builder tabs. |
| Alt + 1 | Alt + 1 | Focus main tab | Switch focus to the main tab. Focus on the main tab of the visual builder with tables and query settings. |
| Alt + 2 | Alt + 2 | Focus palette | Switch focus to the palette. Focus on the visual query builder tools palette for choosing actions. |
| Alt + 3 | Alt + 3 | Focus outline | Switch focus to the outline. Focus on the outline panel of the visual builder for overviewing the query structure. |
| Alt + 4 | Alt + 4 | Focus parameters | Switch focus to parameters. Focus on the query parameter panel for configuring parameter values and variables. |
| Alt + 5 | Alt + 5 | Focus VQB settings | Switch to the visual query builder settings part. Focus on the visual builder settings: JOIN type, GROUP BY, ORDER BY, and other parameters. |
| Alt + 6 | Alt + 6 | Focus query preview | Switch to query preview. Focus on the preview panel with the generated SQL query for verifying correctness. |
Important
Hotkeys Alt + 1 through Alt + 6 are effective only in the DBeaver Keyboard Scheme keymap. Other keymaps may use different combinations for similar actions.
Search
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + H | Ctrl + H | Open Search dialog | Open search dialog. Opens an expanded search dialog with additional options: search by projects, filtering by file type, regular expressions. |
| Ctrl + Alt + G | Alt + ⌘Cmd + G | Search in workspace | Search text in workspace files. Searches the specified text in all files of the current project/workspace. Useful for searching definitions, function calls, and mentions. |
| Ctrl + Alt + ⇧Shift + F | Alt + ⇧Shift + ⌘Cmd + L | Quick search (Windows) | Quick search in the workspace via the search menu. Instantly opens a quick search bar for entering a search query without going to a separate dialog. |
Data viewer
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| ⇥Tab | ⇥Tab | Cycle hand tool | Cyclically switch the hand tool for dragging data viewer elements. Enables the hand tool, allowing dragging objects in the diagram or data view. |
| Ctrl + = | ⌘Cmd + = | Zoom In | Increase the display scale of data. Increases the size of elements in the data viewer, improving readability when working with small text. |
| Ctrl + - | ⌘Cmd + - | Zoom Out | Decrease the display scale of data. Decreases the size of elements in the data viewer, allowing more information to be seen on screen. |
| Alt + ⇧Shift + Q, Q | Alt + ⌘Cmd + Q, Q | Show view | Show a specific data view. Opens the standard data view for displaying content in various presentation formats. |
| Alt + ⇧Shift + Q, B | Alt + ⌘Cmd + Q, B | Show Breakpoints view | Show Breakpoints panel for managing breakpoints. Opens the breakpoints management panel during data debugging. |
| Alt + ⇧Shift + Q, C | Alt + ⌘Cmd + Q, C | Show Console view | Show Console panel for output console. Opens a console interface for interacting with data through text commands. |
| Alt + ⇧Shift + Q, L | Alt + ⌘Cmd + Q, L | Show Error Log view | Show Error Log panel with the error log. Opens the error registration log related to data processing and display. |
| Alt + ⇧Shift + Q, Z | Alt + ⌘Cmd + Q, Z | Show History view | Show History panel with the history of actions. Opens the history of performed data operations for analysis and repetition. |
| Alt + ⇧Shift + Q, O | Alt + ⌘Cmd + Q, O | Show Outline view | Show Outline panel with outline representation. Opens a structural representation of data, showing hierarchies and relationships between elements. |
| Alt + ⇧Shift + Q, X | Alt + ⌘Cmd + Q, X | Show Problems view | Show Problems panel with problems and warnings. Opens a panel with data processing problem messages. |
| Alt + ⇧Shift + Q, S | Alt + ⌘Cmd + Q, S | Show Search view | Show Search panel with search results. Opens a panel with search results for data, including found matches and context. |
| Alt + ⇧Shift + Q, Y | Alt + ⌘Cmd + Q, Y | Show Synchronize view | Show Synchronize panel for file synchronization. Opens a synchronization panel for comparing and merging changes. |
| Alt + ⇧Shift + Q, V | Alt + ⌘Cmd + Q, V | Show Variables view | Show Variables panel with environment variables. Opens a variables panel for managing data viewer parameters. |
Window
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| F12 | ⌘Cmd + F12 | Activate Editor | Activate editor. Moves input focus to the active code editor, allowing immediate editing. |
| — | ⌘Cmd + W | Close Dialog | Close the active dialog. Closes the currently open dialog window without saving changes. |
| Ctrl + 3 | ⌘Cmd + 3 | Find actions | Quick access to UI elements. Opens a quick search palette, allowing instantly finding and calling any commands and interface elements by name. |
| Ctrl + M | Ctrl + M | Maximize editor | Maximize/restore the active view or editor state. Expands the editor to the full available area and returns to the previous size. |
| Ctrl + F6 | ⌘Cmd + F6 | Switch editor | Switch to the next editor. Cyclically switches focus between open editors in their order of location. |
| Ctrl + F8 | ⌘Cmd + F8 | Switch perspective | Switch to the next perspective. Changes the work context (perspective) to the next: SQL, Database, Debug, and others. |
| Ctrl + F7 | ⌘Cmd + F7 | Switch view | Switch to the next view. Changes focus to the next view panel in the current perspective: navigator, properties, results, etc. |
| Ctrl + ⇧Shift + F6 | ⇧Shift + ⌘Cmd + F6 | Switch previous editor | Switch to the previous editor. Returns focus to the previous editor that was used before the current one. |
| Ctrl + ⇧Shift + F8 | ⇧Shift + ⌘Cmd + F8 | Switch previous perspective | Switch to the previous perspective. Returns to the previous perspective that was used before the current one. |
| Ctrl + ⇧Shift + F7 | ⇧Shift + ⌘Cmd + F7 | Switch previous view | Switch to the previous view. Returns focus to the previous view that was used before the current one. |
| Ctrl + E | ⌘Cmd + E | Editor drop-down | Open editor drop-down list. Shows a list of all open editors for quick switching between them. |
| — | ⇧Shift + F10 | Context menu | Show context menu. Opens a context menu for the current element, containing available actions and commands. |
| Alt + ⇧Shift + F3 | Alt + ⇧Shift + F3 | Show contribution info | Show contribution information for the selected element. Displays information about the component providing the current functionality. |
| Ctrl + ⇧Shift + L | ⇧Shift + ⌘Cmd + L | Key assist dialog | Show key assist dialog. Opens a hotkey reference, showing all available combinations for the current context. |
| Ctrl + F10 | ⌘Cmd + F10 | Ruler context menu | Show ruler context menu. Opens a menu of actions available for the line number ruler in the code editor. |
| Alt + - | ⇧Shift + ⌘Cmd + F10 | System menu | Show system menu. Opens the application system menu with basic actions: minimize, maximize, close. |
| Ctrl + F10 | ⌘Cmd + F10 | View menu | Show view menu. Opens a menu with view management commands: sorting, filtering, grouping, and other display settings. |
| Ctrl + ⇧Shift + E | ⇧Shift + ⌘Cmd + E | Switch to editor | Switch to editor. Instantly moves focus to the editor panel, allowing switching between open files. |
| Alt + F11 | Ctrl + ⌘Cmd + F | Toggle full screen | Toggle the window between full screen and normal mode. Expands DBeaver to the full monitor screen and returns to windowed mode. |
| Ctrl + _ | ⇧Shift + ⌘Cmd + - | Split editor (Horizontal) | Split or merge the current active editor (horizontally). Splits the editor into two parts horizontally for parallel viewing of two files. |
| Ctrl + _ | ⇧Shift + ⌘Cmd + [ | Split editor (Vertical) | Split or merge the current active editor (vertically). Splits the editor into two parts vertically for parallel viewing of two files. |
Database Navigator
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + ⇧Shift + , | Ctrl + ⇧Shift + , | Link with editor | Link with editor. Establishes a link between the selected navigator element and the active editor, automatically inserting the object into SQL code. |
| Ctrl + Alt + ⇧Shift + D | Ctrl + Alt + ⇧Shift + D | Add Bookmark | Add bookmark. Adds the selected element to bookmarks for quick access to frequently used database objects. |
| Enter | ⏎Enter | Open task config | Open task configuration. Opens the settings window of the selected task or connection for changing parameters. |
| Ctrl + ⇧Shift + A | Ctrl + ⇧Shift + A | Set as default object | Set as default object. Makes the selected object primary for default actions, such as executing scripts or viewing properties. |
Properties Entity Editor
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Alt + ⇧Shift + ↑Up | Alt + ⇧Shift + ↑Up | Switch entity tab up | Switch to the next entity property tab from the left. Moves focus to the left tab in the database object properties editor. |
| Alt + ⇧Shift + ↓Down | Alt + ⇧Shift + ↓Down | Switch entity tab down | Switch to the previous entity property tab from the left. Moves focus to the right tab in the database object properties editor. |
| Ctrl + Alt + Pg Up / Pg Dn Ctrl + ⇧Shift + Pg Up / Pg Dn |
Ctrl + Alt + Pg Up / Pg Dn Ctrl + ⇧Shift + Pg Up / Pg Dn |
Switch vertical tabs | Switch vertical tabs. Switches between tabs in the object properties panel: General, Columns, Indexes, Constraints, and others. |
Navigation tree
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Alt + ⇧Shift + W | Alt + ⌘Cmd + W | Show In menu | Open Show In menu. Shows a context menu with options for locating the selected element in different panels and views. |
| Alt + ←Left | ⌘Cmd + [ | Move backward | Move backward in the editor navigation history. Returns to the previous position in the history of transitions by files and objects. |
| Ctrl + ⇧Shift + Num / | ⇧Shift + ⌘Cmd + Num / | Collapse tree | Collapse the current tree. Collapses all nodes of the navigation tree, hiding nested elements for simplifying the structure overview. |
| Ctrl + ⇧Shift + Num * | ⇧Shift + ⌘Cmd + Num * | Expand tree | Expand the current tree. Expands all collapsed nodes of the navigation tree, showing the full structure of database objects. |
| Alt + ⇧Shift + →Right | ⌘Cmd + ] | Move forward | Move forward in the editor navigation history. Goes to the next position in the history of transitions by files and objects. |
| Ctrl + G | Ctrl + G | Go to line (Windows) | Go to a specified text line (Windows). Opens a dialog to enter a line number and instantly go to it. |
| Ctrl + L | ⌘Cmd + L | Go to line | Go to a specified text line (Editing Text). Opens a dialog to enter a line number and instantly go to it in the editor. |
| Ctrl + . | ⌘Cmd + . | Navigate next | Navigate to the next element. Moves to the next definition or usage of an element in the code (overrides, references). |
| Ctrl + Alt + ⇧Shift + →Right | Ctrl + Alt + ⇧Shift + →Right | Next edit location | Next edit location. Moves to the next position where changes were made in the document. |
| Alt + F7 | Alt + F7 | Next page | Switch to the next page. Goes to the next page in the paginated data view. |
| Alt + Pg Dn | Alt + ⇟ | Next sub-tab | Switch to the next sub-tab. Goes to the next subsection in the current navigation section. |
| Ctrl + Pg Dn | Ctrl + ⇟ | Next tab | Switch to the next tab. Moves focus to the next tab in the group of open tabs. |
| Ctrl + ⇧Shift + R | ⇧Shift + ⌘Cmd + R | Open editor on item | Open editor on a specific element. Opens the selected element in the corresponding editor: SQL, DDL, data, etc. |
| Ctrl + , | ⇧Shift + ⌘Cmd + . | Navigate previous | Navigate to the previous element. Moves to the previous definition or usage of an element in the code. |
| Ctrl + Alt + ⇧Shift + ←Left | Ctrl + Q | Previous edit location | Previous edit location. Moves to the previous position where changes were made in the document. |
| Alt + ⇧Shift + F7 | Alt + ⇧Shift + F7 | Previous page | Switch to the previous page. Goes to the previous page in the paginated data view. |
| Alt + Pg Up | Alt + ⇞ | Previous sub-tab | Switch to the previous sub-tab. Goes to the previous subsection in the current navigation section. |
| Ctrl + Pg Up | Ctrl + ⇞ | Previous tab | Switch to the previous tab. Moves focus to the previous tab in the group of open tabs. |
File
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| F2 | F2 | Rename item | Rename the selected element. Allows changing the name of a file, table, column, or any other object in the database. |
| F5 | F5 | Refresh items | Refresh the selected elements. Updates the display of selected elements in the navigator, actualizing changes made outside DBeaver. |
| Ctrl + S | ⌘Cmd + S | Save file | Save changes in the current file. Saves all made changes in the open file without closing the editor. |
| Ctrl + ⇧Shift + S | ⇧Shift + ⌘Cmd + S | Save all files | Save changes in all open files. Saves all files that have unsaved changes in one action. |
| Ctrl + F4 | ⌘Cmd + W | Close editor | Close the active editor. Closes the currently open file or query tab. Before closing, will offer to save changes. |
| Ctrl + ⇧Shift + F4 | ⇧Shift + ⌘Cmd + W | Close all editors | Close all editors. Closes all open tabs and editors. Before closing, will offer to save changes in all files. |
| Ctrl + N | ⌘Cmd + N | New item wizard | Open the wizard for creating a new element. Launches a step-by-step wizard for creating a new object: file, query, table, connection, etc. |
| Alt + ⇧Shift + N | Alt + ⌘Cmd + N | New menu | Open the New menu. Shows a menu with options for creating new elements: SQL script, table, view, connection, and others. |
| Ctrl + O | Ctrl + O | Open file | Open file. Opens a file selection dialog for opening in the editor. Supports SQL, TXT, CSV, and other formats. |
| Ctrl + P | ⌘Cmd + P | Print. Opens a dialog for configuring and printing the current document: printer selection, number of copies, page orientation. | |
| Alt + Enter | ⌘Cmd + I | Properties | Show properties of the selected element. Opens a properties panel with full information about the selected object and configuration options. |
Run/Debug
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + Alt + M | Alt + ⌘Cmd + M | Add memory block | Add memory block. Adds a new block for monitoring memory during debugging, allowing tracking memory usage in real time. |
| Ctrl + W | ⌘Cmd + W | Close rendering | Close the selected view. Closes the active data display or diagram, freeing workspace. |
| F11 | ⌘Cmd + F11 | Launch debug | Launch in debug mode. Launches script execution in debug mode with the ability to set breakpoints and step-by-step execution. |
| Ctrl + Z | Ctrl + D | Send EOF | Send end of file. Sends an end-of-file (EOF) signal to the active session, signaling the end of data input. |
| Ctrl + G | ⌘Cmd + G | Go to Address | Go to address. Opens a dialog to go to a specific address in memory or code during debugging. |
| Ctrl + N | ⌘Cmd + N | Add rendering | Add a new view. Adds a new data display view in debug mode for monitoring variables and objects. |
| Ctrl + Alt + N | Alt + ⌘Cmd + N | Next memory monitor | Show the next memory monitor view. Switches to the next memory monitor for tracking memory usage. |
| Ctrl + ⇧Shift + . | ⇧Shift + ⌘Cmd + . | Load next memory page | Load the next memory page. Loads the next page of memory data when viewing binary data. |
| Ctrl + ⇧Shift + , | ⇧Shift + ⌘Cmd + , | Load previous memory page | Load the previous memory page. Loads the previous page of memory data when viewing binary data. |
| Ctrl + F11 | ⇧Shift + ⌘Cmd + F11 | Launch run mode | Launch in run mode. Launches script execution in normal mode without debugging, without stopping at breakpoints. |
| Ctrl + R | ⌘Cmd + R | Resume and break | Resume and break when execution reaches the current line. Continues execution and stops when reaching the line with the cursor. |
| Ctrl + Alt + B | Ctrl + Alt + B | Toggle breakpoint suspend | Set whether breakpoints should suspend execution. Switches breakpoint behavior: suspend execution or only record the event. |
| F5 | F5 | Step into | Step into. Executes the current line, entering into called functions for step-by-step analysis of their code. |
| F6 | F6 | Step over | Step over. Executes the current line without entering into called functions. The function executes completely in one step. |
| F7 | F7 | Step return | Step return. Completes execution of the current function and returns to the calling code, stopping at the next line. |
| F8 | F8 | Resume | Resume. Continues execution to the next breakpoint or until the script completes. Used to skip code sections. |
| Ctrl + F2 | ⌘Cmd + F2 | Terminate | Terminate. Immediately stops execution of the debugged script and cleans up debug session resources. |
| Ctrl + ⇧Shift + B | ⇧Shift + ⌘Cmd + B | Toggle breakpoint | Create or remove a breakpoint. Adds a breakpoint to the current line if not already present, and removes it if already set. |
| Ctrl + T | ⌘Cmd + T | Toggle Memory Monitors Pane | Toggle visibility of the memory monitors panel. Shows or hides the memory usage monitoring panel during execution. |
| ⇧Shift + F5 | ⇧Shift + F5 | Toggle step filters | Toggle debug step filters. Controls which functions are skipped during step-by-step execution: system libraries, frameworks, etc. |
Git
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| Ctrl + ←Left | ⌘Cmd + ←Left | Collapse Working Tree | Collapse the working tree. Collapses the Git change tree, hiding the details of changed files in the view. |
| Ctrl + # | Alt + ⌘Cmd + 3 | Commit | Commit changes. Opens a dialog to create a commit with a record of made changes in the Git repository. |
| Ctrl + C | ⌘Cmd + C | Copy Path | Copy path to clipboard. Copies the full path to the selected file or object in the Git repository. |
| Ctrl + O | ⌘Cmd + O | Quick outline (diff) | Open a quick outline for unified diff. Shows an overview of differences between file versions in a compact form. |
| F2 | F2 | Rename Branch | Rename branch. Opens a dialog to rename the current Git branch without losing change history. |
| Ctrl + ⇧Shift + K | Ctrl + ⇧Shift + K | Commit to Git | Commit changes to Git. Commits all changes in selected files with the ability to enter a commit message. |
| Ctrl + ⇧Shift + U | Ctrl + ⇧Shift + U | Update from Git | Update changes from Git. Gets the latest changes from the remote repository and merges them with the local copy. |
Project
| Windows/Linux Keyboard Shortcuts | macOS Keyboard Shortcuts | Name | Description |
|---|---|---|---|
| Ctrl + B | ⌘Cmd + B | Build all projects | Build all projects. Starts compiling and building all projects in the workspace. Checks the correctness of the code and creates executable files. |
Oracle
| Windows/Linux Keyboard Shortcuts | macOS Keyboard Shortcuts | Name | Description |
|---|---|---|---|
| Ctrl + F9 | Ctrl + F9 | Compile | Compile an Oracle object. Compiles the selected Oracle object (procedure, function, trigger, view) in the database. Useful when changing PL/SQL source code. |
Utility
| Windows & Linux Keyboard Shortcuts | macOS Keyboard Shortcuts | Name | Description |
|---|---|---|---|
| Ctrl + ⇧Shift + C | Ctrl + ⇧Shift + C | Advanced Copy | Advanced data copying. Opens the advanced copy dialog with format settings: CSV, INSERT, JSON, and others. |
| Ctrl + Alt + ⇧Shift + C | Ctrl + Alt + ⇧Shift + C | Copy with settings | Copy data with settings in advanced copy. Copies data with pre-configured format and transformation parameters. |
| Ctrl + ⇧Shift + V | Ctrl + ⇧Shift + V | Advanced Paste | Advanced paste data. Opens an advanced paste dialog with data transformation settings from the clipboard. |
| Ctrl + Alt + Pg Up / Pg Dn | — | Switch tabs (Properties) | Switching tabs in the database object properties window. Switches between property tabs: General, Columns, Indexes, Constraints, SQL, and others. |
| Alt + Insert | ⌘Cmd + N | Create Object | Available in Database Navigator and Properties Editor. Opens a menu for creating a new database object: table, index, view, stored procedure, and other objects. |
Help
| Windows/Linux Hotkeys | macOS Hotkeys | Name | Description |
|---|---|---|---|
| F1 | F1 | Open documentation | Open DBeaver documentation. Opens the official DBeaver documentation with a detailed description of all features, configuration guide, and frequently asked questions. |