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
- ⌘⇧F — Format SQL
- ⌘⌥? — Function help at the cursor
- F12 — Go to the definition of the object under the cursor
- ⌘-click on a word — Go to its definition, like F12
- ⌘⌥↑ / ⌘⌥↓ — Add a cursor on the line above or below
- ↑ with the cursor at the start of the text — Previous query in the history
- ↓ with the cursor at the end of the text — Next query in the history
- ⌃. — Fold the innermost parentheses at the cursor
- ⌃, — Unfold the parentheses at the cursor
- ⌃⇧B — Wrap the selection or the word in the engine's identifier quotes: backticks in MySQL and ClickHouse, double quotes in PostgreSQL, square brackets in SQL Server

Tabs
- ⌘T — New tab
- ⌘} — Next tab, as in Safari
- ⌘{ — Previous tab
- ⌘1 … ⌘9 — Go to tab 1 to 9
- ⌘⇧W — Close the active tab
- ⌘⇧T — Reopen the last closed tab, with its query

File, window and help
- ⌘O — Open an SQL file…
- ⌘⌥P — Capture an image
- ⌘⇧D — Disconnect
- ⌘P — Print…
- ⌘⌃S — Show or hide the sidebar
- ⌘⌥K — Keep awake: stop the Mac from sleeping while something long is running
- ⌘⌥I — Show or hide the schema panel of the SQL Editor
- ⌘⌥F — Filter the tools in the sidebar
- ⌘J — Move Focus to Editor: focus on the text of the SQL Editor, also from the sidebar
- ⌘? — Calíope Help

In the other tools
- ⌘↩ — Run, in Reports, in the SQLite Editor and in the MongoDB tools as well
- ⌘↩ — Apply in the Advanced Cell Editor, where ↩ types a line break
- ⌘. — 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
- ⌘J — Move Focus to Editor
- ⌘↩ — Run the query
- ⌘⇧↩ — Run the full script, every statement
- ⌘. — Stop
- ⌘⇧F — Format the SQL
- ⌘D — Toggle the comment on the line or the selection
- ⌘⇧O — Quick Open
- ⌘T — New tab
- ⌘⇧W — Close the active tab
- ⌘⇧T — Reopen the last closed tab, with its query
- ⌘] — Next tab
- ⌘[ — Previous tab
- ⌘1 … ⌘9 — Go to tab 1 to 9

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
- ⌘⌥↑ / ⌘⌥↓ — Add a cursor on the line above or below
- ↑ with the cursor at the start of the text — Previous query in the history
- ↓ with the cursor at the end of the text — Next query in the history
- ⌃. — Fold the innermost parentheses
- ⌃, — Unfold the parentheses
- ⌃⇧B — Wrap in the engine's identifier quotes
- Esc — Close the autocomplete popup

File and help
- ⌘O — Open an SQL file…
- ⌘⌥P — Capture an image
- ⌘⌃S — Show or hide the sidebar
- ⌘⌥K — Window › Keep Screen On
- ⌘? — Calíope Help

Tools — Tools menu

The menu shows one of three sets depending on the session in front of you, never two at once: the same keys open different things in a relational session, in a document session and in a Redis session.

Relational session
- ⌘⌥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
- ⌘⌥W — Slow Queries

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

Redis session
- ⌘⌥C — Key browser
- ⌘⌥S — Server panel
- ⌘⌥M — Memory analyzer
- ⌘⌥W — Slow commands
- ⌘⌥L — Connected clients
- ⌘⌥T — Command console
- ⌘⌥G — Node topology

What iPad does not have

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. Nor are there ⌘⇧D (Disconnect), ⌘P (Print…) or ⌘⌥? (Function help at the cursor).

The complete sheet — every shortcut on macOS and on iPad, generated from the code in every version — is at caliope.org/Shortcuts.html.

Apple Vision Pro with a keyboard: the iPad shortcuts in the previous section work the same. Holding ⌘ does not show the list: visionOS does not draw it.

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