Skip to main content

​
Keyboard Shortcuts

TablePro supports extensive keyboard shortcuts to help you work faster without reaching for the mouse. Learn these shortcuts to significantly speed up your database workflow.

​
Quick Reference

​
Essential Shortcuts

ActionShortcut
Execute queryCmd+Enter
New connectionCmd+N
Open historyCmd+Y
SettingsCmd+,
Close windowCmd+W
QuitCmd+Q

​
SQL Editor

​
Query Execution

ActionShortcutDescription
Execute queryCmd+EnterRun query at cursor, or all selected statements sequentially
Explain queryOption+Cmd+EShow execution plan for query at cursor
Cmd+Enter is the most important shortcut. It runs the query your cursor is in, or executes only the selected text. If your selection contains multiple statements, they are executed sequentially within a transaction.

​
Text Editing

ActionShortcut
Select allCmd+A
CutCmd+X
CopyCmd+C
PasteCmd+V
UndoCmd+Z
RedoCmd+Shift+Z
Delete lineCmd+Shift+K
Duplicate lineCmd+Shift+D
ActionShortcut
Go to lineCmd+Shift+L
Go to beginningCmd+Up
Go to endCmd+Down
Move line upOption+Up
Move line downOption+Down

​
Find and Replace

ActionShortcut
FindCmd+F
Find and replaceCmd+Option+F
Find nextCmd+G
Find previousCmd+Shift+G

​
Selection

ActionShortcut
Select wordCmd+D
Select lineCmd+L
Expand selectionCmd+Shift+Right
Shrink selectionCmd+Shift+Left

​
Data Grid

ActionShortcut
Move between cellsArrow keys
Next cellTab
Previous cellShift+Tab
First cell in rowHome
Last cell in rowEnd
First rowCmd+Home
Last rowCmd+End
Page upPage Up
Page downPage Down

​
Editing

ActionShortcut
Edit cellEnter or F2
Cancel editEscape
Delete rowDelete or Backspace
Commit changesCmd+S

​
Data Changes

ActionShortcut
Undo changeCmd+Z
Redo changeCmd+Shift+Z
Commit all changesCmd+S

​
Selection

ActionShortcut
Select cellClick
Select rowClick row number
Select multiple cellsClick + drag
Extend selectionShift + click
Add to selectionCmd + click
Select allCmd+A

​
Clipboard

ActionShortcut
Copy selectionCmd+C
Copy as CSVCmd+Shift+C
Copy as JSONCmd+Option+C
Copy as TSVAvailable from context menu

​
Application

​
Windows & Tabs

ActionShortcut
New tableCmd+Shift+N
Close window / tabCmd+W
New query tabCmd+T
Switch to tab 1-9Cmd+1 through Cmd+9
Next tabCmd+Shift+] or Cmd+Option+Right
Previous tabCmd+Shift+[ or Cmd+Option+Left
MinimizeCmd+M
ZoomCmd+Option+Z

​
Connections

ActionShortcut
New connectionCmd+N
DisconnectCmd+D
Refresh connectionCmd+R

​
View

ActionShortcut
Toggle sidebarCmd+0
Toggle full screenCmd+Control+F
Zoom inCmd+=
Zoom outCmd+-
Reset zoomCmd+0

​
Panels

ActionShortcut
Query HistoryCmd+Y
SettingsCmd+,

​
Filtering

ActionShortcut
Toggle filter panel / Quick searchCmd+F
Quick searchType in search field
Apply filtersEnter (in filter field)

​
Table Structure

ActionShortcut
Columns tabCmd+1
Indexes tabCmd+2
Foreign Keys tabCmd+3
DDL tabCmd+4

​
Import/Export

ActionShortcut
Export dataCmd+Shift+E
Import dataCmd+Shift+I

​
Global Shortcuts

​
Standard macOS

ActionShortcut
Quit applicationCmd+Q
Hide applicationCmd+H
Hide othersCmd+Option+H
Show all-
PreferencesCmd+,

​
Help

ActionShortcut
Search documentationCmd+?

​
Customizing Shortcuts

Currently, keyboard shortcuts in TablePro follow standard macOS conventions and cannot be customized.
Custom keyboard shortcuts may be available in a future version.

​
Tips for Efficiency

​
Most Used Shortcuts

Focus on learning these first:
  1. Cmd+Enter - Execute query
  2. Cmd+N - New connection
  3. Cmd+Y - Query history
  4. Cmd+F - Find
  5. Cmd+C / Cmd+V - Copy/Paste

​
Workflow Tips

Quick query iteration:
  1. Write query in editor
  2. Cmd+Enter to run
  3. Make changes
  4. Cmd+Enter again
Exploring data:
  1. Click table in sidebar
  2. View data in grid
  3. Cmd+Enter with custom query
  4. Cmd+Y to find previous queries
Editing data:
  1. Navigate with arrow keys
  2. Enter to edit cell
  3. Type new value
  4. Tab to move to next cell
  5. Cmd+S to save all changes

​
Memory Techniques

Group by context:
  • All Cmd+ shortcuts are primary actions
  • Add Shift for variations (e.g., Cmd+Z undo → Cmd+Shift+Z redo)
  • Add Option for alternatives
Common patterns:
  • Cmd+[letter] - Common action (N=new, W=close, Q=quit)
  • Cmd+Shift+[letter] - Variation of common action
  • Arrow keys - Navigation
  • Tab / Shift+Tab - Next/Previous

​
Cheat Sheet

Print or save this quick reference: 
=== SQL Editor ===
Cmd+Enter      Execute query
Opt+Cmd+E      Explain query
Cmd+F          Find
Cmd+Z          Undo
Cmd+Shift+Z    Redo

=== Data Grid ===
Arrow keys     Navigate cells
Enter          Edit cell
Tab            Next cell
Cmd+C          Copy
Delete         Delete row

=== Data Changes ===
Cmd+S          Commit changes
Cmd+Z          Undo
Cmd+Shift+Z    Redo

=== Tabs ===
Cmd+T          New query tab
Cmd+W          Close tab
Cmd+1-9        Switch to tab N
Cmd+Shift+[    Previous tab
Cmd+Shift+]    Next tab

=== Application ===
Cmd+N          New connection
Cmd+Y          Query history
Cmd+,          Settings
Cmd+W          Close window
Cmd+Q          Quit

​
Accessibility

​
VoiceOver Support

TablePro works with macOS VoiceOver:
  • Navigate with Control+Option+Arrow keys
  • Interact with Control+Option+Space
  • All UI elements are labeled

​
Keyboard-Only Navigation

You can use TablePro entirely without a mouse:
  1. Tab moves between major UI sections
  2. Arrow keys navigate within sections
  3. Enter or Space activates controls
  4. Escape dismisses dialogs/menus

​
Troubleshooting

​
Shortcut Not Working

  1. Check focus: Ensure the correct panel has focus
  2. Check conflicts: Another app may be capturing the shortcut
  3. Check modifiers: Make sure you’re pressing the right modifier keys

​
System-Wide Conflicts

If a shortcut doesn’t work, check System Settings > Keyboard > Keyboard Shortcuts for conflicts with:
  • Mission Control
  • Spotlight
  • Input Sources
  • App Shortcuts

​
Next Steps

SQL Editor

Practice editor shortcuts

Data Grid

Master grid navigation

Query History

Use history shortcuts

Settings

Configure TablePro