Changelog

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

• 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

Changed

• Syntax validation: Experimental support for SQL syntax validation added (Postgres and Maria/MySQL initially).

Fixed

• Postgres: Would not format data types correctly on initial table load in some cases. #107
• Excel: Was not filtering reserved words in sheet names. #659

Changed

• Results: VSCode editor now used in JSON/XML datatypes, and can be opened on any field using the open in editor icon (replaces old open in editor). #107
• Connection Pinning: Will now destroy a connection if keep alive statement fails. #578 #648

Fixed

• Trino: Uses line numbers in errors to reduce highlighting when present.
• Export: Fixed issue with SQL Insert statement export. #655
• Inspector: Show correct data types in the JSON view.
• Inspector: Added proper editor to JSON and XML data types. #107

Changed

• Results: Support for data formatting completed.
• Inspector: Updated to use VSCode editor.

Fixed

• DB2: Fixed issue with SSL connections. #652

Changed

• Results: Added support for data formatting (work in progress).
• Results: Selecting a full row and pressing delete/backspace will now delete the row, rather than clear the contents (cmd/ctrl+delete/backspace will delete partially selected row).

Fixed

• Dragging a table to a new window did not load the data.
• Greenplum: Fixed introspection issue. #651
• Doris: Fixed introspection issue. #645
• Results: Fixed issue with sorting other columns, when primary key sorting setting was enabled.

Fixed

• Autocomplete: Fixed issue where it was not working for some databases. #643
• Redshift: Removed JSON method from introspection. #644

Changed

• Connection Pinning: Added support in notebooks, and for Postgres. #578
• Redshift: Added support for external tables (Spectrum). #613

Fixed

• Postgres: Introspection does not get columns for partitioned tables (redundant).
• Postgres: Don’t change schemas for non user based SQL execution. #507
• Oracle: Fixed syntax error being displayed rather than driver error in certain cases.

Changed

• Export/Share: Added support for tab delimiters in CSV export.

Fixed

• Improved introspection performance for large schemas (1000+ schemas)