Changelog

Track our development progress with detailed updates, improvements, and bug fixes.

  • v1.17.2

    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.
  • v1.17.0

    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.
  • v1.16.15

    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
  • v1.16.14

    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
  • v1.16.13

    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
  • v1.16.12

    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
  • v1.16.11

    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
  • v1.16.8

    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
  • v1.16.7

    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
  • v1.16.6

    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
  • v1.16.5

    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
  • v1.16.4

    Changed

    • Results: Added keyboard shortcuts to the tooltips.

    Fixed

    • SQLite: Fixed issue where primary keys were not detected when not present in PRAGMA_index_list.
    • Cassandra: Fixed SSL certificate validation errors. #640
    • Oracle: Fixed crash when using Instant Client after initialization. #674
  • v1.16.3

    Changed

    • Firebase: Added support for editing sub collections.
    • Firebase: Added support for multiple Firestore databases.
    • Code Completion: Experimental LS now provides table/column context and CTE understanding.

    Fixed

    • Trino: Fixed map, array, and row types displaying as “[object Object]” in query results. #670
  • v1.16.2

    Changed

    • Firebase: Handles setting (undefined) for a value to make the key undefined.
    • MongoDB: Handles setting (undefined) for a value to make the key undefined.

    Fixed

    • Added groups to escaped identifier list.
  • v1.16.1

    Changed

    • Result: Editor now auto formats and focuses when opened, as well as auto detecting language.
    • Firebase: Will destructure data into keys where possible allowing specific key editing.
    • Code Completion: Will use new experimental language server if enabled.

    Fixed

    • SQL Server: Fixed BIT columns incorrectly exported as ‘true’/‘false’ instead of 1/0 in SQL Insert statements. #658

Ready to try DBCode?

Install DBCode today and transform your database workflow in Visual Studio Code.