GUI Tools The Interface

Menu

TablePlus uses the native macOS menu bar. It contains most of the commands that affect the interface and your data. The tables below list every menu and its default shortcut.1

The TablePlus menu bar with the Connection menu open
The Connection menu

Some shortcuts can be changed in Preferences > Keymap: select next/previous pane, tab, and workspace, toggle line/block comment, increase/decrease font size, show table data/structure, and run current/all queries. See Keymap.

TablePlus

Item Shortcut
About TablePlus
Register license...
Check for Updates...
Preferences… ⌘ + ,
Services
Hide TablePlus ⌘ + H
Hide Others ⌥ + ⌘ + H
Show All
Quit TablePlus ⌘ + Q

File

Item Shortcut
Open... ⌘ + O
Open Recent
Save As... ⌘ + Shift + S
New Workspace ⌘ + N
New SQL Viewer ⌘ + Shift + O
Backup...
Restore...
Export > Export Tables... ⌘ + Shift + E
Export > Export this Table with Column Selection...
Import > From CSV...
Import > From JSON...
Import > From SQL Dump...
Close

Edit

Item Shortcut
Undo ⌘ + Z
Redo ⌘ + Shift + Z
Commit ⌘ + S
Discard ⌘ + Shift + Delete
Preview ⌘ + Shift + P
Add Row ⌘ + I
Duplicate Rows ⌘ + D
Cut ⌘ + X
Copy ⌘ + C
Copy Selected Cells ⌘ + Shift + C
Paste ⌘ + V
Paste to Selected Cells ⌘ + Shift + V
Select Word
Select all Words ⌃ + ⌘ + G
Delete ⌘ + Delete
Select All ⌘ + A
Toggle Line Comment ⌘ + /
Toggle Block Comment ⌥ + ⌘ + /
Increase Font Size ⌘ + =
Decrease Font Size ⌘ + -
Find > Find… ⌘ + F
Find > Find and Replace… ⌥ + ⌘ + F
Find > Find Next ⌘ + G
Find > Find Previous ⌘ + Shift + G
Find > Use Selection for Find
Find > Jump to Selection ⌘ + J
Find > Find Items in left sidebar... ⌘ + Shift + F
Transformations > Make Upper Case, Make Lower Case, Capitalize
Speech > Start Speaking, Stop Speaking

View

Item Shortcut
Toggle sidebars > Toggle Left Sidebar ⌘ + 0
Toggle sidebars > Toggle Right Sidebar Space
Toggle sidebars > Toggle Bottom Sidebar (console log) ⌃ + ⌘ + C
Toggle sidebars > Toggle Query Results Pane ⌃ + `
Enter Full Screen ⌃ + ⌘ + F

Tools

Item Shortcut
Process List ⌘ + .
Show Diagram
Show Metrics Board
User Management
Search in Database...
Run Custom Script
Manage Plugins... ⌘ + L

Connection

Item Shortcut
New...
Edit...
Open a Database... ⌘ + K
Open a Connection... ⌘ + Shift + K
Run Current Query ⌘ + Return
Run All Queries ⌘ + Shift + Return
View Using Encoding
Reload Workspace ⌘ + R
Reload Current Tab ⌥ + ⌘ + R
Reconnect ⌘ + Shift + R
Disconnect ⌥ + ⌘ + .

Theme

The Theme menu lists the built-in themes and any themes you have installed, so you can switch themes in one click. It also has More themes, Import theme from Git…, Import themes from file or folder…, and Theme Settings.

Item Shortcut
Open Anything ⌘ + P
New Tab ⌘ + T
Close Tab ⌘ + W
Show Table Data ⌃ + ⌘ + [
Show Table Structure ⌃ + ⌘ + ]
Select Next Pane ⌥ + ⌘ + ]
Select Previous Pane ⌥ + ⌘ + [
Go Back ⌃ + ⌘ + ←
Go Forward ⌃ + ⌘ + →
Select Next Tab ⌘ + ]
Select Previous Tab ⌘ + [
Select Tab at Index > Tab 1 to Tab 9 ⌘ + 1 to ⌘ + 9
Select Next Workspace ⌘ + Shift + ]
Select Previous Workspace ⌘ + Shift + [
Split Pane Right ⌘ + Shift + D

Window

Item Shortcut
Minimize ⌘ + M
Zoom
Bring All to Front

Help

Item Shortcut
Changelogs
Enable SSH & Bash Script Log
Private message...
Report bug & feedback ⌘ + ?

  1. On Windows and Linux, use Ctrl in place of ⌘. ↩︎