SQL editor

SQL editor

The SQL editor is a full CodeMirror 6 editor with the MySQL dialect and autocomplete for your databases, tables and columns.

#Running queries

Shortcut Action
⌘/Ctrl + Enter Run the statement under the cursor
Shift + ⌘/Ctrl + Enter Run every statement
⌘/Ctrl + K Open the command palette

Each statement's result opens in its own tab, using the same data grid as the table browser.

#Limits that keep you safe

  • Row cap. Results stop at the row cap (1,000 by default). For the full result, use CSV export.
  • Timeout. SELECTs are stopped by MySQL after the query timeout (30 s by default, via max_execution_time).
  • Cancel. A long-running query can be cancelled from the editor; DBNova runs KILL QUERY on its connection.
  • One statement per call. Multi-statements are turned off at the driver, so a statement can't smuggle in another.

Each user can adjust the row cap and timeout under Settings → Preferences, within the maximums set by the administrator.

#History and saved queries

Every query you run is kept in your history panel. Save a query from your history to keep it and run it again later.

0 views Something unclear? Open an issue on GitHub