Skip to main content

​
Keyboard Shortcuts

TablePro is keyboard-driven. Most actions have shortcuts, and most menu shortcuts are rebindable.

​
Quick Reference

​
Essential Shortcuts

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

​
SQL Editor

​
File Operations

ActionShortcut
Open SQL fileCmd+O
Save fileCmd+S
Save AsCmd+Shift+S

​
Query Execution

ActionShortcutDescription
Execute queryCmd+EnterRun query at cursor, or all selected statements sequentially
Explain queryOption+Cmd+EShow execution plan for query at cursor
Format SQLOption+Cmd+FFormat SQL query (beautify and standardize SQL syntax)
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 run sequentially in 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
Start of lineHome or Cmd+Left
End of lineEnd or Cmd+Right
Start of documentCmd+Home or Cmd+Up
End of documentCmd+End or Cmd+Down
Move line upOption+Up
Move line downOption+Down
Center cursor in viewCtrl+L

​
Find and Replace

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

​
Selection

ActionShortcut
Select wordCmd+D
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
Preview SQLCmd+Shift+PPreview pending SQL before commit

​
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+J
Copy as TSVAvailable from context menu

​
Application

​
Windows & Tabs

ActionShortcut
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
Switch connectionCmd+Option+C
DisconnectCmd+D
Refresh connectionCmd+R
Delete selected connectionsCmd+Delete

​
View

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

​
Panels

ActionShortcut
Query HistoryCmd+Y
Toggle Cell InspectorCmd+Shift+B
Toggle AI ChatCmd+Shift+L
SettingsCmd+,

​
AI

ActionShortcutDescription
Toggle AI ChatCmd+Shift+LOpen or close the AI chat panel
Explain with AICmd+LSend selected SQL (or current query) to AI for explanation
Optimize with AICmd+Option+LSend selected SQL (or current query) to AI for optimization

​
Alternative navigation (Ctrl+HJKL)

For keyboards without dedicated arrow keys (e.g., HHKB), Ctrl+HJKL works as arrow key alternatives throughout the app. These work alongside arrow keys, not as replacements.
ShortcutActionWhere
Ctrl+J / Ctrl+NMove down / Next itemData grid, connection list, quick switcher, database switcher
Ctrl+K / Ctrl+PMove up / Previous itemData grid, connection list, quick switcher, database switcher
Ctrl+HMove left / Collapse groupData grid (column left), welcome panel (collapse group at any nesting level), onboarding (previous page)
Ctrl+LMove right / Expand groupData grid (column right), welcome panel (expand group at any nesting level), onboarding (next page)
Ctrl+Shift+JExtend selection downData grid
Ctrl+Shift+KExtend selection upData grid

​
Vim Mode Keybindings

When Vim mode is enabled (Settings > Editor > Editing > Vim mode), the SQL editor uses modal keybindings. A mode indicator badge appears in the toolbar.

​
Modes

KeyAction
EscapeReturn to Normal mode
i / IInsert before cursor / at line start
a / AAppend after cursor / at line end
o / OOpen line below / above
vVisual mode (character-wise)
VVisual Line mode (line-wise)
:Command-line mode
KeyAction
h / j / k / lLeft / Down / Up / Right
w / b / eNext word / Previous word / End of word
0 / $Beginning / End of line
^ / _First non-blank character of line
gg / GFirst line / Last line

​
Operators (Normal Mode)

KeyAction
ddDelete line
yyYank (copy) line
ccChange line
xDelete character
p / PPaste after / before cursor
d + motionDelete with motion
y + motionYank with motion
c + motionChange with motion

​
Visual Mode

KeyAction
dDelete selection
yYank selection
cChange selection

​
Command-Line Mode

CommandAction
:wExecute query (Cmd+Enter)
:qClose tab

​
Count Prefixes

Prefix motions and operators with a number: 3j (down 3 lines), 2dd (delete 2 lines), 5x (delete 5 characters).
Vim mode keybindings only apply in the SQL editor. They don’t affect the data grid or other panels. Standard shortcuts like Cmd+Enter work in all modes.

​
Filtering

ActionShortcut
Toggle filter panelCmd+F
Apply filtersEnter (in value 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

​
Quick switcher

The Quick Switcher (Cmd+P) lets you search and jump to any table, view, database, schema, or recent query. It uses fuzzy matching, so typing usr finds users, user_settings, etc.
ActionShortcut
Open Quick SwitcherCmd+P
Navigate resultsUp / Down arrows
Open selected itemReturn
DismissEscape
Results are grouped by type (tables, views, system tables, databases, schemas, recent queries) and ranked by match quality when searching.

​
Global Shortcuts

ActionShortcut
Quit applicationCmd+Q
PreferencesCmd+,
Search documentationCmd+?

​
Customizing Shortcuts

Most menu shortcuts are rebindable in Settings > Keyboard.
Keyboard settings

​
Rebinding a Shortcut

  1. Open Settings (Cmd+,) and select the Keyboard tab
  2. Find the action (use the search field to filter)
  3. Click the shortcut field next to the action
  4. Press the new key combination
  5. The shortcut updates immediately in the menu bar

​
Clearing a Shortcut

  1. Click the shortcut field for the action
  2. Press Delete or Backspace
  3. The shortcut is removed

​
Conflict Detection

If you assign a shortcut already in use, TablePro shows a confirmation dialog:
  • Cancel — keep the existing assignment
  • Reassign — move the shortcut to the new action (clears the previous action’s shortcut)
System-reserved shortcuts (Cmd+Q, Cmd+H, Cmd+M, Cmd+,) cannot be reassigned. TablePro warns if you try.

​
Resetting to Defaults

Click Reset to Defaults to restore all shortcuts to their original values.
Tab switching shortcuts (Cmd+1 through Cmd+9) follow standard macOS convention and cannot be customized.

​
Tips for Efficiency

Master these five shortcuts first:
  1. Cmd+Enter - Execute query
  2. Cmd+N - New connection
  3. Cmd+Y - Query history
  4. Cmd+F - Find
  5. Cmd+S - Save changes
Most other shortcuts follow patterns: Cmd+ for primary actions, add Shift or Option for variations.

​
Accessibility

TablePro is fully keyboard-navigable. Tab moves between UI sections, arrow keys navigate within them. VoiceOver is supported with standard Control+Option navigation.