============================
TablePlus keyboard shortcuts
============================

First published at 4/26/2021 on https://defkey.com/tableplus-shortcuts

TablePlus is a database management software. It supports MySQL, SQL Server,
Postgres, SQLite, Microsoft SQL Server, Redshift, Redis, and more.

TablePlus has 48 shortcuts and we have listed all of them below.



Global
------

Cmd + N                 Open a new connection
Cmd + ,                 Open Preferences
Cmd + Q                 Quit app
Cmd + Shift + O         New SQL Viewer


Workspace
---------

Cmd + W                 Close a tab/window
Cmd + S                 Commit the changes
Cmd + Shift + P         Preview the changes
Cmd + Shift + Del       Discard the changes
Cmd + T                 Open a new tab
Cmd + L                 Open plugin manager
Cmd + Shift + C         Toggle console log
Cmd + .                 Run custom script
Cmd + R                 Reload workspace
Cmd + [                 Navigate to left tab
Cmd + ]                 Navigate to right tab
Shift + Cmd + [         Navigate to left pane
Shift + Cmd + ]         Navigate to right pane
Cmd + Shift + D         Split Pane Horizontally
Cmd + Number            Navigate to number tab
Cmd + K                 Switch database
Cmd + Shift + K         Switch connection


Workspace - SQL Tab
-------------------

Cmd + I                 Indent selected SQL Code
Control + I             Indent selected SQL Code
Cmd + Enter             Execute SQL Code
Cmd + O                 Open file SQL
Cmd + I                 Beautify selected SQL statements
Shift + Cmd + I         Uglify selected SQL statements
Shift + Cmd + S         Save selected SQL statements as
Cmd + /                 Comment/Uncomment lines of SQL
Cmd + Left click        Add cursors at arbitrary positions
Control + Shift + Up arrow Add additional cursors above the current line
Control + Shift + Down arrow Add additional cursors below the current line
Cmd + D                 Select the next instance of the current highlight
Cmd + Control + G       Select all instances of the current highlight


Workspace
---------

Cmd + Z                 Undo
Cmd + Shift + Z         Redo
Cmd + P                 Open anything
Cmd + E                 Open SQL Query


Table Data
----------

Middle click            (on cell) Open quick look
Space                   Toggle row detail when row selected
Cmd + C                 Copy rows
Cmd + V                 Paste rows
Cmd + D                 Duplicate row
Cmd + I                 Insert a new row
Cmd + F                 Open Row Filter
Cmd + Option + F        Open Column Filter


Workspace - Table Data
----------------------

Option + Left click     (click on field) Open Quick edit Menu
Tab                     Move focus while editing

Source: tableplus.com


Last modified on (UTC): Monday, April 26, 2021
Defkey © All rights reserved.