#Settings reference
The table below is generated from the root and companion extension manifests during the documentation build. Values are defaults, not recommendations for every warehouse. Open JustyBase: Open Settings or edit .vscode/settings.json with the exact key.
| Setting | Default | Description |
|---|---|---|
justybase.cacheTTL |
12 | Metadata cache time-to-live in hours. Cached schema, tables, and columns will be refreshed after this period. Default: 12 hours. |
justybase.codeLens.enabled |
false | Show CodeLens toolbar at top of document and per-statement actions (Run, Explain, Visualize Query Flow, Export). |
justybase.codeLens.explain |
false | Show 'Explain' button in top-level CodeLens toolbar. |
justybase.codeLens.export |
false | Show 'Export' button in top-level CodeLens toolbar. |
justybase.codeLens.import |
false | Show 'Import' button in top-level CodeLens toolbar. |
justybase.codeLens.markdown |
false | Show 'MD' (Markdown export) button in top-level CodeLens toolbar. |
justybase.codeLens.openAsXlsb |
false | Show 'Open as XLSB' button in top-level CodeLens toolbar. |
justybase.codeLens.openAsXlsx |
false | Show 'Open as XLSX' button in top-level CodeLens toolbar. |
justybase.codeLens.run |
false | Show 'Run' button in top-level CodeLens toolbar. |
justybase.codeLens.runBatch |
false | Show 'Run Batch' button in top-level CodeLens toolbar. |
justybase.copilot.enabled |
true | Enable AI-powered SQL assistance features (Fix SQL, Optimize SQL, Explain SQL, Generate SQL). When disabled, no data will be sent to GitHub Copilot and all AI features will be unavailable. |
justybase.copilot.maxWorkspaceProfilesInContext |
5 | Maximum number of workspace Copilot table profiles included in one Copilot request context. |
justybase.copilot.prompts.explain |
Explain what this Netezza SQL query does: | Prompt used for explaining SQL queries. |
justybase.copilot.prompts.fix |
Fix the syntax errors in the following Netezza SQL query: | Prompt used for fixing SQL queries. |
justybase.copilot.prompts.optimize |
Optimize the following Netezza SQL query for performance and readability: | Prompt used for optimizing SQL queries. |
justybase.copilot.requestTimeout |
60000 | Copilot API request timeout in milliseconds (default: 1 minute) |
justybase.copilot.skipPrivacyConfirmation |
false | Skip the privacy confirmation dialog before sending data to AI. Enable only if you understand the data transmission implications and have verified your organization's data policy. |
justybase.ddl.cacheTTL |
3600000 | DDL cache time-to-live in milliseconds (default: 1 hour) |
justybase.ddl.maxTablesForContext |
10 | Maximum number of tables to include in Copilot DDL context |
justybase.enableStreaming |
true | Enable streaming mode for query results. When enabled, results are sent to the UI in chunks for better memory efficiency and faster first-data display with large result sets. |
justybase.filePreview.csvPreviewMode |
custom | Choose the default preview mode for CSV files. 'custom' uses the Netezza Data File Preview with advanced features. 'native' uses VS Code's built-in CSV preview. |
justybase.filePreview.maxRows |
20000 | Maximum number of rows to display in the file preview (Parquet, XLSX, XLSB, CSV). Increasing this value may affect performance for large files. |
justybase.formatSQL.keywordCase |
upper | Keyword case in formatted SQL. |
justybase.formatSQL.tabWidth |
4 | Number of spaces for indentation in formatted SQL. |
justybase.highlightActiveStatement |
true | Enable highlighting of the active SQL statement. |
justybase.importWizard.backgroundValidationEnabled |
true | Enable asynchronous background validation for large imports. When enabled, validation runs in the background after the initial preview loads. |
justybase.importWizard.backgroundValidationSampleSize |
5000 | Number of rows to validate in background for large imports. Higher values provide more thorough validation but take longer. |
justybase.importWizard.defaultMode |
prompt | Default mode for the Import Data command. Use prompt to choose each time, simple to keep the current best-effort flow, or advanced to open the import wizard directly. |
justybase.importWizard.previewRowCount |
10 | Number of rows shown in the advanced import wizard preview grid. |
justybase.importWizard.validationSampleSize |
25 | Number of preview rows validated synchronously in the advanced import wizard. |
justybase.linter.enabled |
true | Enable SQL linting for Netezza files. |
justybase.linter.mode |
advanced | Linting mode. Advanced parser-based SQL validation is always used. |
justybase.linter.rules |
{"NZ001":"warning","NZ002":"error","NZ003":"error","NZ004":"warning","NZ005":"hint","NZ006":"information","NZ007":"information","NZ008":"warning","NZ009":"hint","NZ010":"information","NZ011":"warning","NZ012":"warning","NZ013":"information","NZ014":"error","NZ015":"warning","NZ016":"warning","NZ017":"information","NZ018":"warning","NZ019":"error","NZ020":"information","NZ023":"information","NZP001":"error","NZP002":"error","NZP003":"warning","NZP004":"error","NZP005":"error","NZP006":"error","NZP007":"warning","NZP008":"information","NZP009":"information","NZP010":"information","NZP011":"warning","NZP012":"error","NZP013":"warning"} | Configure SQL linter rules severity. Available rules: NZ001 (SELECT *), NZ002 (DELETE without WHERE), NZ003 (UPDATE without WHERE), NZ004 (CROSS JOIN), NZ005 (Leading wildcard LIKE), NZ006 (ORDER BY without LIMIT), NZ007 (Inconsistent keyword case), NZ008 (TRUNCATE), NZ009 (Multiple OR), NZ010 (Missing table alias), NZ011 (CTAS missing DISTRIBUTE ON), NZ012 (UPDATE with AS alias), NZ013 (UNION vs UNION ALL), NZ014 (OR in JOIN condition), NZ015 (Function in WHERE), NZ016 (Implicit Casting in Join), NZ017 (Double Quoted Identifiers), NZ018 (Self-referential JOIN), NZ019 (CASE without END), NZ020 (IN (SELECT) subquery), NZ023 (Qualify table references), NZP001 (Missing BEGIN_PROC/END_PROC), NZP002 (Missing LANGUAGE clause), NZP003 (Missing RETURNS clause), NZP004 (Unmatched BEGIN/END blocks), NZP005 (Unmatched IF statement), NZP006 (Unmatched LOOP statement), NZP008 (Unused variable), NZP010 (RAISE without severity), NZP011 (Missing INTO in SELECT), NZP012 (Incorrect ELSIF syntax), NZP013 (Missing THEN), NZP017 (Unmatched CASE), NZP022 (OUT/INOUT assignment), NZP024 (Missing RETURN). On-demand procedure heuristics: NZP007, NZP009, NZP014, NZP015, NZP016, NZP018, NZP019, NZP020, NZP025, NZP026, NZP027, NZP028, NZP029, NZP030. Values: error, warning, information, hint, off. |
justybase.logging.level |
INFO | Logging level for extension output channel |
justybase.longQueryAlertThreshold |
10 | Notify when a query execution exceeds this threshold (in minutes). Set to 0 to disable. |
justybase.mcp.connectionName |
Name of the Netezza connection explicitly selected for both MCP transports. The active editor connection is not used. Select it in JustyBase Settings → MCP Server. | |
justybase.mcp.enabled |
false | Register the read-only Netezza MCP server (stdio) for Copilot Chat in VS Code. Passwords are passed to the server process via environment variables and are never written to disk. |
justybase.mcp.externalEnabled |
false | Start the Netezza MCP server in HTTP mode on 127.0.0.1 so other MCP clients on this machine (Cursor, Claude Desktop, ...) can use the read-only schema tools. Runs only while VS Code is open. |
justybase.mcp.port |
37210 | TCP port for the Netezza MCP server HTTP mode (127.0.0.1 only). |
justybase.metadata.queryConcurrency |
1 | Maximum number of concurrent metadata catalog queries. The safe default is one query per connection; increase only when the Netezza workload allows it. Applied to per-connection query limiting in the extension host and metadata warm-up batching in the language server; a full Netezza connection refresh remains serialized on one shared session. Default: 1. |
justybase.metadata.sessionSweep.enabled |
true | Automatically drop stale metadata catalog sessions that exceed the configured age (DROP SESSION). Only affects sessions created by metadata/prefetch queries; user queries are never touched. |
justybase.metadata.sessionSweep.intervalMinutes |
5 | How often the metadata session sweeper checks for stale sessions. |
justybase.metadata.sessionSweep.maxAgeMinutes |
20 | Metadata catalog sessions older than this many minutes are dropped automatically (DROP SESSION). Requires system admin privileges on Netezza. |
justybase.metadataCache.crossWindowSync |
true | Synchronize metadata cache across multiple VS Code windows using file-system watch + polling. When enabled, a window that finishes a prefetch notifies other windows to reload from disk instead of re-fetching from the database. |
justybase.metadataCache.diskPersistence |
true | Persist metadata cache to disk between VS Code sessions (enabled by default). When enabled, metadata is loaded instantly from disk on startup, avoiding slow database prefetches. Disable only if the cache file takes up too much disk space. |
justybase.metadataCache.memoryWarningBytes |
268435456 | Estimated in-memory metadata cache size (bytes) above which a warning is logged when viewing cache stats. Default: 256 MB. |
justybase.pythonArgs |
[] | Arguments passed to the configured Python executable before the script, for example ["-3"] with the Windows py launcher. |
justybase.pythonPath |
python | Python executable for running scripts. Use justybase.pythonArgs for interpreter arguments. |
justybase.query.executionTimeout |
3600 | Query execution timeout in seconds (default: 1 hour) |
justybase.query.rowLimit |
200000 | Maximum number of rows to fetch per query execution |
justybase.results.copyFormat |
markdown | |
justybase.results.decimalGrouping |
true | Use grouped thousands for NUMERIC and DECIMAL result columns. |
justybase.results.decimalScale |
4 | Default number of decimal places shown for NUMERIC and DECIMAL result columns. |
justybase.results.decimalSeparator |
. | Decimal separator used in formatted NUMERIC and DECIMAL result values. |
justybase.results.diskBackedResults.enabled |
true | Spill large result sets to a temporary SQLite database to reduce memory usage. |
justybase.results.diskBackedResults.idleSpillMinutes |
0 | Spill idle in-memory results to SQLite after this many minutes without interaction (0 = disabled). |
justybase.results.diskBackedResults.idleSpillRowThreshold |
10000 | Minimum row count for idle spill eligibility. |
justybase.results.diskBackedResults.insertBatchSize |
50000 | Rows per SQLite INSERT batch during spill. |
justybase.results.diskBackedResults.memoryByteThreshold |
134217728 | Approximate host-memory budget in bytes before results spill to SQLite. |
justybase.results.diskBackedResults.memoryRowThreshold |
25000 | Spill result rows to SQLite once this row count is reached (host RAM). |
justybase.results.diskBackedResults.rowThreshold |
500000 | Hard upper row count before disk-backed storage must activate (when enabled). |
justybase.results.gridFontFamily |
Menlo, Monaco, Consolas, 'Courier New', monospace | Font family used by the main results data grid. Use 'editor' to follow the current VS Code editor font, or provide a custom CSS font-family stack. Available: JetBrains Mono, Fira Code, Cascadia Code, Source Code Pro, IBM Plex Mono, Menlo, Consolas, Ubuntu Mono, Droid Sans Mono, Courier New. |
justybase.results.gridFontSize |
12 | Font size (px) used by the main results data grid and row view. |
justybase.results.groupSeparator |
Grouping separator used in formatted result grid numbers. The default is a space. | |
justybase.results.integerGrouping |
true | Use grouped thousands for integer-like result columns such as SMALLINT, INT, and BIGINT. |
justybase.results.maxDataResults |
50 | Maximum number of data result sets to keep per SQL file. Older unpinned results are automatically pruned when this limit is exceeded. |
justybase.results.maxPinnedDataResults |
10 | Maximum number of result sets that can be manually pinned per SQL file. |
justybase.results.preserveTrailingZeros |
true | Preserve trailing zeros when rendering NUMERIC and DECIMAL result values. |
justybase.results.roundingMode |
half-up | Rounding mode used when formatted result values need to reduce decimal precision. |
justybase.results.useFormattedValuesForExport |
false | Use formatted display values instead of raw values for result exports initiated from the results grid. |
justybase.safeExecute.enabled |
true | Show confirmation dialog before executing risky SQL (DELETE/UPDATE without WHERE, TRUNCATE). |
justybase.schemaSearch.searchAllDatabases |
false | When enabled, Schema Search queries all databases on the connection. When disabled, only the active/default database is searched (recommended for large Netezza warehouses). |
justybase.showConflictWarnings |
true | Show warning when other SQL extensions (SQLTools, MS SQL, etc.) are detected that may cause conflicts. |
justybase.sql.showHoverTooltips |
true | Show SQL editor hover tooltips for aliases, tables, and columns. |
justybase.sql.showInlineTypeHints |
false | Show inline SQL type hints for resolved qualified columns (for example: alias.column INT8). |
justybase.sql.showSelectionActionHover |
true | Show Run/Export action links when hovering over a non-object part of selected SQL. |
justybase.sql.showSelectionExecutionCodeActions |
true | Show Run/Export actions in the lightbulb menu (Quick Actions) for selected SQL. |
justybase.sqlParser.fastPathThreshold |
1572864 | Character count threshold for using fast lexer-based SQL statement splitting. Files larger than this use the legacy character-scan method which is faster for huge files. Default: ~1.5M characters (1572864). |
justybase.streamingChunkSize |
5000 | Number of rows per chunk when streaming mode is enabled. Larger chunks are more efficient but use more memory. |
#High-impact groups
justybase.query.*controls fetched row limits and execution timeouts.justybase.results.*controls result retention, SQLite spill, formatting, and export display values.justybase.metadata.*andjustybase.cacheTTLcontrol catalog refresh and persistence.justybase.linter.*controls quality diagnostics and severity.justybase.copilot.*andjustybase.mcp.*control AI availability, context, privacy confirmation, and read-only tools.justybase.importWizard.*controls preview and background validation.
Use the exact keys in the generated table. The current query controls are justybase.query.rowLimit and justybase.query.executionTimeout.