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.
- Switch OS tabs for Windows, macOS, or Linux shortcuts.
- Use / to jump to search instantly.
- Use Compare mode when moving between machines.
- Print or save the page as a compact PDF cheat sheet.
Connection & Navigation
6 shortcuts
New connection
Ctrl+N
WinCtrl+NMac⌘N
Open connection
Ctrl+O
WinCtrl+OMac⌘O
Close tab
Ctrl+W
WinCtrl+WMac⌘W
New tab
Ctrl+T
WinCtrl+TMac⌘T
Switch tab
Ctrl+Tab
WinCtrl+TabMac⌃Tab
Search / open table
Ctrl+K
WinCtrl+KMac⌘K
SQL Editor
7 shortcuts
Run query
Ctrl+Enter
WinCtrl+EnterMac⌘Return
Run selected query
Ctrl+Shift+Enter
WinCtrl+Shift+EnterMac⌘⇧Return
Open SQL editor
Ctrl+E
WinCtrl+EMac⌘E
Format SQL
Ctrl+Shift+F
WinCtrl+Shift+FMac⌘⇧F
Comment line
Ctrl+/
WinCtrl+/Mac⌘/
Find in query
Ctrl+F
WinCtrl+FMac⌘F
Replace
Ctrl+H
WinCtrl+HMac⌘H
Table Editing
8 shortcuts
Save changes
Ctrl+S
WinCtrl+SMac⌘S
Discard changes
Ctrl+Z
WinCtrl+ZMac⌘Z
Add row
Ctrl+Shift+N
WinCtrl+Shift+NMac⌘⇧N
Delete selected row
Ctrl+Delete
WinCtrl+DeleteMac⌘⌫
Duplicate row
Ctrl+D
WinCtrl+DMac⌘D
Edit cell
Enter/F2
WinEnter/F2MacReturn/F2
Copy row
Ctrl+C
WinCtrl+CMac⌘C
Paste row
Ctrl+V
WinCtrl+VMac⌘V
View
5 shortcuts
Refresh table
Ctrl+R
WinCtrl+RMac⌘R
Filter rows
Ctrl+Shift+L
WinCtrl+Shift+LMac⌘⇧L
Toggle left sidebar
Ctrl+Shift+0
WinCtrl+Shift+0Mac⌘⇧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.
Advertisement