Reference
Shortcuts and menus
All of Qrulla's keyboard shortcuts and what's in each menu.
On a Mac, use ⌘ where it says Ctrl.
Shortcuts
General
| Shortcut | Action |
|---|---|
| Ctrl+T | New query on what's picked in the tree |
| Ctrl+, | Preferences |
| Ctrl+= / Ctrl+- / Ctrl+0 | Zoom in, zoom out and actual size |
| F11 (Mac: Ctrl+⌘+F) | Full screen |
| Ctrl+Q | Quit Qrulla |
| Esc | Close a dialog or a menu |
Tree and objects panel
| Shortcut | Action |
|---|---|
| Ctrl+F | Search the tree |
| Enter or double-click | Connect, open a table or an object |
| F2 | Edit the picked connection |
| Ctrl+C | Copy the picked objects |
| Ctrl+V | Paste them into the picked database or schema |
| Ctrl+A | Pick all (objects panel) |
| Del | Drop the picked ones (with confirmation) |
| F5 | Refresh |
SQL editor
| Shortcut | Action |
|---|---|
| Ctrl+R | Run the selection or the current statement |
| Ctrl+Shift+R | Run everything |
| Ctrl+Enter | Run the selection or everything |
| Ctrl+Shift+Enter | Run the current statement |
| Ctrl+Shift+F | Format |
| Ctrl+Shift+E | Execution plan |
| Ctrl+S | Save the query |
Data grid
| Shortcut | Action |
|---|---|
| Ctrl+S | Save the changes |
| F5 | Read the rows again |
| Ctrl+F | Search the loaded rows |
| Ctrl+Z | Undo a cell's last change |
| Ctrl+Del | Delete the row |
| Ctrl+C / Ctrl+V | Copy and paste cells |
| Ctrl+A | Pick every cell |
| Enter / Esc | Confirm or cancel a cell's edit |
Menus
On Windows and Linux:
| Menu | Options |
|---|---|
| File | New connection…, New group…, New query, New query across connections, Export connections…, Import connections…, Close tab, Preferences…, Quit Qrulla |
| Edit | Undo, Redo, Cut, Copy, Paste, Select all, Search the tree |
| View | Home, Zoom in, Zoom out, Actual size, Switch light / dark theme, Full screen |
| Window | Minimize |
| Help | Check for updates…, License and account…, About Qrulla |
On a Mac, “About Qrulla”, “Check for updates…”, “License and account…”, “Preferences…” and “Quit” are in the Qrulla menu.
The tree's context menu
Right-click shows what can be done with each thing:
- Connection: Connect or Disconnect, New query, New database…, Refresh, Sessions and performance (or Manage ASM), Run SQL file…, Edit, Duplicate, Color, Move to group…, Delete.
- Database or schema: New query, New schema…, New object, Copy all, Paste, Back up…, Show backups, Import file…, Run SQL file…, Export tables…, Export SQL…, ER diagram, Design query, Compare…, Structure history…, Suggest indexes…, Test data….
- Table: View data, Design, New query, Copy, Duplicate here, Import file…, Export SQL…, View SQL, Rename…, Empty, Truncate, Maintenance, Drop….
- Group: New group…, Rename group…, Delete group… (its connections are left outside the group, not deleted).
What your plan doesn't include doesn't appear, or tells you which plan has it.
Something missing or unclear? Write to support@qrulla.com.