HomeFeaturesPluginsDocsDownload

Query editor

A real editor with T-SQL syntax highlighting (AvaloniaEdit), schema-aware autocompletion and multiple tabs, backed by a results grid.

Running queries

Two run commands cover the common cases:

  • F5run the whole query (or just the selection, if you've highlighted one).
  • Ctrl + Enterrun the statement at the cursor.

There's also an Explain action that returns the query plan without executing. On SQL Server, GO is honoured as a client-side batch separator.

Autocompletion & formatting

Press Ctrl + Space for schema-aware completion (it also pops up automatically after a .). The Format command (Ctrl + Shift + F) reflows the query; keyword casing and indent width are configurable in Settings. SQL Server uses a dedicated T-SQL formatter; other engines use a shared formatter.

Tabs & result sets

Open a fresh tab with Ctrl + T; each tab is bound to its own connection and database. A script that returns several result sets shows one grid per set in a result-set strip (labelled Result N · N rows). The grid has dynamic columns per set, a cell viewer that pretty-prints JSON, and a selection summary (count / sum / avg / min / max).

Typed query results are loaded in full. To page through a large table without writing SQL, use Browse mode instead. A global query timeout (off by default) is available in Settings.

Working with .sql files

  • Open a query with Ctrl + O (or drag a .sql file onto the window).
  • Save the tab back to its file with Ctrl + S; Save As writes a new file.
  • A dirty-marker flags unsaved changes; File ▸ Recent lists files you opened lately.
  • Open query tabs are remembered across sessions, so you pick up where you left off.
Closing a tab or the app with unsaved work prompts you to save, discard or cancel — switch that prompt off in Settings ▸ General.
Saving pending grid edits is a different action — Ctrl + Shift + S. See Editing data.