This page collects NeoSQL's keyboard shortcuts by screen. What each shortcut does is described in detail on the linked screen pages. When the macOS column of a table is not empty, use that key on macOS. Key names refer to a US English keyboard.
Whole app
| Key (Windows) | macOS | What it does | Where |
|---|
Ctrl+I | Cmd+I | Opens and closes the AI Assistant panel | The project screen, when signed in or in a local project. Also works inside the SQL Editor and input fields |
Ctrl+S | Cmd+S | Saves the visible document tab (ERD, SQL, table) | The project screen |
Ctrl+S | Cmd+S | Saves the template pack | The template pack management screen, when there are changes |
On macOS, Ctrl+I also works. See App menu, top bar and status bar and AI Assistant for details.
Work tabs
Desktop app only. They do not work while a dialog or popup is open. Even when pressed inside the SQL Editor or a grid, the work tab shortcuts come first. Described in Work tabs.
| Key (Windows) | macOS | What it does |
|---|
Ctrl+P | Cmd+P | Opens the quick switcher. The previously viewed tab is selected at first, so Enter toggles between two tabs |
Ctrl+Tab, Ctrl+Shift+Tab | Ctrl+Tab, Ctrl+Shift+Tab | Next tab, previous tab. Wraps around at the ends |
Ctrl+1 to Ctrl+8 | Cmd+1 to Cmd+8 | Goes to the tab in that position |
Ctrl+9 | Cmd+9 | Goes to the last tab |
Ctrl+W | Cmd+W | Closes the visible tab. Middle-clicking a tab also closes it |
↑, ↓, Enter | | Choose and open in the quick switcher |
Project screen
| Key | What it does | Where |
|---|
Ctrl (Cmd on macOS)+click, Shift+click | Select several, select a range | Explorer tree, ERD and SQL document lists. Ranges are selected only under the same parent |
Enter | Opens the selected item | Object list grid, SQL history cards |
←, → | Changes the width of the right panel | When the right panel's border has focus |
Esc | Closes the context menu of document tabs | Document tabs |
Described in Object explorer and Project screen layout.
SQL Editor
Described in SQL editor. The editor's keyboard icon menu also lists the main shortcuts.
| Key (Windows) | macOS | What it does |
|---|
Ctrl+Enter | Cmd+Enter | Runs the selection, or the statement at the cursor if nothing is selected |
Ctrl+Shift+Enter | Cmd+Shift+Enter | Runs the selection, or the whole tab if nothing is selected, as a script |
Esc | Esc | Closes the completion list if open, then the find bar if open, otherwise cancels the running query |
Ctrl+Shift+E | Cmd+Shift+E | Shows the execution plan |
Ctrl+Shift+F | Cmd+Shift+F | Formats the selection, or the statement at the cursor. Formatting everything has no shortcut |
F4 | F4 | Opens the table tab of the table name at the cursor |
Ctrl+/ | Cmd+/ | Toggles a line comment |
Completion and suggestions
| Key (Windows) | macOS | What it does |
|---|
Ctrl+Space | Ctrl+Space or Option+I | Opens the completion list |
↑, ↓, Enter | | Choose from the list and insert |
Tab | Tab | Accepts the suggestion shown in faint text. Without one, inserts the list item, and without that, indents |
→ | → | Accepts the faint suggestion at the end of a line |
Find and replace
| Key (Windows) | macOS | What it does |
|---|
Ctrl+F | Cmd+F | Opens the find bar |
Ctrl+R | Cmd+R | Opens the find bar with the Replace field |
Ctrl+G, Ctrl+Shift+G | Cmd+G, Cmd+Shift+G | Next and previous match |
Enter, Shift+Enter | | Next and previous in the find field. In the Replace field, Enter replaces one |
Editing
| Key (Windows) | macOS | What it does |
|---|
Ctrl+Z | Cmd+Z | Undo |
Ctrl+Y | Cmd+Shift+Z | Redo |
Tab, Shift+Tab | Tab, Shift+Tab | Indent, outdent |
Ctrl+[, Ctrl+] | Cmd+[, Cmd+] | Outdent, indent the line |
Alt+↑, Alt+↓ | Option+↑, Option+↓ | Moves the line up or down |
Shift+Alt+↑, Shift+Alt+↓ | Shift+Option+↑, Shift+Option+↓ | Copies the line up or down |
Ctrl+Shift+K | Cmd+Shift+K | Deletes the line |
Ctrl+Alt+↑, Ctrl+Alt+↓ | Cmd+Option+↑, Cmd+Option+↓ | Adds a cursor on the line above or below |
Ctrl+Shift+[, Ctrl+Shift+] | Cmd+Option+[, Cmd+Option+] | Fold, unfold |
Result grid
Described in Result grid and Editing result data.
| Key | What it does |
|---|
Ctrl+C (Cmd+C on macOS) | Copies the value of the focused cell |
Ctrl (Cmd on macOS)+click, Shift+click | Selects several rows, or a range |
Shift+click on a column header | Sorts by several columns |
Enter, F2, typing | Starts editing a cell |
Enter, Esc | Apply or cancel a cell edit |
Tab, Shift+Tab | Applies the cell edit and edits the next or previous cell |
Ctrl+Enter (Cmd+Enter on macOS) | Applies the filter in the WHERE filter input |
ERD canvas
Works when the mouse is over the canvas or after you click the canvas. It does not work while you edit an input field or a dialog is open, and on a locked ERD only Esc works. Described in ERD canvas and Table node.
| Key (Windows) | macOS | What it does |
|---|
| Wheel | Wheel, trackpad | Moves the canvas |
Ctrl+wheel | Cmd+wheel, pinch | Zoom in and out |
Alt+drag | Option+drag | While held, drags the canvas in Pan mode |
| Drag on empty space | Drag on empty space | Selects the tables inside the box |
Ctrl+click | Cmd+click | Adds a table to the selection or removes it, one at a time |
Esc | Esc | Returns to select mode and clears what you copied |
Ctrl+C, Ctrl+X, Ctrl+V | Cmd+C, Cmd+X, Cmd+V | Copy, cut and paste the selected column rows, or the selected tables if no rows are selected. Tables are pasted at the mouse position |
Delete, Backspace | Delete, Backspace | Deletes the selected column rows or relationship line; for tables, asks whether to remove them from the ERD |
Ctrl+Enter | Cmd+Enter | Adds a column from the header of the selected table; in a column grid, inserts a column below the focused row |
Ctrl+S | Cmd+S | Saves the ERD |
Data dictionary and grid editing
| Key | What it does | Where |
|---|
Ctrl+Enter (Cmd+Enter on macOS) | Inserts a new row below the focused row and starts editing | Word and domain grids, the column grid of the table editor |
↓, ↑, Enter, Tab, Esc | Open, move through, pick from and close the word suggestion list | Logical name fields |
Enter, Esc | Apply, cancel | Edit fields of the domain and dictionary panels |
Described in Words, Domains and Table tab.
AI panel
Described in AI Assistant.
| Key | What it does |
|---|
Enter | Sends the message |
Shift+Enter | Starts a new line |
↑, ↓ | When the input is empty, recalls the messages you sent in this chat one by one |
Enter, Space | Opens and selects a chat in the chat history list |
Ctrl (Cmd on macOS)+click, Shift+click | Selects several chats, or a range, in the chat history |
Shift+F10 | Opens the AI error menu when a SQL error has focus |
Other screens
| Key | What it does | Where |
|---|
Alt (Option on macOS)+arrow keys | Changes a tile's width (←, →) and height (↑, ↓) | Dashboards, when a tile has focus while editing |
Ctrl+F, Ctrl+R (Cmd on macOS) | Find, Replace | The body editor of Template packs |
Ctrl+G, Ctrl+Shift+G (Cmd on macOS) | Next and previous match | The same editor |
Enter | Presses the confirm button | Most input dialogs. In multi-line fields it starts a new line |
Esc | Closes the dialog | Only dialogs that allow closing. Some, such as the Data Export... dialog, do not close |
Things to keep in mind
- On macOS,
Cmd+Space is usually taken by Spotlight first. Use Ctrl+Space for completion, or Option+I if Ctrl+Space switches your input source. - Letter shortcuts (
Ctrl+S, Ctrl+C in the result grid, Ctrl+C, Ctrl+X, Ctrl+V on the ERD and so on) work even while the input language is Korean (macOS) or Caps Lock is on. - When there are more than 9 tabs,
Ctrl+9 (Cmd+9 on macOS) goes to the last tab, not the 9th. Hovering over a tab shows the key that goes to it.