Keyboard Shortcuts

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

Quick Reference

Essential Shortcuts

Action	Shortcut
Execute query	`Cmd+Enter`
New connection	`Cmd+N`
Open history	`Cmd+Y`
Settings	`Cmd+,`
Quick Switcher	`Cmd+Shift+O`
Switch database	`Cmd+K`
Close window	`Cmd+W`
Quit	`Cmd+Q`

SQL Editor

File Operations

Action	Shortcut
Open SQL file	`Cmd+O`
Save file	`Cmd+S`
Save As	`Cmd+Shift+S`

Query Execution

Action	Shortcut	Description
Execute query	`Cmd+Enter`	Run query at cursor. Shows parameter panel if `:name` placeholders are detected
Execute all statements	`Cmd+Shift+Enter`	Run all statements in the editor. Shows parameter panel if parameters are detected
Cancel query	`Cmd+.`	Stop the currently running query
Explain query	`Option+Cmd+E`	Show execution plan for query at cursor
Format SQL	`Cmd+Shift+L`	Format the selected SQL, or the whole query when nothing is selected
Save as Favorite	`Cmd+D`	Save the current query as a favorite

Text Editing

Action	Shortcut	Description
Select all	`Cmd+A`	Selects every line, including the final line when the document ends with a trailing newline
Cut	`Cmd+X`	Cuts the selection. With no selection, cuts the current line including its line break
Copy	`Cmd+C`
Paste	`Cmd+V`
Undo	`Cmd+Z`
Redo	`Cmd+Shift+Z`
Delete line	`Cmd+Shift+K`
Duplicate line	`Cmd+Shift+D`

Action	Shortcut
Start of line	`Home` or `Cmd+Left`
End of line	`End` or `Cmd+Right`
Start of document	`Cmd+Home` or `Cmd+Up`
End of document	`Cmd+End` or `Cmd+Down`
Move line up	`Option+Up`
Move line down	`Option+Down`
Center cursor in view	`Ctrl+L`

Find and Replace

Action	Shortcut
Find (in SQL editor)	`Cmd+F`
Find and replace	`Cmd+Option+F`
Find next	`Cmd+G`
Find previous	`Cmd+Shift+G`

Selection

Action	Shortcut
Expand selection	`Cmd+Shift+Right`
Shrink selection	`Cmd+Shift+Left`

Data Grid

Action	Shortcut
Move between cells	Arrow keys
Next cell	`Tab`
Previous cell	`Shift+Tab`
First row	`Home`
Last row	`End`
Page up	`Page Up`
Page down	`Page Down`

Pagination

Action	Shortcut
Previous page	`Cmd+[`
Next page	`Cmd+]`
First page	`Cmd+Option+Up`
Last page	`Cmd+Option+Down`

Cmd+[ and Cmd+] page the data grid. In the SQL editor the same keys indent and outdent the selection, so the binding follows whichever has focus.

Editing

Action	Shortcut
Edit cell	`Enter`
Preview FK reference	`Space`
Cancel edit	`Escape`
Add row	`Cmd+Shift+N`
Duplicate row	`Cmd+Shift+D`
Delete row	`Delete` or `Backspace`
Commit changes	`Cmd+S`

Data Changes

Action	Shortcut
Undo change	`Cmd+Z`
Redo change	`Cmd+Shift+Z`
Commit all changes	`Cmd+S`
Create table from the Create Table tab	`Cmd+S` or `Cmd+Return`
Preview SQL	`Cmd+Shift+P`	Preview pending SQL before commit

Selection

Action	Shortcut
Select cell	Click
Select row	Click row number
Select rectangular range	Click + drag
Extend selection	`Shift` + click
Add cell to selection	`Cmd` + click
Select entire column	`Cmd` + click column header
Extend selection by one cell	`Shift+Arrow`
Extend selection to grid edge	`Cmd+Shift+Arrow`
Clear cell selection	`Escape`
Extend selection by row	`Shift+Up` / `Shift+Down`
Select to first row	`Shift+Home`
Select to last row	`Shift+End`
Extend selection by page	`Shift+Page Up` / `Shift+Page Down`
Select all	`Cmd+A`

