Changelog

Changed

• ERD: Can now choose to display multiple schemas in the diagram. #744
• Import: You can now create a new table when importing. #529
• Import: Now supports importing from parquet and avro files.

Fixed

• ERD: Filtering to start a specific table was not showing tables that did not contain that table’s name.

Changed

• File Formats: CSV, Parquet, and Excel files now save changes back to disk after editing. #751
• Explorer: Added create capability for database objects (triggers, views, procedures, functions, indexes) with dialect-specific SQL across all supported databases. #67
• Results: Added Parquet export format. #730
• Results: Added option to expand a JSON column into unique keys or rows if an array. #710
• Notebooks: Added python language support. #621

Fixed

• Results: Fixed “Export - All” to automatically fetch all rows when row limit is reached. #750

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