Complete TablePlus keyboard shortcuts and commands reference — 10 shortcuts across 1 category. Quick reference cheat sheet for Windows & Mac.
TablePlus is a native database client for macOS and Windows with a deliberately small keymap: one key each for connections, tabs, queries, saving and the universal "open anything" search. The table uses Cmd as the app documents it; the Windows build uses Ctrl. The habit that matters is that edits are staged until you save, which the notes explain.
| Shortcut | Action | Description |
|---|---|---|
| Cmd + N | New connection | Create a new connection. |
| Cmd + T | New tab | Open a new tab. |
| Cmd + R | Refresh | Refresh the table. |
| Cmd + S | Save changes | Save changes. |
| Cmd + E | Query editor | Open SQL query editor. |
| Cmd + Enter | Run query | Execute the current SQL statement in the editor. |
| Cmd + P | Open anything | Quick open a table, view, or function by name. |
| Cmd + F | Filter | Filter rows in the current table view. |
| Cmd + W | Close tab | Close the current tab. |
| Cmd + , | Preferences | Open TablePlus settings. |
The most essential TablePlus shortcuts are: Cmd + N (New connection), Cmd + T (New tab), Cmd + R (Refresh).
The TablePlus shortcut for new connection is Cmd + N. Create a new connection.
Print the TablePlus cheat sheet and keep it next to your keyboard for the first week, then switch to active recall: open Shortcut Speedrun and practice TablePlus shortcuts against the clock until they're automatic.
Yes — use My Stack to combine TablePlus shortcuts with any other platform on this site into one printable reference, which is useful if your daily workflow spans several tools.
Cmd + N creates a connection — TablePlus stores them encrypted and can group them by colour and environment — and Cmd + T opens a new tab on the current connection, so several tables and queries stay side by side. Cmd + W closes a tab and Cmd + R refreshes the current view against the database. Cmd + , opens preferences, where the SQL editor theme, safe mode and the query timeout live.
Cmd + P is Open Anything: type a table, view or function name and jump to it, which replaces scrolling a sidebar with hundreds of tables. Cmd + F opens the filter bar on a table view, where conditions on columns are built without writing SQL and can be combined; the same key finds text in the query editor.
Cmd + E opens a query editor tab and Cmd + Enter runs the statement under the cursor (or the selection). Data edits made in the grid — changed cells, inserted rows, deletions — are highlighted and not sent to the database until Cmd + S commits them, which lets you review a batch of changes and discard them with a refresh if they are wrong. Safe mode in preferences adds a confirmation with the generated SQL before every commit.
Open your assistant with this page preloaded as the source — great for follow-up questions like "which of these work in other apps?"