Advanced
Settings Reference
Reference for commonly used Nexo SQL Studio configuration settings.
Settings Reference
Database support
Database support does not imply identical features. Connections and SQL worksheets are the starting point; editing, DDL, modeling, transfers, administration and AI operations depend on the engine and workflow. Check the installed version and the relevant guide before relying on an advanced operation.
Supported databases and feature availability · Connection guides
Configure settings in VS Code Settings (Ctrl+,) or directly in settings.json. The tables use names relative to the nexo-sql-studio. prefix; for example, worksheet.pageSize is stored as nexo-sql-studio.worksheet.pageSize.
Connection Settings
| Setting | Type | Default | Description |
|---|---|---|---|
oracleConnections.groups |
object | { "connections": [], "folders": [] } |
Saved connection order and nested folders |
oracleConnections.apexBaseUrls |
object | {} |
APEX base URLs keyed by connection |
oracleConnections.ordsBaseUrls |
object | {} |
Public ORDS base URLs keyed by stable connection ID |
oracleConnections.defaultDeploymentTargets |
object | {} |
Default deployment target IDs keyed by source connection |
oracleConnections.mcpPolicies |
object | {} |
Per-connection MCP access policies |
Search & Navigation
| Setting | Type | Default | Description |
|---|---|---|---|
searchPaths |
string[] or null |
null |
Workspace-relative paths scanned for PL/SQL symbols |
Autocompletion
| Setting | Type | Default | Description |
|---|---|---|---|
intellisense.online.enable |
boolean | true |
Enable online metadata for worksheets and live SQL documents |
intellisense.online.maxObjectsPerConnection |
number | 5000 |
Maximum objects cached per connection |
completion.maxItems |
number | 15 |
Maximum completion items returned |
completion.path |
string | null |
Folder containing custom completion metadata |
Formatting
| Setting | Type | Default | Description |
|---|---|---|---|
formatter.enable |
boolean | true |
Enable document formatting |
formatter.keywordCase |
string | "upper" |
Keyword casing: upper, lower, preserve |
formatter.indentSize |
number | 2 |
Spaces per indent level |
formatter.commaStyle |
string | "trailing" |
Comma placement in multi-line lists |
Snippets & Documentation
| Setting | Type | Default | Description |
|---|---|---|---|
snippets.enable |
boolean | true |
Enable extension snippets |
guides.showOnFirstUse |
boolean | true |
Automatically show selected feature guides the first time they are used |
pldoc.enable |
boolean | true |
Enable documentation snippet generation |
pldoc.path |
string | null |
Folder containing custom pldoc.json |
pldoc.author |
string | "" |
Author name inserted in doc blocks |
Worksheet and History
| Setting | Type | Default | Description |
|---|---|---|---|
worksheet.pageSize |
number | 100 |
Rows fetched per worksheet result page |
worksheet.uncommittedTransactionWarningMinutes |
number | 5 |
Minutes before warning about an uncommitted worksheet transaction; 0 disables it |
history.sql.maxEntries |
number | 500 |
Maximum SQL history entries |
history.objects.maxPerObject |
number | 50 |
Maximum compile snapshots retained per object |
history.objects.maxTotal |
number | 3000 |
Maximum compile snapshots retained across all objects |
MCP Server
| Setting | Type | Default | Description |
|---|---|---|---|
oracleConnections.mcpPolicies |
object | {} |
Per-connection MCP access and confirmation policies |
Offline DDL
| Setting | Type | Default | Description |
|---|---|---|---|
offlineDdl.ignoreStorageClauses |
boolean | true |
Strip storage clauses from exported DDL |
offlineDdl.ignoreTablespaceClauses |
boolean | true |
Strip tablespace clauses from exported DDL |
offlineDdl.stripIdentifierQuotes |
boolean | false |
Remove double-quoted identifiers |
offlineDdl.restructureTableDdl |
boolean | false |
Reorder table DDL into canonical sections |
Logging
| Setting | Type | Default | Description |
|---|---|---|---|
advanced.logging.enable |
boolean | false |
Write diagnostic logs outside development and debug sessions |
advanced.logging.level |
string | "info" |
Minimum enabled log level |
advanced.logging.targets |
string[] | ["file"] |
Write logs to a file, the debug console, or both |