| Connections and SQL scripts |
|---|
| Open the object editor | F4 | F4 | F4 |
| Open the Connect to a database window | Ctrl Shift N | Ctrl Shift N | Ctrl Shift N |
| Open the database meta-object | Ctrl Shift D | Ctrl Shift D | Ctrl Shift D |
| Open a new SQL console | Ctrl Alt Enter | Ctrl Option Return | Ctrl Alt Enter |
| Create a new SQL script | Ctrl ] | Ctrl ] | Ctrl ] |
| Open an existing SQL script | F3 | F3 | F3 |
| Open the most recent SQL script | Ctrl Enter | Cmd Return | Ctrl Enter |
| Commit the current session | Ctrl Alt Shift K | Ctrl 4 | Ctrl Alt Shift K |
| Show the database tools context menu | Alt ` | Ctrl V | Alt ` |
| Generate and insert a UUID or GUID | Ctrl Alt Shift U | Ctrl Option Shift U | Ctrl Alt Shift U |
| Open the database dashboard | Ctrl Alt Shift B | Ctrl Option Shift B | Ctrl Alt Shift B |
| Roll back the current session | Ctrl Alt Shift R | Ctrl 8 | Ctrl Alt Shift R |
| Select the active schema | Ctrl 0 | Ctrl 0 | Ctrl 0 |
| Select the connection for the current editor | Ctrl 9 | Ctrl 9 | Ctrl 9 |
| Result sets |
|---|
| Add a new row | Alt Insert | Option Insert | Alt Insert |
| Copy values from the row above | Ctrl D | Ctrl D | Ctrl D |
| Copy values from the row below | Ctrl Alt D | Ctrl Option D | Ctrl Alt D |
| Delete the current row | Alt Delete | Option Delete | Alt Delete |
| Duplicate the current row | Ctrl Alt Insert | Ctrl Option Insert | Ctrl Alt Insert |
| Edit the cell value inline | Enter | Return | Enter |
| Reset the cell to its original value | Esc | Esc | Esc |
| Apply data changes | Ctrl S | Ctrl S | Ctrl S |
| Focus the filter editor or data editor | Ctrl Alt Shift T | Ctrl Option Shift T | Ctrl Alt Shift T |
| Switch focus to the results viewer or active panel | Ctrl Shift 7 | Ctrl Shift 7 | Ctrl Shift 7 |
| Switch focus between the Grid view and Value panel | Ctrl Tab | Ctrl Tab | Ctrl Tab |
| Apply cell changes | Ctrl Alt Shift Enter | Ctrl Option Shift Return | Ctrl Alt Shift Enter |
| Edit a cell in a separate editor | Shift Enter | Shift Return | Shift Enter |
| Fetch all rows | Ctrl Shift = | Ctrl Shift = | Ctrl Shift = |
| Fetch the next page of results | Ctrl Alt N | Ctrl Option N | Ctrl Alt N |
| Filter by unique attribute values | Ctrl F11 | Ctrl F11 | Ctrl F11 |
| Open the filter context menu | F11 | F11 | F11 |
| Move to the first row | Ctrl Alt Shift Left | Ctrl Option Shift Left | Ctrl Alt Shift Left |
| Move to the last row | Ctrl Alt Shift Right | Ctrl Option Shift Right | Ctrl Alt Shift Right |
| Show foreign keys and referencing tables | Ctrl Shift 1 | Ctrl Shift 1 | Ctrl Shift 1 |
| Reject data changes | Ctrl R | Ctrl R | Ctrl R |
| Set the cell to its default value | Ctrl Backspace | Ctrl Backspace | Ctrl Backspace |
| Switch result presentation | Ctrl ` | Ctrl ` | Ctrl ` |
| Toggle Grid and Record view | Tab | Tab | Tab |
| Toggle result panels | F7 | F7 | F7 |
| Cycle result sort order | Ctrl 2 | Ctrl 2 | Ctrl 2 |
| Data and text editors |
|---|
| Add a row before the current row | Shift Alt Insert | Shift Option Insert | Shift Alt Insert |
| Duplicate a row before the current row | Ctrl Shift Alt Insert | Ctrl Shift Option Insert | Ctrl Shift Alt Insert |
| Enable autocomplete | Ctrl Space | Ctrl Space | Ctrl Space |
| Find and replace text | Ctrl F | Cmd F | Ctrl F |
| Show context information | Ctrl Shift Space | Ctrl Shift Space | Ctrl Shift Space |
| Show SQL editor context information | Ctrl Alt Space | Ctrl Option Space | Ctrl Alt Space |
| Cut the selection | Ctrl X | Cmd X | Ctrl X |
| Copy the selection | Ctrl C | Cmd C | Ctrl C |
| Paste from the clipboard | Ctrl V | Cmd V | Ctrl V |
| Delete the selection | Delete | Delete | Delete |
| Export a diagram | Ctrl O | Cmd O | Ctrl O |
| Find the next item | Ctrl K | Cmd K | Ctrl K |
| Find the previous item | Ctrl Shift K | Shift Cmd K | Ctrl Shift K |
| Start incremental find | Ctrl J | Cmd J | Ctrl J |
| Start reverse incremental find | Ctrl Shift J | Shift Cmd J | Ctrl Shift J |
| Toggle quick diff information | Ctrl Shift Q | Ctrl Shift Q | Ctrl Shift Q |
| Suggest possible fixes | Ctrl 1 | Cmd 1 | Ctrl 1 |
| Redo the last operation | Ctrl Y | Shift Cmd Z | Ctrl Y |
| Undo the last operation | Ctrl Z | Cmd Z | Ctrl Z |
| Change the selection to lowercase | Ctrl Shift Y | Shift Cmd Y | Ctrl Shift Y |
| Change the selection to uppercase | Ctrl Shift X | Shift Cmd X | Ctrl Shift X |
| Delete the line at the caret | Ctrl D | Cmd D | Ctrl D |
| Delete the next word | Ctrl Delete | Option Delete | Ctrl Delete |
| Delete the previous word | Ctrl Backspace | Option Backspace | Ctrl Backspace |
| Duplicate selected lines downward | Ctrl Alt Down | Option Cmd Down | Ctrl Alt Down |
| Duplicate selected lines upward | Ctrl Alt Up | Option Cmd Up | Ctrl Alt Up |
| Add a line above the current line | Ctrl Shift Enter | Shift Cmd Return | Ctrl Shift Enter |
| Add a line below the current line | Shift Enter | Shift Return | Shift Enter |
| Go to the end of the line | End | Cmd Right | End |
| Go to the start of the line | Home | Cmd Left | Home |
| Move selected lines down | Alt Down | Ctrl Shift Down | Alt Down |
| Move selected lines up | Alt Up | Ctrl Shift Up | Alt Up |
| Show information at the caret | F2 | F2 | F2 |
| Go to the end of the text | Ctrl End | Cmd Down | Ctrl End |
| Go to the beginning of the text | Ctrl Home | Cmd Up | Ctrl Home |
| Zoom in text | Ctrl + | Cmd + | Ctrl + |
| Zoom out text | Ctrl - | Cmd - | Ctrl - |
| Search and window navigation |
|---|
| Open the Search dialog | Ctrl H | Ctrl H | Ctrl H |
| Search workspace files for text | Ctrl Alt G | Option Cmd G | Ctrl Alt G |
| Activate the editor | F12 | Cmd F12 | F12 |
| Find actions | Ctrl 3 | Cmd 3 | Ctrl 3 |
| Maximize or restore the active view or editor | Ctrl M | Ctrl M | Ctrl M |
| Switch to the next editor | Ctrl F6 | Cmd F6 | Ctrl F6 |
| Switch to the next perspective | Ctrl F8 | Cmd F8 | Ctrl F8 |
| Switch to the next view | Ctrl F7 | Cmd F7 | Ctrl F7 |
| Switch to the previous editor | Ctrl Shift F6 | Shift Cmd F6 | Ctrl Shift F6 |
| Switch to the previous perspective | Ctrl Shift F8 | Shift Cmd F8 | Ctrl Shift F8 |
| Switch to the previous view | Ctrl Shift F7 | Shift Cmd F7 | Ctrl Shift F7 |
| Open the editor drop-down list | Ctrl E | Cmd E | Ctrl E |
| Show the context menu | Shift F10 | Shift F10 | Shift F10 |
| Show the key assist dialog | Ctrl Shift L | Shift Cmd L | Ctrl Shift L |
| Show the ruler context menu | Ctrl F10 | Cmd F10 | Ctrl F10 |
| Toggle full-screen mode | Alt F11 | Ctrl Cmd F | Alt F11 |
| Files, projects, and run controls |
|---|
| Rename the selected item | F2 | F2 | F2 |
| Refresh selected items | F5 | F5 | F5 |
| Save the current file | Ctrl S | Cmd S | Ctrl S |
| Save all open files | Ctrl Shift S | Shift Cmd S | Ctrl Shift S |
| Close the active editor | Ctrl F4 | Cmd W | Ctrl F4 |
| Close all editors | Ctrl Shift F4 | Shift Cmd W | Ctrl Shift F4 |
| Open the New item wizard | Ctrl N | Cmd N | Ctrl N |
| Open the New menu | Alt Shift N | Option Cmd N | Alt Shift N |
| Open a file | Ctrl O | Ctrl O | Ctrl O |
| Print | Ctrl P | Cmd P | Ctrl P |
| Display selected item properties | Alt Enter | Cmd I | Alt Enter |
| Launch in debug mode | F11 | Cmd F11 | F11 |
| Launch in run mode | Ctrl F11 | Shift Cmd F11 | Ctrl F11 |
| Step into while debugging | F5 | F5 | F5 |
| Step over while debugging | F6 | F6 | F6 |
| Step return while debugging | F7 | F7 | F7 |
| Resume while debugging | F8 | F8 | F8 |
| Terminate the debug session | Ctrl F2 | Cmd F2 | Ctrl F2 |
| Create or remove a breakpoint | Ctrl Shift B | Shift Cmd B | Ctrl Shift B |
| Build all projects | Ctrl B | Cmd B | Ctrl B |
| Open the documentation | F1 | F1 | F1 |