Clipboard

Action	Shortcut
Copy (cell value if a cell is focused on a single row, otherwise row(s) TSV)	`Cmd+C`
Copy Rows as TSV	`Cmd+Shift+C`
Copy as JSON	`Cmd+Option+J`
Copy with Headers	`Cmd+Option+C`

CSV Inspector

Inherits the standard NSDocument shortcuts.

Action	Shortcut
Save	`Cmd+S`
Save As	`Cmd+Shift+S`
Revert to Saved	`Cmd+Option+S`
Toggle filter panel	`Cmd+F`
Copy selected rows as TSV	`Cmd+C`
Paste TSV as new rows	`Cmd+V`
Add secondary sort column	`Shift+Click` column header
Undo (cell edit, delete, paste)	`Cmd+Z`
Redo	`Cmd+Shift+Z`
New CSV inspector tab	`Cmd+T` (from a CSV window)
Close CSV tab	`Cmd+W`

Application

Windows & Tabs

Action	Shortcut
Close window / tab	`Cmd+W`
New query tab	`Cmd+T`
Switch to tab 1-9	`Cmd+1` through `Cmd+9`
Next tab	`Cmd+Shift+]`
Previous tab	`Cmd+Shift+[`
Minimize	`Cmd+M`

Connections

Action	Shortcut
New connection	`Cmd+N`
Switch connection	`Cmd+Control+C`
Refresh connection	`Cmd+R`
Delete selected connections	`Cmd+Delete`

View

Action	Shortcut
Toggle sidebar	`Cmd+0`
Focus sidebar filter	`Cmd+Option+F`
Show Tables sidebar	`Cmd+Option+1`
Show Favorites sidebar	`Cmd+Option+2`
Toggle full screen	`Cmd+Control+F`
Zoom in	`Cmd+=`
Zoom out	`Cmd+-`

Panels

Action	Shortcut
Query History	`Cmd+Y`
Toggle Cell Inspector	`Cmd+Option+I`
Toggle Results	`Cmd+Option+R`
Settings	`Cmd+,`

Results

Action	Shortcut
Previous Result	`Cmd+Option+[`
Next Result	`Cmd+Option+]`
Close Result Tab	`Cmd+Shift+W`

AI

Action	Shortcut	Description
Explain with AI	`Cmd+L`	Send current query to AI for explanation
Optimize with AI	`Cmd+Option+L`	Send 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.

Action	Shortcut
Zoom In	`Cmd+=`
Zoom Out	`Cmd+-`
Reset Zoom (100%)	`Cmd+0`
Fit to Window	`Cmd+Shift+0`
Copy to Clipboard	`Cmd+C`

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.

Shortcut	Action	Where
`Ctrl+J` / `Ctrl+N`	Move down / Next item	Data grid, connection list, quick switcher, database switcher
`Ctrl+K` / `Ctrl+P`	Move up / Previous item	Data grid, connection list, quick switcher, database switcher
`Ctrl+H`	Move left / Collapse group	Data grid (column left), welcome panel (collapse group at any nesting level), onboarding (previous page)
`Ctrl+L`	Move right / Expand group	Data grid (column right), welcome panel (expand group at any nesting level), onboarding (next page)
`Ctrl+Shift+J`	Extend selection down	Data grid
`Ctrl+Shift+K`	Extend selection up	Data 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

