Keyboard Shortcuts
Table of contents
Pharos
| Action | Shortcut |
|---|---|
| Settings… | Cmd+, |
| Settings: previous pane | Cmd+[ |
| Settings: next pane | Cmd+] |
| Hide Pharos | Cmd+H |
| Hide Others | Cmd+Opt+H |
| Quit Pharos | Cmd+Q |
The app’s own Settings ▸ Shortcuts pane lists every one of these at run time, with a search field. To change one, use System Settings ▸ Keyboard ▸ Keyboard Shortcuts ▸ App Shortcuts and enter the menu command’s exact title.
File
| Action | Shortcut |
|---|---|
| Manage Connections… (opens the Connections Manager window) | Cmd+Shift+N |
| Connect | Control+Cmd+K |
| Refresh Metadata | Cmd+Shift+R |
| Open… (SQL file) | Cmd+O |
| New Window | Cmd+N |
| New Tab | Cmd+T |
| Close Tab | Cmd+W |
| Reopen Closed Tab | Cmd+Shift+T |
| Rename Tab… | Cmd+Opt+R |
| Save Session… | Cmd+S |
| Export Query as SQL File… | Cmd+Opt+S |
| Close Window (every tab of the window) | Cmd+Shift+W |
Edit
| Action | Shortcut |
|---|---|
| Undo (also adding, deleting or renaming a card) | Cmd+Z |
| Redo | Cmd+Shift+Z |
| Cut / Copy / Paste | Cmd+X / Cmd+C / Cmd+V |
| Select All | Cmd+A |
| Find… (all cards of the tab, or the results grid when it has focus) | Cmd+F |
| Find and Replace… (all cards of the tab) | Cmd+Option+F |
| Find Next | Cmd+G |
| Find Previous | Cmd+Shift+G |
| Use Selection for Find | Cmd+E |
| Jump to Selection | Cmd+J |
| Filter Results… | Cmd+Shift+F |
Query
| Action | Shortcut |
|---|---|
| Run Card (the focused card) | Cmd+Return |
| Run and Replace Results | Cmd+Shift+Return |
| Run All Cards | Cmd+Opt+Return |
| Cancel Query | Cmd+. |
| Cancel All Queries | Cmd+Opt+. |
| Explain Query | Cmd+Shift+E |
| Explain Analyze Query | Cmd+Opt+Shift+E |
| Format SQL | Ctrl+I |
| New Card | Ctrl+Cmd+N |
| Previous Card | Ctrl+Cmd+Up |
| Next Card | Ctrl+Cmd+Down |
View
| Action | Shortcut |
|---|---|
| Show / Hide Sidebar | Cmd+Ctrl+S |
| Show / Hide Inspector | Cmd+Opt+I |
| Library navigator (Sessions and Results History) | Cmd+Opt+1 |
| Files navigator | Cmd+Opt+2 |
| Database Navigator | Cmd+Opt+3 |
| Filter in Navigator | Cmd+Opt+J |
| Switch to Tab 1–9 | Cmd+1 through Cmd+9 |
| Show Next Tab | Cmd+Shift+] (or Ctrl+Tab) |
| Show Previous Tab | Cmd+Shift+[ (or Ctrl+Shift+Tab) |
| Show All Tabs | Cmd+Shift+\ |
| Show Results of Next Card | Cmd+Opt+] |
| Show Results of Previous Card | Cmd+Opt+[ |
| Increase Editor Font | Cmd++ |
| Decrease Editor Font | Cmd+- |
Window
| Action | Shortcut |
|---|---|
| Minimize | Cmd+M |
Help
| Action | Shortcut |
|---|---|
| Pharos Help | Cmd+? |
In the Editor
| Action | Key |
|---|---|
| Trigger auto-completion | Ctrl+Space |
| Navigate completion list | Up / Down |
| Accept completion | Return or Tab |
| Dismiss completion | Escape |
| Indent selection | Tab (with multi-line selection) |
| Outdent | Shift+Tab |
| Apply “Format as SQL list” offer | Tab |
| Dismiss “Format as SQL list” offer | Escape |
In the Manager Windows
The Connections Manager, the Variable Manager and the Tag Manager are windows of their own.
| Action | Key |
|---|---|
| Close the window (asks first when there are unsaved edits) | Cmd+W. In the Connections Manager and the Tag Manager, also Escape when no control uses it |
| Delete the selected row | Delete or Forward Delete (alone or with Cmd), or Edit > Delete |
| Save (Connections Manager, Tag Manager) | Return |
| Find a row by its name | Type its first letters in the sidebar |
In the Results Grid
| Action | Key |
|---|---|
| Copy selection as TSV | Cmd+C |
| Quick Look the selected cells | Space |
| Extend row selection | Shift+click (range), Cmd+click (toggle) |
| Move active cell | Arrow keys |
| Extend cell selection | Shift+arrows |
| Step between cells | Tab / Return |
| Clear selection (or close find bar) | Escape |
| Navigate find matches | Enter / Shift+Enter |
Editing a Cell
Only on an editable cell — see Editing Cells.
| Action | Key |
|---|---|
| Start editing the active cell | Cmd+Return (or double-click) |
| Commit and move down a row | Return |
| Commit and move right a column | Tab |
| Commit and move left a column | Shift+Tab |
| Abandon the edit | Escape |
In a Chart
| Action | Key |
|---|---|
| Toggle item in selection | Cmd+click |
| Extend selection from anchor | Shift+click |
| Clear staged selection | Escape |