TablePlus Essential Shortcuts Cheatsheet

General & Navigation

General Actions

`Cmd + N`	New Query tab
`Cmd + Shift + N`	New Connection
`Cmd + T`	New Tab
`Cmd + W`	Close Tab
`Cmd + Q`	Quit TablePlus
`Cmd + S`	Save current file/query
`Cmd + P`	Quickly Switch Between Tabs/Files
`Cmd + ,`	Open Preferences

Navigation Within Tabs

`Cmd + Option + Left/Right Arrow`	Switch between tabs
`Cmd + Option + Up/Down Arrow`	Switch between Panes (Query/Results)
`Ctrl + Tab`	Cycle through tabs
`Cmd + K`	Quick Look for selected object (Table/View/Function)
`Cmd + Shift + D`	Change current database
`Cmd + J`	Jump to anything (tables, views, queries, etc.)
`Esc`	Deselect row/cell, close find panel, exit full screen
`F2`	Rename selected object

Search & Filtering Data

`Cmd + F`	Find in current tab/document
`Cmd + Option + F`	Replace in current tab/document
`Cmd + Shift + F`	Find in all files
`Cmd + Shift + R`	Replace in all files
`Cmd + L`	Go to line (in SQL editor)
`Cmd + Shift + G`	Filter data rows
`Cmd + Shift + P`	Show TablePlus commands

SQL Editor

Query Execution & Formatting

`Cmd + R`	Run current query
`Cmd + Shift + R`	Run all queries
`Cmd + Return`	Run current query (Alternative)
`Cmd + B`	Format Query
`Cmd + /`	Comment/Uncomment line(s)
`Cmd + Option + /`	Comment/Uncomment block
`Cmd + Shift + H`	Show Query History
`Cmd + Shift + E`	Explain Query Plan

Editing & Autocomplete

`Tab` or `Enter`	Accept autocomplete suggestion
`Esc`	Dismiss autocomplete suggestion
`Option + Delete`	Delete word backward
`Option + Foward Delete`	Delete word forward
`Ctrl + Space`	Trigger autocomplete manually
`Cmd + Left/Right Arrow`	Go to beginning/end of line
`Option + Left/Right Arrow`	Go to beginning/end of word
`Shift + Click`	Select rectangular block of text

Multi-Cursor Editing

`Option + Click`	Add new cursor at click location
`Ctrl + Shift + L`	Select all occurrences of the current word
`Cmd + D`	Select next occurrence of current word/selection
`Cmd + U`	Unselect last occurrence
`Option + Shift + Up/Down Arrow`	Add cursor above/below and select current line
`Esc`	Remove all extra cursors

Data & Structure

Data Grid Actions

`Cmd + N`	Add New Row
`Cmd + Delete`	Delete Selected Row(s)
`Cmd + D`	Duplicate Selected Row(s)
`Cmd + S`	Commit changes
`Esc`	Discard unsaved changes
`Return`	Edit cell
`Shift + Return`	Save cell edit
`Cmd + C / Cmd + V`	Copy/Paste cells or rows
`Cmd + Shift + V`	Paste with headers (useful for copying from spreadsheet)

Structure View Actions

`Cmd + N`	Add new column/index/relation
`Cmd + Delete`	Delete selected item
`Cmd + S`	Apply structure changes
`Esc`	Discard structure changes
`Tab`	Navigate between input fields when adding/editing item
`Shift + Tab`	Navigate backward between input fields
`Return`	Save/add item after editing fields
`Cmd + Option + P`	Toggle Foreign Key panel visibility

Import / Export

`Cmd + I`	Import Data
`Cmd + E`	Export Data
`Cmd + Shift + I`	Import from Database
`Cmd + Shift + E`	Export to Database
Use drag & drop	Drag CSV/JSON/SQL files onto a table tab to import
Use clipboard	Copy data rows and paste directly into a spreadsheet or text editor
Export results	After running a query, select results and use `Cmd+E` to export just the results

Tips & Advanced

Useful Quick Actions

Toggle Sidebar: Cmd + 1
Quickly show or hide the connection sidebar.

Toggle Console/Output: Cmd + 2
Show or hide the result/console area at the bottom.

Toggle Structure/Content: Cmd + 3
Switch between data grid, structure, and relations view for a table.

Focus Filter: Cmd + Option + F (in sidebar)
Quickly jump to the filter box in the sidebar to search for tables/databases.

Quick Look: Cmd + K
View basic info (columns, index, etc.) of a selected table/view/function without opening a new tab.

Open in New Window: Cmd + Shift + O
Open the current connection or selected object in a new window.

Maximize Pane: Double-click split bar
Double-clicking the bar between editor/results or sidebar/content will maximize one pane.

Show TablePlus Commands: Cmd + Shift + P
If you forget a shortcut, use this search bar to find and execute any TablePlus command.

Custom Shortcuts: Go to Preferences > Keybindings
TablePlus allows you to customize almost all keyboard shortcuts.

Advanced SQL Editor Tricks

Column Selection: Option + Drag Mouse
Select a vertical block of text for editing (column mode).

Move Line: Option + Up/Down Arrow
Move the current line or selected lines up or down.

Duplicate Line: Cmd + Shift + D
Duplicate the current line or selected lines.

Join Lines: Ctrl + J
Join the current line with the next line.

Insert Cursor Above/Below: Option + Cmd + Up/Down Arrow
Add a cursor directly above or below the current cursor.

Go to Matching Bracket: Ctrl + M
Jump to the matching parenthesis, bracket, or brace.

Toggle Case: Cmd + Shift + U
Cycle selection through UPPERCASE, lowercase, Capitalize.

Wrap Selection: Select text, then type (, [, {, ', or "
The selected text will be wrapped by the typed character pair.