Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.tablepro.app/llms.txt

Use this file to discover all available pages before exploring further.

​
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+Shift+O
Switch databaseCmd+K
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. Shows parameter panel if :name placeholders are detected
Execute all statementsCmd+Shift+EnterRun all statements in the editor. Shows parameter panel if parameters are detected
Cancel queryCmd+.Stop the currently running query
Explain queryOption+Cmd+EShow execution plan for query at cursor
Format SQLCmd+Shift+LFormat SQL query

​
Text Editing

ActionShortcutDescription
Select allCmd+ASelects every line, including the final line when the document ends with a trailing newline
CutCmd+XCuts the selection. With no selection, cuts the current line including its line break
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
Expand selectionCmd+Shift+Right
Shrink selectionCmd+Shift+Left

​
Data Grid

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

​
Editing

ActionShortcut
Edit cellEnter
Preview FK referenceSpace
Cancel editEscape
Add rowCmd+Shift+N
Duplicate rowCmd+Shift+D
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
Extend selection by rowShift+Up / Shift+Down
Select to first rowShift+Home
Select to last rowShift+End
Extend selection by pageShift+Page Up / Shift+Page Down
Select allCmd+A

​
Clipboard

ActionShortcut
Copy selectionCmd+C
Copy with HeadersCmd+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+]
Previous tabCmd+Shift+[
MinimizeCmd+M

​
Connections

ActionShortcut
New connectionCmd+N
Switch connectionCmd+Control+C
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+Option+I
Toggle ResultsCmd+Option+R
Open Terminal`Ctrl+Cmd+“
SettingsCmd+,

​
Results

ActionShortcut
Previous ResultCmd+Option+[
Next ResultCmd+Option+]
Close Result TabCmd+Shift+W

​
AI

ActionShortcutDescription
Explain with AICmd+LSend current query to AI for explanation
Optimize with AICmd+Option+LSend current query to AI for optimization

​
ER Diagram

These shortcuts apply when the ER Diagram view is focused. Cmd+0 overrides Toggle Sidebar in this context.
ActionShortcut
Zoom InCmd+=
Zoom OutCmd+-
Reset Zoom (100%)Cmd+0
Fit to WindowCmd+Shift+0
Copy to ClipboardCmd+C

​
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

Turn on vim mode in Settings > Editor > Vim mode. A badge next to the editor shows the current mode. See the Vim Mode page for the full key reference.
Vim keys only apply in the SQL editor. The data grid and other panels keep their standard shortcuts. Cmd+Enter runs the query in any mode.

​
Filtering

ActionShortcut
Toggle filter panelCmd+Shift+F
Apply filtersEnter (in value field)

​
Table Structure

These shortcuts only apply when the table structure view is focused. They override Cmd+1 through Cmd+4 tab switching in that context.
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+Shift+O) 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+Shift+O
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+,

​
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.

​
Outside The App

TablePro can also be driven from outside the running app. None of these are macOS keyboard shortcuts in the strict sense, but they cover the same fast-navigation use cases.
Entry pointUse
Raycast extensionTrigger commands from Raycast’s own hotkey: search connections, open tables, run queries, search query history, focus tabs.
tablepro:// URL schemeopen tablepro://... from the terminal, browser, or another app to open a connection, table, or query tab. Bind in Raycast Quicklinks, Alfred, or Shortcuts.app.
MCP clientsClaude Desktop, Cursor, Claude Code, Cline, Continue, Zed, Windsurf, Goose. Each client decides its own hotkey for invoking AI; tools call back into TablePro.