Changelog

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

Changed

• Execution Plans: Initial basic chart support added. #376
• Results Grid: Database selector now automatically syncs with the active editor’s connection. #708

Fixed

• Execution Plans: Added basic support for MySQL plans. #376.
• Editor: Right click execute with DBCode was throwing an error. #705

Changed

• Code Completion: Experimental LS is now complete for Postgres and MariaDB dialects.
• Exports/Share: Web page format now supports a title, date and optional SQL inclusion, along with updated rendering style.
• Execution Plans: Export and Share support added. #376
• Execution Plans: Preliminary support for Oracle added, more stats from SQL Server. #376

Fixed

• Oracle: Fixed environment switching issue where service names were propagating between connections and environments were not properly isolated. #703
• Results Grid: Fixed text jumping issue when hovering over cells with relationship icons. #695
• SQL Server: Fixed inconsistent decimal formatting. #689

Changed

• Execution Plans: Initial preview of execution plan support has been added. #376.
• Connection Pinning: Added Oracle, DB2, ClickHouse, and Snowflake (with SSO token caching) support for connection pinning to maintain session state across query executions. #663
• BigQuery: Use table list api when opening a table (only possible when no sorting or filtering applied). #693
• BigQuery: Added support for dry run query execution. #693
• BigQuery: Always show bytes billed, even if 0. #693
• BigQuery: Added BI Engine information to the meta data display when present. #693

Changed

• Keyboard Shortcut: shift+cmd/ctrl+d shift+cmd/ctrl+b will open up selector to choose database (or connection) when in a SQL file. #690
• Connection Pinning: Added MariaDB, and MySQL to pin a connection to the editor. #663
• Connection Settings: Added variable substitution support for file paths in connection configurations. Supports ${workspaceFolder}, ${workspaceRoot}, ${home}, ${env:VARIABLE_NAME}, and relative paths. #683
• USE Command: Will update displayed database when database supports USE command and connection pinning.
• Bigquery: Added Bytes billed metadata. #693