Ctrl+T opens an editor tab on the window’s connection. In a window with no tab open, Open SQL Editor does the same.
Each result set of a run is its own entry in the results list
Run
A script is split the way its engine reads it,
DELIMITER on MySQL and GO on SQL Server included, and sent one statement at a time, or one batch at a time on SQL Server. A failed statement stops the script, except on SQL Server, where the next batch runs.
Stopping cancels the statement on the server. Cassandra and ScyllaDB have no cancel, so the app stops waiting and the server runs the statement to its own timeout.
The editor gives up on a query after 60 seconds. Change that under Preferences > Editor > Query timeout (seconds), or per connection with Custom Query Timeout in its Options. 0 turns the timeout off.
Results
Each result set, row count, notice and error of a run is its own entry in the results list. A result keeps 10,000 rows and a run 100,000; past that a banner offers Export All…, which runs the statement again on a separate read-only connection and writes every row to a file. After a failed statement, Go to Error puts the cursor where the server places the error. A statement that opens a transaction leaves Commit and Roll Back in the results pane until you pick one. Closing the window asks first while the transaction is open.Completion and snippets
Completion offers tables, views, columns, schemas, functions and keywords, and resolves aliases. Type a snippet’s trigger, pick it in the list, then pressTab to move between its stops and Shift+Tab to go back.
Your own snippets are
.snippets files in GtkSourceView’s snippet format, in the folder Preferences > Editor > Snippets folder shows. Open Folder creates it. A file added or changed takes effect without a restart, and a snippet with the same trigger replaces the built-in one. The format and the per-engine languages values are in the app’s README.
Files and drafts
Ctrl+O opens a .sql file into the tab, and so does dropping one on the editor. Ctrl+S saves back to it and Ctrl+Shift+S saves to another file.
The text of every editor tab is kept as you type. A connection’s tabs, editor tabs with their text and table tabs with their page and sort, reopen when the connection opens.
Multiple cursors
Typing, deleting, pasting and moving work at every cursor, and one
Ctrl+Z takes the edit back at all of them. A click, a find, Format or Page Up returns to one cursor.
Vim mode
Turn on Preferences > Editor > Vim Keybindings. The line under the text shows the mode and the command you are typing, and the editor’s ownCtrl shortcuts keep working in every mode. Every other key goes to Vim, Escape too, so use Stop to stop a running query.
Redis and MongoDB
On a Redis connection the editor takes Redis commands, one per line, and shows each reply asredis-cli does. On MongoDB it takes mongosh statements such as db.orders.find(), aggregate, runCommand, use and show, and shows one document per row.
History and saved queries
Ctrl+Shift+H opens Query History: every run from the editor, with full-text search, filters by connection, time and status, and export as SQL or CSV. A run that can carry a password is left out.
Save Query… in the editor’s menu keeps the text against the connection. Saved Queries in the main menu lists them, the window’s connection first.