- The five TablePlus shortcuts most people need first: Cmd + P (open anything), Cmd + E (SQL editor), Cmd + Return (run), Cmd + S (commit changes) and Cmd + K (switch database).
- The TablePlus documentation lists shortcuts with macOS keys and says to replace Command with Control on Windows. Linux shortcuts are not documented.
- Some keys change meaning by context: Cmd + I indents or beautifies SQL in the editor but inserts a row in table data, and Cmd + D selects the next match in the editor but duplicates a row in table data.
- You can change shortcuts under Preferences > Keymap; the Windows app added shortcut customisation in version 7.1.4.
How to read this TablePlus shortcuts cheat sheet
The TablePlus Shortcut Keys page lists keys with macOS symbols. This sheet writes them out: Cmd is Command, Shift, Option (Alt) and Ctrl (Control). The Getting Started page says to replace Command with Control on Windows, so the Windows column shows that substitution. Where a macOS shortcut already uses Ctrl, the documentation gives no Windows equivalent and the cell says so.
The vendor's Interface page adds a useful tip: hover over any button to see its tooltip and shortcut. The Shortcut Keys page itself was last updated years ago, and the app has changed a lot since, so if a key does nothing, check the tooltip or the Keymap preferences. Use the print button to keep this sheet next to your keyboard.
General, tabs and windows
| Action | macOS | Windows | Scope |
|---|---|---|---|
| Open a new connection | Cmd + N | Ctrl + N | Global |
| Open preferences | Cmd + , | Ctrl + , | Global |
| Quit the app | Cmd + Q | Ctrl + Q | Global |
| New SQL viewer | Cmd + Shift + O | Ctrl + Shift + O | Global |
| Open anything (tables, views, functions, databases) | Cmd + P | Ctrl + P | Workspace |
| Open a new tab | Cmd + T | Ctrl + T | Workspace |
| Close a tab or window | Cmd + W | Ctrl + W | Workspace |
| Go to the tab on the left | Cmd + [ | Ctrl + [ | Workspace |
| Go to the tab on the right | Cmd + ] | Ctrl + ] | Workspace |
| Go to tab by number | Cmd + number | Ctrl + number | Workspace |
| Go to the pane on the left | Shift + Cmd + [ | Shift + Ctrl + [ | Workspace |
| Go to the pane on the right | Shift + Cmd + ] | Shift + Ctrl + ] | Workspace |
| Split pane horizontally | Cmd + Shift + D | Ctrl + Shift + D | Workspace |
| Reload the workspace | Cmd + R | Ctrl + R | Workspace |
| Toggle the console log | Cmd + Shift + C | Ctrl + Shift + C | Workspace |
| Open the plugin manager | Cmd + L | Ctrl + L | Workspace |
| Run a custom script | Cmd + . | Ctrl + . | Workspace |
| Undo | Cmd + Z | Ctrl + Z | Workspace |
| Redo | Cmd + Shift + Z | Ctrl + Shift + Z | Workspace |
Connections, databases and changes
TablePlus does not send edits to the server until you commit them, so the commit, preview and discard keys are among the most used.
| Action | macOS | Windows | Scope |
|---|---|---|---|
| Switch database | Cmd + K | Ctrl + K | Workspace |
| Switch connection | Cmd + Shift + K | Ctrl + Shift + K | Workspace |
| Commit the changes | Cmd + S | Ctrl + S | Workspace |
| Preview the changes (generated SQL) | Cmd + Shift + P | Ctrl + Shift + P | Workspace |
| Discard the changes | Cmd + Shift + Delete | Ctrl + Shift + Delete | Workspace |
| Show table data (from structure view) | Cmd + Ctrl + [ | Not documented | Table |
| Show table structure | Cmd + Ctrl + ] | Not documented | Table |
SQL query editor
| Action | macOS | Windows | Scope |
|---|---|---|---|
| Open the SQL query editor | Cmd + E (or Cmd + Return) | Ctrl + E (or Ctrl + Return) | Workspace |
| Execute SQL (run current) | Cmd + Return | Ctrl + Return | SQL tab |
| Run all statements | Cmd + Shift + Return | Ctrl + Shift + Return | SQL tab |
| Execute selected statements (download page FAQ) | Cmd + Shift + E | Ctrl + Shift + E | SQL tab |
| Cancel a running query | Cmd + . | Ctrl + . | SQL tab |
| Open an SQL file | Cmd + O | Ctrl + O | SQL tab |
| Save selected SQL statements as | Shift + Cmd + S | Shift + Ctrl + S | SQL tab |
| Comment or uncomment lines | Cmd + / | Ctrl + / | SQL tab |
| Indent selected SQL | Cmd + I or Ctrl + I | Ctrl + I | SQL tab, SQL viewer |
| Beautify selected SQL | Cmd + I | Ctrl + I | SQL tab |
| Uglify selected SQL | Shift + Cmd + I | Shift + Ctrl + I | SQL tab |
| Format SQL with the SQL Formatter plugin | Ctrl + I | Not documented | SQL tab (plugin) |
Multiple cursors and selection
| Action | macOS | Windows | Scope |
|---|---|---|---|
| Add cursors at arbitrary positions | Cmd + click | Ctrl + click | SQL tab |
| Add a cursor on the line above | Ctrl + Shift + Up | Not documented | SQL tab |
| Add a cursor on the line below | Ctrl + Shift + Down | Not documented | SQL tab |
| Select the next instance of the current highlight | Cmd + D | Ctrl + D | SQL tab |
| Select all instances of the current highlight | Cmd + Ctrl + G | Not documented | SQL tab |
Table data, rows and filters
| Action | macOS | Windows | Scope |
|---|---|---|---|
| Toggle the row detail view | Space | Space | Table data |
| Open quick look on a cell | Middle mouse click on the cell | Middle mouse click on the cell | Table data |
| Open the quick edit menu | Option + click on a field | Not documented | Table data |
| Move focus while editing | Tab | Tab | Table data |
| Copy rows | Cmd + C | Ctrl + C | Table data |
| Paste rows | Cmd + V | Ctrl + V | Table data |
| Duplicate a row | Cmd + D | Ctrl + D | Table data |
| Insert a new row | Cmd + I | Ctrl + I | Table data |
| Open the row filter | Cmd + F | Ctrl + F | Table data |
| Turn the filter off | Esc | Esc | Table data |
| Open the column filter | Cmd + Option + F | Not documented | Table data |
| Open a table in a new tab | Cmd + click on the table in the list | Ctrl + click on the table in the list | Workspace |
| Open an item in a new tab | Middle mouse click on the item | Middle mouse click on the item | Workspace |
Change TablePlus shortcuts and known conflicts
Customise. According to the Keymap documentation, open Preferences (Cmd + ,), go to the Keymap tab, click a shortcut value and type the new keys, or clear it to reset to the default. The documented customisable actions include selecting the next or previous pane, tab and workspace, toggling line and block comments, and changing the editor font size. The Windows changelog records that shortcut customisation in Settings arrived in Windows version 7.1.4 (June 2026).
Conflicts in the vendor's own lists. The download page FAQ gives Cmd + E as "execute all SQL statements" in the SQL tab, while the Shortcut Keys page gives it as "Open SQL Query". The Shortcut Keys page lists Cmd + . as "Run custom script", while the Editor Basics page uses it to cancel a running query. Where they differ, check the app's menu or tooltip for your version.
For the tasks behind these keys, see exporting results, importing CSV and the TablePlus review. If you are new to TablePlus, start with installing TablePlus.
Frequently asked questions
What is the shortcut to run a query in TablePlus?
Cmd + Return on macOS (Ctrl + Return on Windows) executes the current statement; Cmd + Shift + Return runs all statements, according to the Editor Basics documentation.
How do I open the SQL editor in TablePlus?
Press Cmd + E (or Cmd + Return) on macOS, or Ctrl in place of Cmd on Windows, or click the SQL query editor button at the top of the left panel.
Do TablePlus shortcuts work on Windows?
The documentation lists macOS keys and says to replace Command with Control on Windows. Shortcuts that already use Control on macOS have no documented Windows equivalent; hover over the button to see the shortcut.
Can I change TablePlus keyboard shortcuts?
Yes. Use the Keymap tab in Preferences to set or reset shortcuts. On Windows, shortcut customisation arrived in version 7.1.4.
Is there a TablePlus shortcut to commit changes?
Yes: Cmd + S on macOS, Ctrl + S on Windows. Cmd + Shift + P previews the generated SQL first, and Cmd + Shift + Delete discards the changes.
Sources
- TablePlus documentation: Shortcut Keys
- TablePlus documentation: Getting Started
- TablePlus documentation: Editor Basics
- TablePlus documentation: Table Basics
- TablePlus documentation: Plugin
- TablePlus documentation: Keymap
- TablePlus documentation: The Interface
- TablePlus download page (shortcut FAQ)
- TablePlus Windows changelog
Checked 8 October 2026.
How we research tool guides: our editorial method. CodeWithSQL earns nothing from the vendors mentioned.