Changelog

Changed

• Explore: Out of preview, supports tables, views and queries with interactive charts, value filtering, date bucketing, calculated fields, and FK drill-down navigation.
• Query Builder: Added NOT IN operator to WHERE and HAVING filter dropdowns.
• Connections: SSL “Trust Server Certificate” replaced with “Certificate Verification” dropdown. New “Verify CA Only” option verifies the certificate chain but skips hostname checking. #1017
• Editor: Green checkmark gutter indicator on successful query execution.
• SQLite, libSQL, D1: Added progressive schema loading for faster connections and isolated error handling per table. #1014
• Snowflake: Added progressive schema loading for faster connections and isolated error handling per table.
• DB Explorer: Added filtering at the schema and database level to show/hide object categories (Tables, Views, Procedures, etc.).

Fixed

• Snowflake: Enabled MFA token caching for password auth to avoid repeated prompts. #1019
• Execution: Fixed Execute button not appearing for SQL statements after BEGIN/COMMIT transaction blocks.
• ClickHouse: Fixed introspection failure for read-only users without access to system.data_skipping_indices. #1018
• SSL: Fixed HTTPS-based drivers (ClickHouse, Trino, Elasticsearch, OpenSearch, RavenDB) failing SSL connections with self-signed or CA-only certificates when VS Code proxy support is enabled. #1010

Changed

• Library: New Library panel replaces Favorites, supporting saved scripts, Query Builder queries, Explore views, and file references organised under Project and Personal scopes with drag-and-drop, folders.
• Favorites: Now shown only within a connection, and stored as part of the connection configuration for portability.
• Formatters: Added “Binary as JSON” predefined formatter to decode hex-encoded BLOB data as JSON. #1011
• ClickHouse: Added progressive schema loading for faster connections to databases with large schemas.

Fixed

• Formatters: Fixed custom formatter showing false validation errors when the formatter targets specific data formats (e.g. hex-encoded JSON). #1011
• Elasticsearch: Fixed connection failure (ProductNotSupportedError) on Elasticsearch versions prior to 7.14. #1012
• Proxy: Fixed HTTP-based drivers (ClickHouse, BigQuery) not respecting http.noProxy VS Code settings. #1010

Changed

• Explore (Preview): New data exploration panel for tables, views, and queries. Analyze dimensions and measures with interactive charts (bar, line, area, pie/donut, scatter), value filtering, date bucketing, calculated fields, and FK drill-down navigation. Available from the tree context menu or the grid toolbar.
• DuckDB: Added progressive schema loading for faster connections to databases with large schemas.
• Results: Added “Unstack” option to split stacked result tabs back into individual tabs. #1007

Fixed

• Parameters: Fixed parameters being incorrectly detected inside SQL comments (single-line -- and block /* */). #1008
• Supabase: Fixed connections failing on newer Supabase projects by using the Management API for temporary credentials instead of SQL-based user creation.
• Results: Fixed tab wrapping and scroll navigation not working. #1006

Changed

• SQL Server: Added progressive schema loading for faster connections to databases with large schemas (SQL Server, Azure SQL, Azure Synapse, Fabric, Dataverse).
• Watched Folders: Watch folders of SQLite, DuckDB, and Access database files. Right-click any folder in the VS Code explorer to add it. Discovered connections appear nested by subfolder structure with live file watching for changes.
• Access: Added zero-config discovery support for .mdb and .accdb files.

Fixed

• Editor: Fixed clipboard shortcuts (copy, cut, paste, select all) not working in Monaco editor popups. #1003
• Oracle: Fixed date format setting being ignored for DATE and TIMESTAMP columns. #1004
• Oracle: Fixed TIMESTAMP columns exporting with incorrect format in SQL INSERT statements.
• Connection Picker: Fixed picker showing “No items found” when selecting a connection that hasn’t been cached yet, now waits for the connection to resolve. #990
• Explorer: Fixed connection retry loops and state management when connections fail or introspection errors occur.
• Favorites: Fixed dragging filtered tree items to favorites not working.

Changed

• Export: Added “Save locally” option to exporting results when connected via VS Code Remote (SSH/WSL/DevContainer) to save exports to local machine instead of remote filesystem. #1001
• Oracle: Added progressive schema loading for faster connections to databases with large schemas. #907

Fixed

• Results: Fixed grid jumping to top-left when clicking scrollbars. #988
• Notebooks: Fixed export from notebook results not triggering the save dialog. #1001
• IBM i: Fixed LIMIT syntax error when opening tables on older IBM i versions by using FETCH FIRST/OFFSET ROWS syntax. #976
• IBM i: Fixed SSH tunnel connections by setting portNumber to bypass the AS/400 port mapper. #976

Changed

• SQLite: Updated better-sqlite3-multiple-ciphers to 12.6.2. #936
• DuckDB: Updated to version 1.4.4. #943
• SQL Server: Added Read Only support for AlwaysOn Availability Group routing via ApplicationIntent=ReadOnly. #940

Fixed

