Keyboard Shortcuts

Quick reference for Calíope's shortcuts. The Mac and the touch devices do not share the same set: they are listed separately, and what iPad lacks is at the end.

Where it is: Keyboard shortcut: Ver tabla completa

macOS

SQL Editor — toolbar
- ⌘↩ — Run the query, or the selection if there is one
- ⌘⇧↩ — Run the full script, every statement
- ⌘. — Stop the running execution (the button is only there while something runs)
- ⌘F — Find and replace inside the editor
- ⌘⇧M — Insert a saved snippet
- ⌘⇧O — Quick Open, the schema object search palette

SQL Editor — with focus inside the text
- ⌘↩ — Run, from here too
- ⌘N — Open the autocomplete popup
- ⌘D — Toggle the comment on the line or the selection
- F12 — Go to the definition of the object under the cursor
- ⌃. — Fold the innermost parentheses at the cursor
- ⌃, — Unfold the parentheses at the cursor
- ⌃⇧B — Wrap the selection or the word in backticks (`)

Tabs
- ⌘T — New tab
- ⌘] — Next tab
- ⌘[ — Previous tab

File, window and help
- ⌃⌥O — Open an SQL file…
- ⌘⌥P — Capture an image
- ⌃⌥C — Keep awake: stop the Mac from sleeping while something long is running
- ⌘? — Calíope Help

In the other tools
- ⌘↩ — Run, in Reports, in the SQLite Editor and in the MongoDB tools as well
- ⌘. — Stop a running report, when its source allows cancelling
- ⌘F, ⌘G and ⌘⇧G — Find, next match and previous match in the Previewer; Esc closes the search bar
- Esc — Leave the Dashboard's TV mode

In any sheet or dialog, ↩ confirms and Esc cancels.

iPad with Magic Keyboard

iPad does not inherit the Mac's shortcuts: it has its own menu bar and its own set. What it lacks is at the end of this section.

SQL Editor — Editor menu
- ⌘↩ — Run the query
- ⌘⇧F — Format the SQL
- ⌘D — Toggle the comment on the line or the selection
- ⌘↑ — Previous query in the history
- ⌘↓ — Next query in the history
- ⌘⇧O — Quick Open
- ⌘T — New tab
- ⌘⇧W — Close the active tab
- ⌘] — Next tab
- ⌘[ — Previous tab

SQL Editor — with focus inside the text
- ⌘N — Open the autocomplete popup
- ⌘⇧E — Expand the asterisk into the column list
- ⌘⇧M — Turn column editing on or off
- ⌃. — Fold the innermost parentheses
- ⌃, — Unfold the parentheses
- ⌃⇧B — Wrap in backticks (`)
- Esc — Close the autocomplete popup

File and help
- ⌃⌥O — Open an SQL file…
- ⌘⌥P — Capture an image
- ⌘? — Calíope Help

Tools — Tools menu

The menu shows one set or the other depending on the session in front of you, never both at once: the same keys open different things in a relational session and in a document session.

Relational session (MySQL / MariaDB)
- ⌘⌥T — SQL Editor
- ⌘⌥A — Dashboard
- ⌘⌥I — AI Assistant
- ⌘⌥C — Catalogs
- ⌘⌥S — Server Info
- ⌘⌥M — SQL Alerts
- ⌘⌥R — Backup
- ⌘⌥U — User Administration
- ⌘⌥N — Table Maintenance
- ⌘⌥B — Object Migration
- ⌘⌥G — ER Diagram
- ⌘⌥L — SQL Log

Document session (MongoDB)
- ⌘⌥C — Collection browser
- ⌘⌥F — Queries
- ⌘⌥I — Indexes
- ⌘⌥A — Administration
- ⌘⌥T — Commands

What iPad does not have

⌘⇧↩ (run the full script), ⌘. (stop), F12 (go to definition) and ⌘F inside the editor do not exist on iPad. And ⌘⇧M does not mean the same thing on the two: on the Mac it inserts a snippet, on iPad it turns column editing on.

Keywords: shortcuts, keyboard, hotkey, keybinding, magic keyboard, ipad, macos, backtick, fold, unfold, autocomplete, quick open, screenshot, tabs, tools, keep awake, column editing, expand asterisk, previewer, mongodb, F12, ⌘T, ⌘., ⌘N, ⌃., ⌘⇧M, ⌘⇧E, ⌘⌥T, ⌘⌥A, ⌘⇧O