Cheat sheet guide
TablePlus shortcuts worth learning first
This page collects 26 searchable TablePlus keyboard shortcuts across 4 categories. Start with the shortcuts for Connection & Navigation, SQL Editor, Table Editing, View, then print the cheat sheet once the important ones are worth keeping nearby.
- New connectionCtrlN
- Run queryCtrlEnter
- Save changesCtrlS
- Refresh tableCtrlR
- Open connectionCtrlO
- Close tabCtrlW
Connection & Navigation
6 shortcuts
New connection
CtrlN
WinCtrlNMac⌘N
Open connection
CtrlO
WinCtrlOMac⌘O
Close tab
CtrlW
WinCtrlWMac⌘W
New tab
CtrlT
WinCtrlTMac⌘T
Switch tab
CtrlTab
WinCtrlTabMac⌃Tab
Search / open table
CtrlK
WinCtrlKMac⌘K
SQL Editor
7 shortcuts
Run query
CtrlEnter
WinCtrlEnterMac⌘Return
Run selected query
CtrlShiftEnter
WinCtrlShiftEnterMac⌘⇧Return
Open SQL editor
CtrlE
WinCtrlEMac⌘E
Format SQL
CtrlShiftF
WinCtrlShiftFMac⌘⇧F
Comment line
Ctrl/
WinCtrl/Mac⌘/
Find in query
CtrlF
WinCtrlFMac⌘F
Replace
CtrlH
WinCtrlHMac⌘H
Table Editing
8 shortcuts
Save changes
CtrlS
WinCtrlSMac⌘S
Discard changes
CtrlZ
WinCtrlZMac⌘Z
Add row
CtrlShiftN
WinCtrlShiftNMac⌘⇧N
Delete selected row
CtrlDelete
WinCtrlDeleteMac⌘⌫
Duplicate row
CtrlD
WinCtrlDMac⌘D
Edit cell
EnterF2
WinEnterF2MacReturnF2
Copy row
CtrlC
WinCtrlCMac⌘C
Paste row
CtrlV
WinCtrlVMac⌘V
View
5 shortcuts
Refresh table
CtrlR
WinCtrlRMac⌘R
Filter rows
CtrlShiftL
WinCtrlShiftLMac⌘⇧L
Toggle left sidebar
CtrlShift0
WinCtrlShift0Mac⌘⇧0
Zoom in
Ctrl=
WinCtrl=Mac⌘=
Zoom out
Ctrl-
WinCtrl-Mac⌘-
Frequently asked questions
What is the fastest way to find TablePlus shortcuts on this page?
Use the search box or press /, then type an action such as new connection.
Can I print this TablePlus shortcut cheat sheet?
Yes. Use the Print / PDF button or your browser print command to save a compact cheat sheet.
Does this page include Windows and Mac shortcuts for TablePlus?
Yes. Use the OS tabs to switch between Windows and macOS shortcuts. For example, New connection is Ctrl+N on Windows and ⌘N on macOS where available.
