Keyboard basics

The default shortcuts worth learning first, and how to change them in Preferences > Keymap.

Almost every action in Oxys DB Studio has a keyboard shortcut, and you can change any of them. The shortcuts below are the defaults on Windows and Linux.

The essentials

ShortcutActionAlso in
Ctrl+NOpen the Connection ManagerGlobal Toolbar > Connect
Ctrl+LOpen IntelliShellGlobal Toolbar > IntelliShell
Shift+Ctrl+LOpen a SQL Query tabGlobal Toolbar > SQL
F4Open the Aggregation EditorGlobal Toolbar > Aggregate
Ctrl+MOpen Map-Reduce
Ctrl+BShow or hide the Visual Query BuilderCollection Tab toolbar
Ctrl+GOpen Query CodeCollection Tab > Query Code
Ctrl+RRefresh the current viewResult toolbar
Ctrl+PPreferencesEdit > Preferences
Ctrl+Alt+BShow or hide the Global ToolbarView > Show/Hide Global Toolbar
F1Help for the current viewHelp > Help for This View

Tabs

ShortcutAction
Ctrl+PgDnNext tab
Ctrl+PgUpPrevious tab
Ctrl+F4Close the tab (asks first if it holds unsaved work)
Shift+Ctrl+F4Close the tab without asking

Results and documents

ShortcutAction
Ctrl+Alt+1Switch to Tree View
Ctrl+Alt+2Switch to Table View
Ctrl+Alt+3Switch to JSON View
F5Run the query of the query bar
Ctrl+Alt+Left / Ctrl+Alt+RightPrevious / next page
F3View the selected document
Ctrl+JEdit the selected document as JSON
Ctrl+DInsert a document
F2Edit the selected field in place
Ctrl+EEdit Value / Type (the dialog, with the type)
Ctrl+KAdd a field or value
Shift+DelDelete the selected document (asks first)
Ctrl+CCopy the selected value as text
Shift+Ctrl+CCopy the whole document
Ctrl+Shift+RReload the selected document from the server

See Editing documents and Copy and paste for the rest.

Editors and scripts

ShortcutAction
F5Run the whole script (IntelliShell), pipeline (Aggregation Editor) or statement (SQL Query)
F6Run the statement at the cursor (IntelliShell)
F9Run the selection (IntelliShell)
Ctrl+SpaceOpen auto-completion
Ctrl+F / Ctrl+HFind / Replace
Ctrl+/Comment or uncomment the line
Ctrl+Alt+LFormat the code
Ctrl+S / Shift+Ctrl+SSave / Save as
Ctrl+OLoad a saved query or script

In the connection tree

ShortcutAction
EnterOpen the selected collection, view or GridFS bucket
Ctrl+FSearch the open connections
Ctrl+RRefresh the selected item
Shift+Ctrl+RRefresh everything
Ctrl+Alt+DDisconnect

Change a shortcut

  1. Open Edit > Preferences (Ctrl+P) and choose the Keymap page.
  2. Find the action: type part of its name in the search field, or browse the categories.
  3. Click Add shortcut, then press the key combination you want. An action can have up to three shortcuts of your own.
  4. To go back, select the action and click Reset shortcuts, or Reset all for every action.
Keymap buttonWhat it does
Add shortcutAdds a key combination to the selected action
Remove all shortcutsRemoves every shortcut of the selected action
Reset shortcutsRestores the defaults of the selected action
Remove allRemoves every shortcut of every action
Reset allRestores every default shortcut
Export keymap…, Import keymap…Save your keymap to a file, or load one, for example to use the same keys on another computer

Tips

  • Hover any Global Toolbar button to see its shortcut; menu items show theirs next to the label.
  • The same key can do different things depending on where the keyboard focus is: Ctrl+C copies a value in the result views but copies the collection when the tree has the focus.
  • The keymap already defines macOS bindings (with ⌘ in place of Ctrl), but there is no macOS build yet; see Install.
  • In the browser version, the browser keeps a few shortcuts for its own windows and tabs (Ctrl+N, Ctrl+T, Ctrl+W, Ctrl+PgDn…): Alt+N, Alt+T, Alt+W, Alt+PgDn… replace them there, and the menus and the Keymap page show them. See Use Oxys DB Studio in a browser.