Action	Shortcut
Toggle filter panel (table tab)	`Cmd+F`
Apply filters	`Enter` (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.

Action	Shortcut
Columns tab	`Cmd+1`
Indexes tab	`Cmd+2`
Foreign Keys tab	`Cmd+3`
DDL tab	`Cmd+4`

Import/Export

Action	Shortcut
Export data	`Cmd+Shift+E`
Import data	`Cmd+Shift+I`

Quick switcher

The Quick Switcher (Cmd+Shift+O) opens a floating panel to search and jump to any table, view, database, schema, saved query, or recent query. It uses fuzzy matching, so typing usr finds users, user_settings, etc. Matched characters are highlighted in each result.

Action	Shortcut
Open Quick Switcher	`Cmd+Shift+O`
Navigate results	`Up` / `Down` arrows
Open selected item	`Return`
Open in a new tab	`Option+Return`
Switch scope (All, Tables, Databases, Queries)	`Cmd+1` to `Cmd+4`
Dismiss	`Escape`

Results are grouped by type (tables, views, system tables, databases, schemas, saved queries, recent queries) and ranked by match quality, how often you open each item, and how recently. Tables already open in a tab show an Open badge and rank higher; selecting one switches to the existing tab instead of opening a duplicate. Right-click a result for more actions: open the table structure, copy the name, or copy the query.

Global Shortcuts

Action	Shortcut
Quit application	`Cmd+Q`
Preferences	`Cmd+,`

Customizing Shortcuts

Most menu shortcuts are rebindable in Settings > Keyboard.

Keyboard settings — Keyboard shortcut customization

Rebinding a Shortcut

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

Menu actions need a modifier key (Cmd, Option, Control, or Shift). A plain key like Space won’t reach the menu, so TablePro asks you to add a modifier. The exceptions are function keys (F1 through F12), which work on their own, and data grid actions that read the key directly, like Preview FK Reference (Space) and Cancel edit (Escape).

Clearing a Shortcut

Click the shortcut field for the action
Press Delete or Backspace
The shortcut is removed

Conflict Detection

If you assign a shortcut already used by another action in the same context, TablePro shows a confirmation dialog naming that action and its group:

Cancel: keep the existing assignment
Reassign: move the shortcut to the new action (clears the previous action’s shortcut)

The same key can mean different things in the editor and the data grid because focus decides which one fires, so a grid shortcut and an editor shortcut can share a key without conflicting.

Shortcuts the editor uses internally (like Cmd+/ to comment or Cmd+Shift+K to delete a line) and macOS system shortcuts (read live from System Settings, so Cmd+Q, Spotlight, and Mission Control are covered) cannot be assigned. TablePro warns if you try.

Resetting to Defaults

A reset button (the curved arrow) appears next to any shortcut you have changed; click it to restore that one action. Click Reset to Defaults to restore every shortcut at once.

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 point	Use
Raycast extension	Trigger commands from Raycast’s own hotkey: search connections, open tables, run queries, search query history, focus tabs.
`tablepro://` URL scheme	`open 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 clients	Claude Desktop, Cursor, Claude Code, Cline, Continue, Zed, Windsurf, Goose. Each client decides its own hotkey for invoking AI; tools call back into TablePro.

​Keyboard Shortcuts

​Quick Reference

​Essential Shortcuts

​SQL Editor

​File Operations

​Query Execution

​Text Editing

​Navigation

​Find and Replace

​Selection

​Data Grid

​Navigation

​Pagination

​Editing

​Data Changes

​Selection

​Clipboard

​CSV Inspector

​Application

​Windows & Tabs

​Connections

​View

​Panels

​Results

​AI

​ER Diagram

​Alternative navigation (Ctrl+HJKL)

​Vim Mode Keybindings

​Filtering

​Table Structure

​Navigation

​Import/Export

​Quick switcher

​Global Shortcuts

​Customizing Shortcuts

​Rebinding a Shortcut

​Clearing a Shortcut

​Conflict Detection

​Resetting to Defaults

​Outside The App

Keyboard Shortcuts

Quick Reference

Essential Shortcuts

SQL Editor

File Operations

Query Execution

Text Editing

Navigation

Find and Replace

Selection

Data Grid

Navigation

Pagination

Editing

Data Changes

Selection

Clipboard

CSV Inspector

Application

Windows & Tabs

Connections

View

Panels

Results

AI

ER Diagram

Alternative navigation (Ctrl+HJKL)

Vim Mode Keybindings

Filtering

Table Structure

Navigation

Import/Export

Quick switcher

Global Shortcuts

Customizing Shortcuts

Rebinding a Shortcut

Clearing a Shortcut

Conflict Detection

Resetting to Defaults

Outside The App