# Settings Reference

Reference for commonly used Nexo SQL Studio configuration settings.

Source: https://www.nexosqlstudio.com/docs/settings-reference
Language: en
Type: docs

# 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](https://www.nexosqlstudio.com/databases) · [Connection guides](https://www.nexosqlstudio.com/docs/getting-started)

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 |