Reference

Keyboard shortcuts

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)macOSWhat it doesWhere
Ctrl+ICmd+IOpens and closes the AI Assistant panelThe project screen, when signed in or in a local project. Also works inside the SQL Editor and input fields
Ctrl+SCmd+SSaves the visible document tab (ERD, SQL, table)The project screen
Ctrl+SCmd+SSaves the template packThe 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)macOSWhat it does
Ctrl+PCmd+POpens the quick switcher. The previously viewed tab is selected at first, so Enter toggles between two tabs
Ctrl+Tab, Ctrl+Shift+TabCtrl+Tab, Ctrl+Shift+TabNext tab, previous tab. Wraps around at the ends
Ctrl+1 to Ctrl+8Cmd+1 to Cmd+8Goes to the tab in that position
Ctrl+9Cmd+9Goes to the last tab
Ctrl+WCmd+WCloses the visible tab. Middle-clicking a tab also closes it
↑, ↓, EnterChoose and open in the quick switcher

Project screen

KeyWhat it doesWhere
Ctrl (Cmd on macOS)+click, Shift+clickSelect several, select a rangeExplorer tree, ERD and SQL document lists. Ranges are selected only under the same parent
EnterOpens the selected itemObject list grid, SQL history cards
←, →Changes the width of the right panelWhen the right panel's border has focus
EscCloses the context menu of document tabsDocument 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.

Running and tools

Key (Windows)macOSWhat it does
Ctrl+EnterCmd+EnterRuns the selection, or the statement at the cursor if nothing is selected
Ctrl+Shift+EnterCmd+Shift+EnterRuns the selection, or the whole tab if nothing is selected, as a script
EscEscCloses the completion list if open, then the find bar if open, otherwise cancels the running query
Ctrl+Shift+ECmd+Shift+EShows the execution plan
Ctrl+Shift+FCmd+Shift+FFormats the selection, or the statement at the cursor. Formatting everything has no shortcut
F4F4Opens the table tab of the table name at the cursor
Ctrl+/Cmd+/Toggles a line comment

Completion and suggestions

Key (Windows)macOSWhat it does
Ctrl+SpaceCtrl+Space or Option+IOpens the completion list
↑, ↓, EnterChoose from the list and insert
TabTabAccepts 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)macOSWhat it does
Ctrl+FCmd+FOpens the find bar
Ctrl+RCmd+ROpens the find bar with the Replace field
Ctrl+G, Ctrl+Shift+GCmd+G, Cmd+Shift+GNext and previous match
Enter, Shift+EnterNext and previous in the find field. In the Replace field, Enter replaces one

Editing

Key (Windows)macOSWhat it does
Ctrl+ZCmd+ZUndo
Ctrl+YCmd+Shift+ZRedo
Tab, Shift+TabTab, Shift+TabIndent, 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+KCmd+Shift+KDeletes 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.

KeyWhat it does
Ctrl+C (Cmd+C on macOS)Copies the value of the focused cell
Ctrl (Cmd on macOS)+click, Shift+clickSelects several rows, or a range
Shift+click on a column headerSorts by several columns
Enter, F2, typingStarts editing a cell
Enter, EscApply or cancel a cell edit
Tab, Shift+TabApplies 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)macOSWhat it does
WheelWheel, trackpadMoves the canvas
Ctrl+wheelCmd+wheel, pinchZoom in and out
Alt+dragOption+dragWhile held, drags the canvas in Pan mode
Drag on empty spaceDrag on empty spaceSelects the tables inside the box
Ctrl+clickCmd+clickAdds a table to the selection or removes it, one at a time
EscEscReturns to select mode and clears what you copied
Ctrl+C, Ctrl+X, Ctrl+VCmd+C, Cmd+X, Cmd+VCopy, cut and paste the selected column rows, or the selected tables if no rows are selected. Tables are pasted at the mouse position
Delete, BackspaceDelete, BackspaceDeletes the selected column rows or relationship line; for tables, asks whether to remove them from the ERD
Ctrl+EnterCmd+EnterAdds a column from the header of the selected table; in a column grid, inserts a column below the focused row
Ctrl+SCmd+SSaves the ERD

Data dictionary and grid editing

KeyWhat it doesWhere
Ctrl+Enter (Cmd+Enter on macOS)Inserts a new row below the focused row and starts editingWord and domain grids, the column grid of the table editor
↓, ↑, Enter, Tab, EscOpen, move through, pick from and close the word suggestion listLogical name fields
Enter, EscApply, cancelEdit fields of the domain and dictionary panels

Described in Words, Domains and Table tab.

AI panel

Described in AI Assistant.

KeyWhat it does
EnterSends the message
Shift+EnterStarts a new line
↑, ↓When the input is empty, recalls the messages you sent in this chat one by one
Enter, SpaceOpens and selects a chat in the chat history list
Ctrl (Cmd on macOS)+click, Shift+clickSelects several chats, or a range, in the chat history
Shift+F10Opens the AI error menu when a SQL error has focus

Other screens

KeyWhat it doesWhere
Alt (Option on macOS)+arrow keysChanges a tile's width (←, →) and height (↑, ↓)Dashboards, when a tile has focus while editing
Ctrl+F, Ctrl+R (Cmd on macOS)Find, ReplaceThe body editor of Template packs
Ctrl+G, Ctrl+Shift+G (Cmd on macOS)Next and previous matchThe same editor
EnterPresses the confirm buttonMost input dialogs. In multi-line fields it starts a new line
EscCloses the dialogOnly 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.