Changelog

Changed

• Microsoft Access: Added support for Microsoft Access databases (.mdb, .accdb). (Preview, Windows only). #546
• Transactions: Added dbcode.transactions.defaultAutoCommit setting to control the default auto-commit mode for new pinned connections.
• Schema Switching: Added automatic schema context detection for Oracle, PostgreSQL, DB2, Databricks, and Snowflake when executing schema switch commands.

Fixed

• SQLite: On large databases (1GB+) using approximate ANALYZE with analysis_limit and skipping table size calculations.

Changed

• Microsoft Access: Added support for Microsoft Access databases (.mdb, .accdb). (Preview, Windows only). #546
• Transactions: Added dbcode.transactions.defaultAutoCommit setting to control the default auto-commit mode for new pinned connections.
• Schema Switching: Added automatic schema context detection for Oracle, PostgreSQL, DB2, Databricks, and Snowflake when executing schema switch commands.

Fixed

• SQLite: On large databases (1GB+) using approximate ANALYZE with analysis_limit and skipping table size calculations.

Changed

• DuckDB: Added extensions support for loading core and community extensions on connect.
• Formatting: Improved SQL formatter dialect mappings for ClickHouse, Databricks, Access, CQL, and Elasticsearch.
• Results: Quick search now highlights matching cells in the grid.

Fixed

• SQLite: Fixed slow connection times on large databases (1GB+) by skipping expensive ANALYZE and table size calculations.
• SQL Server: Fixed backup failing on Docker/local instances with SSL certificate errors by explicitly setting encryption mode.
• Commands: Fixed Quick Open and other commands failing on first attempt when extension hadn’t activated yet. #876

Changed

• TiDB: Added support for TiDB. #872
• Trino: Username and password are now optional.

Fixed

• Zero Config: Fixed symlinked .env files not being detected during connection discovery. #855
• MySQL/MariaDB: Added support for MaxScale proxy with dbfwfilter by auto-detecting and disabling multi-statement queries (or manual connection configuration). #870

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.