TablePlus keyboard shortcuts

Connections and workspace

Global and workspace shortcuts open connections, tabs, preferences, plugins, panes, and the database or connection switchers.

Action	Windows	macOS
Open a new connection	`CtrlN`	`CmdN`
Open Preferences	`Ctrl,`	`Cmd,`
Quit the app	`CtrlQ`	`CmdQ`
Open a new SQL Viewer	`CtrlShiftO`	`CmdShiftO`
Close the current tab or window	`CtrlW`	`CmdW`
Open a new tab	`CtrlT`	`CmdT`
Open the plugin manager	`CtrlL`	`CmdL`
Toggle the console log	`CtrlShiftC`	`CmdShiftC`
Reload the workspace	`CtrlR`	`CmdR`
Navigate to the left tab	`Ctrl[`	`Cmd[`
Navigate to the right tab	`Ctrl]`	`Cmd]`
Split the pane horizontally	`CtrlShiftD`	`CmdShiftD`
Switch database	`CtrlK`	`CmdK`
Switch connection	`CtrlShiftK`	`CmdShiftK`

SQL editor shortcuts execute, open, format, comment, save, and navigate query text while the SQL tab or viewer is focused.

Action	Windows	macOS
Execute SQL code	`CtrlEnter`	`CmdReturn`
Open a SQL file	`CtrlO`	`CmdO`
Indent selected SQL code	`CtrlI`	`CmdI`
Beautify selected SQL statements	`CtrlI`	`CmdI`
Uglify selected SQL statements	`CtrlShiftI`	`ShiftCmdI`
Save selected SQL statements as	`CtrlShiftS`	`ShiftCmdS`
Comment or uncomment SQL lines	`Ctrl/`	`Cmd/`
Add a cursor above the current line	`CtrlShiftUp`	`CtrlShiftUp`
Add a cursor below the current line	`CtrlShiftDown`	`CtrlShiftDown`
Select the next instance of the current highlight	`CtrlD`	`CmdD`
Select all instances of the current highlight	`CtrlCtrlG`	`CmdCtrlG`

Table data shortcuts toggle row details, copy or paste rows, duplicate or insert rows, and open row or column filters.