Keyboard shortcuts¶

On macOS, Ctrl below is Cmd.

Anywhere¶

Keys	Does
`Ctrl`+`O`	Open a database or a script
`Ctrl`+`N`	New SQL editor, on the database selected in the browser
`Ctrl`+`S` / `Ctrl`+`Shift`+`S`	Save the script, or the grid’s changes when the grid has focus / Save the script as
`Ctrl`+`W`	Close the tab
`Ctrl`+`B`	Go to the database browser
`Ctrl`+`Shift`+`B`	Go to the file browser
`F6`	Go to the editor
`F1`	The manual, at the page for what is shown
`Ctrl`+`Q`	Quit

The SQL editor¶

Keys	Does
`Ctrl`+`Enter`	Run the statement under the cursor, or the selection
`Ctrl`+`Shift`+`Enter`	Run the whole script
`Ctrl`+`E`	Explain the query plan
`Ctrl`+`.`	Stop what is running
`Ctrl`+`Space`	Complete
`Tab`	Expand the template before the cursor
`Ctrl`+`/`	Comment the lines out, or in
`Ctrl`+`F` / `Ctrl`+`R`	Find / Find and replace
`F3` / `Shift`+`F3`	Next / previous match
`Ctrl`+`H` / `Ctrl`+`Shift`+`H`	Find the selection or the word at the cursor, forwards / backwards

Results¶

Keys	Does
`Ctrl`+`C`	Copy the selected cells
`Shift`+`Enter`	View or edit the value
`Ctrl`+`Insert`	Add a row
`Del`	Delete the selected rows, or take that back
`Ctrl`+`Shift`+`N`	Set the selected cells to `NULL`
`F5`, `Ctrl`+`R`	Run the query again

The database browser¶

Keys	Does
`Enter`	Open the selected table, view or object
`F5`, `Ctrl`+`R`	Read the schema again