Editor Basics

Open SQL Query Editor

To open the query editor, click on the query editor button on top of the left panel, or use the shortcut key ⌘ + Return, or ⌘ + E.

Execute queries

To execute a query from the Query Editor, select the query and click on the Run Current button, or use shortcut key ⌘ + Return.
TablePlus also supports writing and executing multiple queries, you’ll need to separate them with a semicolon.
To execute multiple queries, select them in the Query Editor and click on the dropdown next to Run Current button, choose Run All, or use the shortcut key ⌘ + ⇧ + Return.
You can change the default Execute button from Run Current to Run All from the same dropdown.

Cancel Queries

When executing a long running queries and you need to stop it midway through, you can do it via the process list:
  • Click Cancel button on the Query Editor
  • Or navigate to menu Connection > Process List...
  • Or use the shortcut keys ⌘ + .
From the Process List, you can see all the running queries, select the query and click Kill to cancel it.

Export queries

To export a queries from the Query Editor, click on the dropdown menu next the the Run button and choose Save SQL as...
Copy link
On this page
Open SQL Query Editor
Execute queries
Cancel Queries
Export queries