Changelog

Changed

• Grid: Boolean column filters now show True, False, Null, Not Null options instead of generic text filter. #1028
• Transactions: DDL statements (ALTER, CREATE, DROP) are now tracked as uncommitted changes when auto-commit is OFF on databases with transactional DDL (PostgreSQL, SQL Server, Snowflake).
• Transactions: Non-transactional DDL drivers (MySQL, Oracle, DB2) now warn before executing DDL with auto-commit OFF, even with no prior uncommitted changes.
• Roles: Added autoCommit setting to connection roles, allowing per-role auto-commit defaults that override the global defaultAutoCommit setting.
• Tab Titles: Added ${role} variable to dbcode.tabTitle.format for showing the connection role in tab titles.
• Results: Binary cell “Save as File…” context menu to download cell contents to disk with auto-detected file extension.
• Results: Binary cell “Open in Editor” to view and edit binary data in VS Code editors (hex editor, text, etc.) with round-trip saving back to the grid.
• Bunny Database: Added support for Bunny Database (bunny.net) as a cloud libSQL service. #1040
• MongoDB: Added support for multiple hosts in replica set connections without SRV. #1005
• MySQL/MariaDB: Added “Allow Local Infile” option to enable LOAD DATA LOCAL INFILE statements.

Fixed

• Grid: Fixed image preview in binary cells blocking the edit input when clicking to edit.
• Tree: Clicking a table in the tree now keeps focus in the tree, matching VS Code’s native behavior. Enter opens and focuses the table. #1039
• MCP: Fixed dbcode-disconnect tool not working in Copilot Chat (missing tool registration). #1034

Changed

• Monitoring: Preview of server monitoring, with support for Postgres, SQL Server, Oracle, and others.
• AI Assist: Custom model errors now show the provider’s error message instead of a generic status code. Token usage (prompt, completion, total) is displayed after each custom model response.
• MCP: Added dbcode-disconnect tool to allow AI agents to programmatically disconnect database connections and release file locks. #1034
• Results: Added result tab rename via double-click or right-click context menu. Custom names persist across re-executions when the SQL matches. #1033
• Tables: Single-clicking a table reuses the previous tab, double-clicking pins it. Tabs are protected from reuse when editing data, filtered, sorted, streaming, or loading more rows. #1036
• Tree: Ctrl+C / Cmd+C copies selected item names (supports multi-select). F4 opens Script DDL for the selected item. #1039
• Tree: Column tooltips now show type, nullable, primary key, default, FK reference, and comments. #1039

Fixed

• Editor: Fixed output log and tab badges not showing affected row counts for DML statements. #967
• SQL Server: Added FOR SYSTEM_TIME temporal table syntax support in language server. #1027
• Grid: Fixed paste inserting clipboard contents twice on Linux. #1024
• Grid: Fixed two context menus appearing when right-clicking in relation detail grids. #1025
• Export: Fixed Excel export shifting dates back by one day for users in timezones west of UTC.
• DuckLake: Fixed Google Cloud Storage connections getting 403 errors. #1031

Changed

• PostgreSQL: Added Microsoft Entra ID authentication support (SSO, CLI, and Service Principal).
• MySQL: Added Microsoft Entra ID authentication support (SSO, CLI, and Service Principal).

Fixed

• Editor: Fixed autocomplete not providing suggestions when SQL comments precede a statement in Postgres.
• CSV: Fixed file/folder mode not persisting when reopening a CSV folder connection.
• MySQL: Fixed information_schema and other system schema views not appearing in the object browser.

Changed

• SAP ASE (Sybase): Added in preview, requires Java.
• Google Cloud Spanner: Added in preview with support for ADC, Service Account, and Emulator authentication.
• Notebook Export: Python cell outputs (DataFrames, plots, print output) are now included in exports.
• Notebook Export: Python code blocks now have syntax highlighting.

Fixed

• Notebook Export: Fixed PDF and HTML exports not downloading.
• Snowflake: Unified SSO and password auth paths so MFA/SSO only prompts once per connection. #1019
• Grid: Fixed relation icon resolving the wrong foreign key when a different cell was focused. #1022
• Snowflake: Fixed Go to Definition failing for tables and views in non-default schemas by using schema-qualified names in GET_DDL calls. #1021

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

• Export: Added progress overlay with status messages and cancel button during file exports. #980
• PostgreSQL: Added progressive schema loading for faster connections to databases with large schemas. #894 #878
• Explorer: Databases within a connection are now sorted alphabetically, with the configured database pinned to the top. #923

Fixed

• Redshift: Fixed database dropdown only showing the connected database instead of all databases.
• BigQuery: Script CREATE (DDL) for stored procedures now includes IN prefix for input parameters, matching BigQuery Console output. #1000
• SQLite/LibSQL: Fixed computed (generated) columns not appearing in the explorer.
• IBM i: Fixed missing tables, views and tunnel routing issues. #976

Fixed

• Snowflake: Fixed “terminated connection” errors during introspection by validating pooled connections before use. #998
• MySQL: Fixed full compatibility with ShardingSphere-proxy. #987
• Trino/Athena: Progressive schema loading is now enabled by default, preventing a single table with corrupted metadata from blocking introspection. #997
• Favorites: Fixed favorites panel hanging indefinitely on startup. #995
• DB2: Fixed DML statements (INSERT, UPDATE, DELETE) always reporting “0 rows affected”. #996
• Elasticsearch: Fixed connection failure on Elasticsearch versions prior to 7.16 due to unsupported SHOW CATALOGS command. #994

Changed

• IBM I: Added preview support for IBM I (AS/400) databases. #976
• SQLite: Added sqlite-regex extension (PCRE2 regular expressions). #992
• SQLite: Enabled load_extension() for loading custom extensions via post-connection SQL. #992
• Excel Export: Replaced SheetJS with custom XLSX writer using Shared String Table deduplication, producing ~60% smaller files. #980
• Export: All grid exports now use the native VS Code save dialog with Open File/Open Folder/Copy Path actions. #796

Fixed

• MySQL: Fixed compatibility with ShardingSphere-proxy and other MySQL proxies that don’t support IFNULL. #987

Changed

• Query Builder: Visual query builder for constructing SELECT queries with a drag-and-drop. Add tables, configure joins, select columns, set filters, GROUP BY, HAVING, ORDER BY, DISTINCT, and LIMIT. Includes AI assistance for natural language query building, Save/Save As to Favorites.
• AI: AI Assist panel for results. Manipulate query results using natural language. Filter, sort, group, pivot, chart, and more without touching the grid UI.
• Favorites: Favorites folder now appears at the top of database nodes in the connection tree, showing favorites tied to that database. #982

Fixed

• Results: Fixed grid jumping to the first column when clicking a column header while scrolled right. #988
• Export: Excel export performance improved ~2.5x and file size reduced ~60% using compression.

Fixed

• Results: Fixed clicking in the grid sidebar (Inspector, Columns, etc.) stealing focus from the panel.
• Results: Fixed Saved Filters popup not appearing when clicked.