Changelog

Changed

• Moved create database context menu item to the Connection in the DB Explorer.
• Added context menu item to add a connection to a group.

Fixed

• Connection error with MariaDB 10.5 through 10.6.10.
• Added OUTPUT clause to procedure parameters.

Changed

• Added a fallback autocomplete to use when parser cannot parse the SQL.

Fixed

• SQL Server tables were not editable. #93
• MariaDB 10.4 and below connections did not work if the driver was set to MySQL. #86

Fixed

• Parser error when loading tables from DB Explorer. #90

Fixed

• Autocomplete now works with more complex Select statements (nested selects, alaised tables, etc).
• Autocomplete now works with Delete statements.
• Autocomplete now works with Insert statements, including nested selects.

Changed

• New Charts added to the chart menu.
• Option to expand/shrink the chart. #37

Fixed

• Selecting MySQL for a MariaDB could lead to incorrect introspection being used, this is now fixed.
• Tables named after SQL Keywords (eg user) were not editable.
• Grid lines now show when enabled in a chart. #34
• Autocomplete now suggests operators and multiple condition where clauses.

Fixed

• SQL Server 2016 now works with the DB Explorer.

Changed

• Data can now be changed without signing in/purchasing a subscription, however changes are not verified before applying them when not signed in/subscribed.
• Updated the new connection UI.
• Add the count of items in each “folder” in the DB Explorer.

Fixed

• Introspection is now supported on MariaDB 10.3 and above.

Changed

• Groups can now be renamed in the DBExplorer. #73

Fixed

• D1 now shows views.
• Introspection is now supported on MariaDB 10.0 and above. #74 and #71

Changed

• Table DDL editing now uses transactions where appropriate.
• Custom theme extensions are now supported for syntax highlighting in the table editor.

Fixed

• MongoDB connections can now be created without a username. #70
• MariaDB 10.5 or higher is required.

Changed

• Teams: Added role-based feature restrictions. Team owners and admins can assign roles to members to control access to AI, data export, clipboard copy, data sharing, and history sync. Includes built-in roles (admin, member, no-export, restricted) and support for custom roles. #1049

Fixed

• Grid: Fixed Cmd/Ctrl+C not copying text when editing a cell inline.
• Language Server: Fixed expression aliases being marked as unknown columns in ORDER BY. #1050
• MongoDB: Fixed SQL file execution failing after the first successful query. #1047
• Script DDL: Fixed blank editor opening when DDL generation fails. #1039

Changed

• Monitoring: Added System Info tab showing server information.
• Monitoring: Locks tab uses tree view to show blocked processes under the blocking process.
• Monitoring: Added long-running query notifications, warning when a session exceeds 60 seconds, with Kill Session action.
• SurrealDB: Added support for SurrealDB v3 by upgrading the SDK to 2.x. Minimum server version is now 2.1.0. #1043
• Aerospike: New database driver with SQL support via JDBC. #631
• Apache Pinot: New driver for real-time OLAP analytics. #631

Fixed

• Grid: Fixed reload button becoming unclickable after a table or query error, requiring close and reopen to recover.
• Oracle: Fixed SQL execution failing when statements contain trailing comments (— or /* */). #1044
• Results: Fixed “Set value” context menu targeting wrong row after sorting. #1041
• Grid: Fixed Monaco editor background not matching VS Code theme in WHERE filter and inspector panel. #1042
• Grid: Fixed paste inserting clipboard contents twice in WHERE filter on Linux and WSL. #1024

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