Shortcut Keys

The list of shortcut keys and how to use them in TablePlus

Shortcut Key	Description	Scope
⌘ + N	Open a new connection	Global
⌘ + ,	Open Preference	Global
⌘ + Q	Quit app	Global
⌘ + ⇧ + O	New SQL Viewer	Global
⌘ + W	Close a tab/window	Workspace
⌘ + S	Commit the changes	Workspace
⌘ + ⇧ + P	Preview the changes	Workspace
⌘ + ⇧ + Delete	Discard the changes	Workspace
⌘ + T	Open a new tab	Workspace
⌘ + L	Open plugin manager	Workspace
⌘ + ⇧ + C	Toggle console log	Workspace
⌘ + .	Run custom script	Workspace
⌘ + R	Reload workspace	Workspace
⌘ + [	Navigate to left tab	Workspace
⌘ + ]	Navigate to right tab	Workspace
⇧ + ⌘ + [	Navigate to left Pane	Workspace
⇧ + ⌘ + ]	Navigate to right Pane	Workspace
⌘ + ⇧ + D	Split Pane Horizontally	Workspace
⌘ + Number	Navigate to number tab	Workspace
⌘ + K	Switch database	Workspace
⌘ + ⇧ + K	Switch Connection	Workspace
⌘ + I or ⌃ + I	Indent selected SQL Code	Workspace - SQL Tab, SQL Viewer
⌘ + ⏎	Execute SQL Code	Workspace - SQL Tab
⌘ + O	Open file SQL	Workspace - SQL Tab
⌘ + I	Beautify selected SQL statements	Workspace - SQL Tab
⇧ + ⌘ + I	Uglify selected SQL statements	Workspace - SQL Tab
⇧ + ⌘ + S	Save selected SQL statements as	Workspace - SQL Tab
⌘ + /	Comment/Uncomment lines of SQL	Workspace - SQL Tab
⌘ + Click	Add cursors at arbitrary positions	Workspace - SQL Tab
⌃ + ⇧ + ↑	Add additional cursors above the current line	Workspace - SQL Tab
⌃ + ⇧ + ↓	Add additional cursors below the current line	Workspace - SQL Tab
⌘ + D	Select the next instance of the current highlight	Workspace - SQL Tab
⌘ + ⌃ + G	Select all instances of the current highlight
⌘ + Z	Undo	Workspace
⌘ + ⇧ + Z	Redo	Workspace
⌘ + P	Open anything	Workspace
⌘ + E	Open SQL Query	Workspace
Middle mouse click on Cell	Open quick look	Table Data
Space	Toggle row detail when row selected	Table Data
⌘ + C	Copy rows	Table Data
⌘ + V	Paste rows	Table Data
⌘ + D	Duplicate row	Table Data
⌘ + I	Insert a new row	Table Data
⌘ + F	Open Row Filter	Table Data
⌘ + ⌥ + F	Open Column Filter	Table Data
⌥ + click on field	Open Quick edit Menu	Workspace - Table Data
Tab	Move focus while editing	Workspace - Table Data