Settings Reference

All settings are prefixed with nexo-sql-studio. Configure them in VS Code Settings (Ctrl+,) or directly in settings.json.

Connection Settings

Setting	Type	Default	Description
oracleConnection.enable	boolean	false	Enable Oracle connection features
oracleConnections.groups	array	[]	Saved connection folder groups
oracleConnections.apexBaseUrls	object	{}	APEX base URLs keyed by connection
oracleConnections.mcpPolicies	object	{}	Per-connection MCP access policies

Search & Navigation

Setting	Type	Default	Description
searchPaths	string[]	["**"]	Glob patterns for symbol search
searchPathsExclude	string[]	[]	Glob patterns to exclude

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
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.closeOnShutdown	boolean	true	Close worksheet sessions when VS Code shuts down
history.sql.maxEntries	number	500	Maximum SQL history entries
history.objects.maxTotal	number	500	Maximum object history entries

MCP Server

Setting	Type	Default	Description
oracleConnections.mcpPolicies	object	{}	Per-connection MCP access and confirmation policies

Logging

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