Changelog

Changed

• Language Server: Added dbcode.enableLinting setting to disable SQL linting (syntax and semantic validation). #795

Fixed

• Language Server: Fixed false “Unknown column” errors appearing during initial connection when schema is still loading. #869
• PostgreSQL: Updated bundled pg_dump from 17.6 to 18.1 to support PostgreSQL 18 servers. #871
• Open Table: Now uses workspace default connection when invoked from command palette. #855

Changed

• Elasticsearch: Added support for Elasticsearch (Preview). #323
• QuestDB: Added support for QuestDB (Preview). #527
• ScyllaDB: Added support for ScyllaDB (Preview). #680
• SQLite: Added mod_spatialite extension for spatial SQL capabilities. #867 #576

Fixed

• Cassandra/ScyllaDB: Fixed USE command not updating codelens to reflect the current keyspace.
• Requests: Fixed fetch failing with “Invalid URL protocol” error when proxy is misconfigured or undefined. #868

Changed

• DB Explorer: Default connection (from setting or zero config) now indicated with a star (☆), connected icon change to (●).
• Connections: Connection configured colors now display on the connection item in the tree.
• Zero Config: Discovered connections will be used as default if a workspace does not have an explicit default connection configured, multiple discovered connections will show a prompt to select one on first request. #855
• DuckDB: Added “File Search Path” setting to control where relative file paths resolve from (Database Directory, Document Directory, or Workspace Root). #865

Fixed

• MongoDB: Fixed introspection error when user lacks aggregate permission on system collections. #863
• Notebooks: Fixed Python injection failing with “Invalid \escape” error when data contains backslashes. #864
• AWS SSO: Improved login flow to display authorization code in a persistent notification with clickable link to open browser.

Changed

• SQL Server/Azure: Added backup/restore support. #195
• MongoDB: Added backup/restore support using mongodump/mongorestore. #195
• MongoDB: Added create and drop database support.
• Trino: Now generally available (out of preview).
• Athena: Now generally available (out of preview).

Fixed

• MongoDB: Fixed introspection error when user does not have collStats permission. #863
• Results: Fixed focus not being set on first cell when opening a table. #840
• Zero Config: Fixed connection IDs to be deterministic, allowing workspace default connections to be shared across developers. #855

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

• 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

• Transaction Control: Rolled out to MySQL/MariaDB, SQL Server, Oracle, DB2, ClickHouse, and Snowflake. #368
• PostgreSQL: Added Foreign Data Wrapper (FDW) support to explorer. Foreign servers now appear at database level with their tables and user mappings. Also supported in Yugabyte, Timescale, Greenplum, and RisingWave derivatives.
• PostgreSQL: Filtered out pg_temp and pg_toast schemas from explorer.
• Explorer: Database-level containers (Schemas, Foreign Servers, etc.) are now always shown. Will require re applying any schema filters.
• Explorer: Updated connections to show refreshing icon when introspection is in progress.

Fixed

• Commands: “Alter Table” and “Entity Relationship Diagram” commands failing when invoked from command palette without tree selection.
• PostgreSQL: Fixed foreign tables appearing under Types in explorer.
• Snowflake: Fixed SSO authentication failing in dev containers and remote environments. #814
• ClickHouse: Fallback to SHOW commands when system tables are inaccessible. #817