• BigQuery: Fixed stale credentials not being refreshed when re-authenticating via gcloud auth application-default login.
• BigQuery: Added clear error message for GCP RAPT session expiry instead of showing raw JSON error.
• DB2: Fixed SSL certificate paths not being passed correctly. #945
• DuckDB: Fixed “File Search Path” setting not applying to output operations (COPY TO, EXPORT). #944
• Grid: Fixed boolean column filtering generating invalid SQL.
• Editor: Execute shortcuts (Cmd/Win+Enter, Shift+Cmd/Win+Enter, Alt+Cmd/Win+Enter) now run the selected SQL when editing database objects (stored procedures, functions, triggers, etc), instead of applying the whole object.

Fixed

• Procedures/functions: Fixed comments above stored procedures being lost when saving in SQL Server.

Changed

• Data Compare: Right click a tab in the panel, or table in the tree, to compare data. “Compare data with…” menu option, direction toggle, and ability to generate sync scripts or apply changes directly.
• BigQuery: Real-time progress reporting for stored procedures - step completion status now displays in the output log while script jobs execute. #924
• Results: Tab reuse now reuses the currently active tab instead of the last tab. #921
• Results: Hold Alt while executing (Alt+Cmd+Enter / Alt+Windows+Enter) to combine multiple result sets into a single tab. Tabs can also be combined by dragging one onto another or Ctrl/Cmd+clicking to multi-select and using “Stack Selected” from context menu.
• Results: Added “Stack with…” right-click menu option for tab combining with visual selection mode.

Fixed

• Results: Tab reuse now reuses the currently active tab instead of the last tab.
• Results: Fixed output log not showing all recordset rows on first execution.
• Favorites: Fixed favorites disappearing when adding items while a filter was active in the connections tree.
• ERD: Fixed export to PNG/PDF failing with “Failed to fetch” error. #931
• ERD: Fixed export to web page not rendering tables for schema-less databases.

Changed

• BigQuery: Output log now displays individual SQL statements for each step when executing stored procedures. #924
• Results: Output log now has clickable row counts to navigate directly to result tabs. #924

Fixed

• Redshift: Fixed Explain button failing with FORMAT parameter error.
• Results: Fixed Shift+Execute triggering license prompt instead of refreshing the last result tab. #921
• Connection Import: Added support for JDBC connection strings (e.g., jdbc:db2://host/db). #927

Changed

• Salesforce: Preview support added for Salesforce.
• DB Explorer: Tree filter now searches cached schemas, not just active connections.
• BigQuery: Progressive introspection enabled. #925

Fixed

• BigQuery: Fixed “Premature close” error when queries return more than 40K rows by enabling driver pagination. #925
• SSH Tunnels: Fixed SSH Agent authentication with Pageant on Windows failing with “Failed to retrieve identities from agent”.
• Elasticsearch: Fixed connection errors with Elasticsearch 7.x and 8.x servers caused by incompatible version headers in client v9.
• Elasticsearch: Made Catalog field optional. Leave empty to use the local cluster.

Changed

• Inferred Relationships: Ability to define relationships for databases without native foreign key support (MongoDB, DynamoDB, etc.). Configure patterns in connection settings or visually in the entity relationship diagram to detect relationships based on column naming conventions (e.g., user_id → users.id).
• Results: Hold Shift while executing (Shift+Cmd+Enter / Shift+Window+Enter) to refresh the last result tab instead of opening a new one, preserving chart configuration. In single-tab mode (maxTabs=1), this behavior is inverted. #921
• Results: Added column selection via Shift/Cmd/Ctrl+click on column headers, or “Select Column” in context menu. Shift selects a range, Cmd/Ctrl adds to selection. #921
• Athena: Added multi-catalog support. Database list now shows all data catalogs (data sources) including federated connectors. #920
• Settings: Added dbcode.discovery.enabled setting to disable automatic zero-config connection discovery from workspace files (.env, config files, etc.).

Fixed

• Formatting: SQL formatter now properly respects .editorconfig insert_final_newline setting at file level.

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

• 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

Changed

• Core Plan: Testing usage-based access for select Pro features. Core users can now use certain features up to a limited number of times per month.
• Oracle: Ability to alter packages.
• SQL Server: Statements with DECLARE, temp tables, or variable assignments now stay together as one batch unless separated by GO or blank lines. #822
• Language Server: Added Snowflake support.
• History: Added setting to enable logging of failed queries. #827

Fixed

• ERD: Fixed position saving not persisting correctly. #829
• Results: Fixed WHERE filter input not expanding to fill available space when toolbar is constrained. #828
• MySQL: Fixed ER diagrams incorrectly showing One-to-Many relationships for foreign keys with UNIQUE constraints.

Changed

• Export: You can now export a table, view, or filter directly from the explorer in the right click context menu. #559 #796
• Language Server: Added multi-schema search path support for completions and semantic validation (PostgreSQL search_path, Oracle multi-schema access, SQL Server schema resolution). #773

Fixed

• CockroachDB: Fixed introspection error when connecting via zero-config with postgres:// protocol by auto-detecting CockroachDB and switching to the correct driver. #823
• Language Server: Fixed ClickHouse parser to support trailing commas in CREATE TABLE column lists. #818
• Language Server: Fixed Trino and ClickHouse UPDATE/DELETE WHERE completions not suggesting table columns.
• Language Server: Fixed ClickHouse UNION queries requiring ALL keyword when optional syntax is valid.
• Language Server: Fixed ClickHouse ORDER BY WITH FILL syntax not being recognized. #795