Changelog

Changed

• MCP/Copilot: Added separate dbcode-execute-dml and dbcode-execute-ddl tools for granular permission control. #739
• MCP: Breaking Change - Legacy auth modes (Bearer, Querystring) and depreciated SSE transport removed. OAuth provides automatic discovert and secure authentication with approval dialogs for MCP clients, and no need to set query strings, tokens etc. URL has also been changed to http://localhost:PORT/mcp.
• MongoDB: Added create, drop, and rename capabilities to MongoDB collections, matching functionality available for SQL database tables. #66

Fixed

• Connections: Fixed refresh not updating schema metadata when database structure changes (table field types, new databases, etc.). #747
• Azure/SQL Server: Stored procedures and functions were not scriptable. #743

Changed

• Sign in: Added web based sign in option including support for Google. #742

Fixed

• Results: Fixed type collision issue when using data formatters that caused some values to not display.

Changed

• Backup/Restore: Added backup and restore functionality for PostgreSQL MySQL, SQLite, and DuckDB to start to the right click context menu of their databases (uses native tools). #195

Changed

• Definition Provider: Added setting dbcode.definitionProvider.defaultAction to control Cmd/Ctrl+Click behavior on tables/views - choose between opening definition (default) or data viewer. #739
• Results: Data lookup formatters now support cross-database and cross-schema lookups.

Changed

• Scripting: now supports tables, triggers, indexes for most databases (Postgres, Oracle, Snowflake, SQL Server still work in progress). #389
• Copilot: Drag tables to copilot to provide it the table create statement and other context. #723

Changed

• Results: Added data lookup formatters (lookup a value from another table based on the current column value).
• Clickhouse: Removed from preview. #111

Fixed

• MySQL/MariaDB: Fixed DATETIME columns being incorrectly timezone-shifted when displayed in Locale format. #85
• MySQL/MariaDB: Added charset and collation connection settings to configure character encoding. #227
• Results: Fixed Locale date format displaying incorrect datetime values when timezone conversion was applied.
• Inspector: Map view now renders PostGIS geometry columns delivered as EWKB hex. #738

Changed

• Editor: Added Copy Query command and default shortcut to copy the active SQL statement without executing it. #732
• SQL Export: Multi-row INSERT statements now emit as a single batch when the target dialect supports it, while Oracle and other single-row engines still receive individual statements.
• Clickhouse: Added connection option to set driver settings.
• SQLite: Updated better-sqlite3-multiple-ciphers to 12.4.1 (SQLite - 3.50.4). #727

Fixed

• Results Grid: Filter dropdown menus stay open when activated after keyboard shortcut updates.

Changed

• Connections: Post-connection SQL execution option added to connection config (requires Pro/Team). #729

Fixed

• Redshift: Could not open additional connections while introspection was running.

Changed

• Connections: Added Copy Connection String to context menu of connections. #550
• Connections: Support variable substitution in SSL/TLS certificate paths. #728
• Redshift: Introspection now surfaces distribution/sort keys.

Fixed

• Results Grid: Ensure keyboard shortcuts work even when focus is on the toolbar or empty grid space.

Changed

• Athena: Added initial support for Athena. #279
• Trino: Added view support, as well as execution metadata. #279
• Execution Plans: Modified plan format to be more driver based, added support for all existing databases that can produce plans. #376

Fixed

• Results Grid: Inline edits now close when you click empty grid space, including Monaco-backed editors.

Changed

• Editor: Go to definition (cmd/ctrl+click) on tables, views, procedures, functions, etc now opens the alter intent.
• Editor: Right click on tables, views, etc to select open and open with limit options.
• Firebase: Fixed date handling, removed from preview.

Fixed

• Scripting: restored explicit column expansion for the SELECT script option. #726
• Roles: classify CALL/EXEC statements as EXECUTE rather than unknown. #725

Changed

• View Editing: View editing is now supported for databases that support it.
• Inspector: the inspector panel now has a map icon, which will render geo data on a map. #566

Fixed

• Results: Date filters were not loading with fully loaded data. #721
• History: Fixed issue where truncated SQL was being used when loading or copying queries from the tree view instead of full SQL. #720
• LibSQL: Not correctly detecting libc on linux systems causing failure to download the native bindings. #718
• Chat: Fixed issue where where VSCode was trying to infer the default connection, and it was not set. #656

Changed

• Execution Plans: Added DuckDB and BigQuery support.
• Execution Plans: Added config option to aggregate grouped column values.

Fixed

• History: Fixed crash with large history files (300MB+) by removing dedicated search index. #715

Changed

• Script Generation: Added advanced DML script options - MERGE, INSERT ON CONFLICT (UPSERT), UPDATE FROM, and DELETE USING. #349
• Script Generation: Improved SQL formatting with clauses on separate lines for better readability
• Execution Plans: Improved charts. #376
• Execution Plans: Added Clickhouse, libSQL, Snowflake support
• Execution Plans: Added icons for explain, analyze to the editor title menu section when supported.
• Keyboard Shortcut: Changed shortcut to shift+ctrl+cmd/windows+o to choose database (or connection) when in a SQL file. #690

Fixed

• BigQuery: Fixed introspection error for dataset names containing hyphens. #701
• Script Generation: Fixed issue where identity/auto-increment columns were incorrectly included in INSERT statements. #349
• Script Generation: Fixed issue where default value functions like CURRENT_TIMESTAMP were being incorrectly quoted. #349

Changed

• Connection Groups: Added custom sorting via drag & drop. Groups can now be reordered by dragging them to new positions. #707
• History: Added search, added table open.
• History: Added multi-device sync. #709
• History: Converted storage format to binary crdt format.

Fixed

• Results Grid: Cell editor now closes when clicking outside of it, and can be closed with Ctrl/Cmd+Enter. #107