> For the complete documentation index, see [llms.txt](https://docs.tableplus.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tableplus.com/utilities/shortcut-keys.md).

# Shortcut Keys

The list of shortcut keys and how to use them in TablePlus

| Shortcut Key               | Description                                       | Scope                           |
| -------------------------- | ------------------------------------------------- | ------------------------------- |
| ⌘ + N                      | Open a new connection                             | Global                          |
| ⌘ + ,                      | Open Preference                                   | Global                          |
| ⌘ + Q                      | Quit app                                          | Global                          |
| ⌘ + ⇧ + O                  | New SQL Viewer                                    | Global                          |
| ⌘ + W                      | Close a tab/window                                | Workspace                       |
| ⌘ + S                      | Commit the changes                                | Workspace                       |
| ⌘ + ⇧ + P                  | Preview the changes                               | Workspace                       |
| ⌘ + ⇧ + Delete             | Discard the changes                               | Workspace                       |
| ⌘ + T                      | Open a new tab                                    | Workspace                       |
| ⌘ + L                      | Open plugin manager                               | Workspace                       |
| ⌘ + ⇧ + C                  | Toggle console log                                | Workspace                       |
| ⌘ + .                      | Run custom script                                 | Workspace                       |
| ⌘ + R                      | Reload workspace                                  | Workspace                       |
| ⌘ + \[                     | Navigate to left tab                              | Workspace                       |
| ⌘ + ]                      | Navigate to right tab                             | Workspace                       |
| ⇧ + ⌘ + \[                 | Navigate to left Pane                             | Workspace                       |
| ⇧ + ⌘ + ]                  | Navigate to right Pane                            | Workspace                       |
| ⌘ + ⇧ + D                  | Split Pane Horizontally                           | Workspace                       |
| ⌘ + Number                 | Navigate to number tab                            | Workspace                       |
| ⌘ + K                      | Switch database                                   | Workspace                       |
| ⌘ + ⇧ + K                  | Switch Connection                                 | Workspace                       |
| ⌘ + I or ⌃ + I             | Indent selected SQL Code                          | Workspace - SQL Tab, SQL Viewer |
| ⌘ + ⏎                      | Execute SQL Code                                  | Workspace - SQL Tab             |
| ⌘ + O                      | Open file SQL                                     | Workspace - SQL Tab             |
| ⌘ + I                      | Beautify selected SQL statements                  | Workspace - SQL Tab             |
| ⇧ + ⌘ + I                  | Uglify selected SQL statements                    | Workspace - SQL Tab             |
| ⇧ + ⌘ + S                  | Save selected SQL statements as                   | Workspace - SQL Tab             |
| ⌘ + /                      | Comment/Uncomment lines of SQL                    | Workspace - SQL Tab             |
| ⌘ + Click                  | Add cursors at arbitrary positions                | Workspace - SQL Tab             |
| ⌃ + ⇧ + **↑**              | Add additional cursors above the current line     | Workspace - SQL Tab             |
| ⌃ + ⇧ + **↓**              | Add additional cursors below the current line     | Workspace - SQL Tab             |
| ⌘ + D                      | Select the next instance of the current highlight | Workspace - SQL Tab             |
| ⌘ + ⌃ + G                  | Select all instances of the current highlight     |                                 |
| ⌘ + Z                      | Undo                                              | Workspace                       |
| ⌘ + ⇧ + Z                  | Redo                                              | Workspace                       |
| ⌘ + P                      | Open anything                                     | Workspace                       |
| ⌘ + E                      | Open SQL Query                                    | Workspace                       |
| Middle mouse click on Cell | Open quick look                                   | Table Data                      |
| Space                      | Toggle row detail when row selected               | Table Data                      |
| ⌘ + C                      | Copy rows                                         | Table Data                      |
| ⌘ + V                      | Paste rows                                        | Table Data                      |
| ⌘ + D                      | Duplicate row                                     | Table Data                      |
| ⌘ + I                      | Insert a new row                                  | Table Data                      |
| ⌘ + F                      | Open Row Filter                                   | Table Data                      |
| ⌘ + ⌥ + F                  | Open Column Filter                                | Table Data                      |
| ⌥ + click on field         | Open Quick edit Menu                              | Workspace - Table Data          |
| Tab                        | Move focus while editing                          | Workspace - Table Data          |