Settings
The gear icon at the top right opens the settings. They have three tabs: General, Connections and Über NovaSql (About). Save stores your changes.
General
| Setting | Effect |
|---|---|
| AI provider, Anthropic API key, AI model | see Setting up AI |
| Language | German or English, takes effect immediately |
| Color theme | Dark, Light or High contrast |
| Editor font size | Font size in the query editor, default 14 |
| Max result rows | How many rows are loaded per result set, default 10,000. 0 = unlimited |
| Default schemas in explorer | Comma-separated, e.g. dbo, sales. These schemas are preselected in the explorer; empty = all |
| Folder for queries | Suggested by Save As; empty = Documents |
| GitHub token, Git author name, Git author email | for Source Control |
Max result rows
The limit keeps SELECT * FROM HugeTable from loading millions of rows into memory. The remaining rows are still counted: the result then says "truncated — 1,234,567 rows in total". Note that CSV/TSV export also contains only the loaded rows.
The limit only applies to what NovaSql displays. An UPDATE or DELETE in the same script still affects every row.
Default schemas
If a database has none of the listed schemas, the explorer shows all of them. A database never looks empty just because the setting doesn't fit it.
Color theme and language
Both take effect immediately, without a restart. The sun/moon icon in the header quickly switches between light and dark. High contrast is only available here in the settings.
A few texts of the editor itself (such as its search box) switch language only at the next start.
Connections
The same list as Manage connections in the sidebar, see Setting up connections.
About
Shows the version number as well as the legal notice (Impressum) and privacy policy.