Changelog

Changed

• MongoDB: Added Command authentication provider for retrieving credentials from external secret managers (1Password CLI, Vault, AWS Secrets Manager, etc.) or custom scripts. #496
• Performance: Added experimental background schema worker to build schemas off the main thread. Enable with dbcode.useSchemaWorker setting.

Fixed

• MySQL: Fixed connection timeout on large databases (1000+ tables) by loading database sizes asynchronously. #862
• Authentication Profiles: AWS, auto runs SSO login if needed.

Changed

• DuckDB: Updated to version 1.4.2. #736
• Results: Added keyboard shortcut to focus WHERE filter (Ctrl+Shift+F / Cmd+Shift+F) and vim-style grid navigation (Ctrl+H/J/K/L). #858

Fixed

• Panel: Fixed results panel failing to load when visible during VS Code startup.
• Parameters: Ignore parameters in PREPARE statements. #857
• Language Server: Added ClickHouse support for SELECT * EXCEPT column exclusion syntax and SYSTEM REFRESH VIEW statement. #795

Changed

• Authentication Profiles: Added a view to the explorer to manage authentication profiles. #279

Fixed

• Connection Colors: Fixed empty workbench.colorCustomizations object appearing in workspace configuration file. #836
• File connections: Fixed CSV/Excel/Parquet/Avro file picker defaulting to folder mode on Windows/Linux. #845
• MongoDB: Fixed editing disabled for queries run from the editor. #851
• Results: Fixed parquet export failing when decimal columns are present. #852

Changed

• Auth Profiles: First look at centralized authentication profiles (added to Trino for OAuth). #279
• Results: Auto-focus first cell when switching to results panel for immediate keyboard navigation. #840
• Trino: Added support for OAuth authentication via new authentication profiles.

Fixed

• Databricks: Fixed SSO authentication failing in dev containers and remote environments.
• MongoDB: Fixed multi-line queries failing with “Unexpected end of input” error. #848

Changed

• Auth Profiles: First look at centralized authentication profiles (added to Trino for OAuth). #279
• Results: Auto-focus first cell when switching to results panel for immediate keyboard navigation. #840
• Trino: Added support for OAuth authentication via new authentication profiles.

Fixed

• Databricks: Fixed SSO authentication failing in dev containers and remote environments.
• MongoDB: Fixed multi-line queries failing with “Unexpected end of input” error. #848

Changed

• Databricks: Added preview support. #158
• Editor: Added “Expand SELECT *” command to replace * with explicit column list. Available via keyboard shortcut (Cmd+Shift+E / Ctrl+Shift+E) or lightbulb code action.

Changed

• Databricks: Added preview support. #158
• Editor: Added “Expand SELECT *” command to replace * with explicit column list. Available via keyboard shortcut (Cmd+Shift+E / Ctrl+Shift+E) or lightbulb code action.

Changed

• Tunnels: Added test connection button to tunnel creation/edit.
• Zero Config: Added support for framework-specific .env patterns including Laravel, Django, Spring Boot, and Node.js. #841
• Snowflake: Added support for SF_AUTH_SOCKET_PORT environment variable to use fixed port for SSO authentication callback.
• Alter/Open Table Commands: Where possible they now use the currently open table, and fallback to the quick picker.

Fixed

• Results: Fixed “Get started” screen appearing instead of query results when panel was reopened. #842
• Improved translations for several languages.

Changed

• Netezza: Added preview support. #748
• Explorer: Added drop, rename, create to more objects.
• Notebooks: Python injection toggle now appears in SQL cells even when notebook has no Python cells, enabling injection to external Jupyter notebooks. #621

Fixed

• Language Server: Fixed Windows compatibility issue where ESM dynamic imports. #204
• Connection Colors: Fixed user-level workbench.colorCustomizations being copied to workspace configuration file. #836
• SQL Server: Fixed DECLARE variables not in scope when blank lines exist between declarations and usage statements. #839
• PostgreSQL: Fixed introspection failure when user lacks permissions on pg_user_mapping table. #834
• File connections (CSV/Excel/Parquet/Avro): Fixed connection breaking when files are deleted, mapped tables will now be removed.

Changed

• Backup/Restore: Added backup and restore functionality for PostgreSQL MySQL, SQLite, and DuckDB to start to the right click context menu of their databases (uses native tools). #195

Changed

• Definition Provider: Added setting dbcode.definitionProvider.defaultAction to control Cmd/Ctrl+Click behavior on tables/views - choose between opening definition (default) or data viewer. #739
• Results: Data lookup formatters now support cross-database and cross-schema lookups.

Changed

• Scripting: now supports tables, triggers, indexes for most databases (Postgres, Oracle, Snowflake, SQL Server still work in progress). #389
• Copilot: Drag tables to copilot to provide it the table create statement and other context. #723

Changed

• Results: Added data lookup formatters (lookup a value from another table based on the current column value).
• Clickhouse: Removed from preview. #111

Fixed

• MySQL/MariaDB: Fixed DATETIME columns being incorrectly timezone-shifted when displayed in Locale format. #85
• MySQL/MariaDB: Added charset and collation connection settings to configure character encoding. #227
• Results: Fixed Locale date format displaying incorrect datetime values when timezone conversion was applied.
• Inspector: Map view now renders PostGIS geometry columns delivered as EWKB hex. #738

Changed

• Editor: Added Copy Query command and default shortcut to copy the active SQL statement without executing it. #732
• SQL Export: Multi-row INSERT statements now emit as a single batch when the target dialect supports it, while Oracle and other single-row engines still receive individual statements.
• Clickhouse: Added connection option to set driver settings.
• SQLite: Updated better-sqlite3-multiple-ciphers to 12.4.1 (SQLite - 3.50.4). #727

Fixed

• Results Grid: Filter dropdown menus stay open when activated after keyboard shortcut updates.

Changed

• Connections: Post-connection SQL execution option added to connection config (requires Pro/Team). #729

Fixed

• Redshift: Could not open additional connections while introspection was running.