SQL ExplorerSettings
A reference to the user-facing settings, grouped as they appear in the app's Settings window.
They're stored locally in settings.json under %AppData%/Lionear/SqlExplorer/
(on Linux, ~/.config/Lionear/SqlExplorer/) — no secrets or connection data are kept there.
General
| Setting | Default | What it controls |
|---|---|---|
| Language | Follow OS | UI language (NL / EN). |
| Reopen the previous session's query tabs | On | Restore query tabs on startup. |
| Ask to save query files with unsaved changes on close | On | Prompt before closing a dirty .sql tab. |
| Ask for confirmation before quitting | On | Confirm when you close the app. |
| Close to system tray instead of quitting | Off | Keep the app (and the MCP server) running when the window closes. |
| Show system databases | Off | Include engine system databases in the tree (applies on next refresh). |
| Automatically check for updates | On | Check for a new app build at launch. |
| Check every | 4h | Background update re-check interval. |
| Release channel | Follows build | Which channel the updater tracks. |
Appearance
| Setting | Default | What it controls |
|---|---|---|
| Theme | System | System, Light or Dark. |
| Show one bottom panel at a time | On | Opening a bottom panel (Output, AI activity, …) closes the others. |
Editor
| Setting | Default | What it controls |
|---|---|---|
| Font size | App default | SQL editor font size. |
| Word wrap | Off | Wrap long lines in the editor. |
| Keyword casing | UPPERCASE | Casing the formatter applies to keywords (UPPER / lower / preserve). |
| Indent size | 4 | Indent width the formatter uses. |
Query
| Setting | Default | What it controls |
|---|---|---|
| Show a review dialog before saving changes | On | Preview the generated SQL before the save flow runs. |
| Query timeout (seconds, 0 = none) | 0 | Cancel a query after this many seconds. |
| Browse page size (rows) | 200 | Rows fetched per page in Browse mode. |
Query Log
| Setting | Default | What it controls |
|---|---|---|
| Enable query logging | Off | Master switch for the on-disk query log. |
| Application queries | On | Log queries run from the app (when logging is on). |
| AI / MCP queries | On | Log queries run by AI clients (when logging is on). |
Security
| Setting | Default | What it controls |
|---|---|---|
| Master password | Off | Encrypt stored connection secrets behind an app password. |
| Lock after inactivity | Never | Lock the master key after idle time. |
MCP server
The MCP server has its own settings group (enable, port, token, row cap, timeout, secret-scrubbing and the connection-creation policy), covered in AI & MCP.
Plugins
Update notifications chooses how proactive plugin updates behave — Off, Notify, or Auto (stage compatible updates for the next restart). Plugin sources lists the store index URLs the app fetches from. See Plugin types and the Plugin Store.
Keyboard
All shortcuts are rebindable under Settings ▸ Keyboard; only your overrides are stored
(in keymap.json, next to settings.json). See
Keyboard shortcuts for the defaults.