---
title: TablePlus
date: 2022-11-23 16:23:31.706905
background: bg-[#ecc550]
label:
tags:
  -
  -
categories:
  - Keyboard Shortcuts
intro: |
  A visual cheat-sheet for the 34 keyboard shortcuts found in TablePlus
---

## Keyboard Shortcuts

### Global

| Shortcut           | Action                |
| ------------------ | --------------------- |
| `Ctrl` `N`         | Open a new connection |
| `Ctrl` `Q`         | Quit app              |
| `Ctrl` `Shift` `O` | Open SQL file         |
| `Ctrl` `,`         | Open Preferences      |

{.shortcuts}

### Workspace

| Shortcut               | Action                         |
| ---------------------- | ------------------------------ |
| `Ctrl` `W`             | Close a tab/window             |
| `Ctrl` `S`             | Commit the changes             |
| `Ctrl` `T`             | Open a new tab                 |
| `Ctrl` `L`             | Open plugin manager            |
| `Ctrl` `.`             | Run custom script              |
| `Ctrl` `R`             | Reload workspace               |
| `Ctrl` `[`             | Navigate to left tab           |
| `Ctrl` `]`             | Navigate to right tab          |
| `Ctrl` `Shift` `[`     | Navigate to left Pane          |
| `Ctrl` `Shift` `]`     | Navigate to right Pane         |
| `Ctrl` `D`             | Split Pane horizontally        |
| `Ctrl` `1-9`           | Navigate to number tab         |
| `Ctrl` `K`             | Switch database                |
| `Ctrl` `Shift` `K`     | Switch connection              |
| `Ctrl` `I`             | Indent selected SQL Code       |
| `Ctrl` `E`             | Execute SQL Code               |
| `Ctrl` `O`             | Open file SQL                  |
| `Ctrl` `Shift` `Enter` | Uglify selected SQL statements |
| `Ctrl` `\`             | Comment/Uncomment lines of SQL |
| `Ctrl` `Z`             | Undo                           |
| `Ctrl` `Shift` `Z`     | Redo                           |
| `Ctrl` `P`             | Open anything                  |
| `Ctrl` `E`             | Open SQL Query                 |
| `Ctrl` `(click)`       | Open item in new tab           |
| `Tab`                  | Move focus while editing       |

{.shortcuts}

### Table Data

| Shortcut         | Action                              |
| ---------------- | ----------------------------------- |
| `Space`          | Toggle row detail when row selected |
| `Ctrl` `C`       | Copy rows                           |
| `Ctrl` `V`       | Paste rows                          |
| `Ctrl` `Alt` `I` | Insert a new row                    |
| `Tab`            | Move focus while editing            |

{.shortcuts}

## Also see

- [Keyboard shortcuts for TablePlus app](https://tableplus.com/blog/2018/02/shortcut-keys.html) _(tableplus.com)_