Skip to content
Install

Changelog

Recent releases below. Older versions are listed in the archive at the bottom of this page.

Recent releases

v1.38.13

Changed

  • CLI: dbcode open and dbcode introspect work from a Dev Container, Remote-SSH or WSL terminal in VS Code.
  • DuckLake, Iceberg: Added the Extensions setting to pre-load DuckDB extensions on connect.
  • Connections: A failing startup SQL script now stops the connection from opening.
  • Power BI: Moved out of Preview.
  • Quick Open: Type at any level to search objects across connections, recently used connections first; schemas not loaded yet can be loaded from the list.
  • Connections: New tunnel and authentication profile settings layout.

Fixed

  • Appwrite: Fixed grid filters, sorting and paging returning the wrong rows.
  • BigQuery: Fixed BEGIN…END, IF, WHILE, LOOP and FOR blocks being split at their inner semicolons.
  • Execution: Fixed SQLite triggers and MySQL procedures containing CASE merging with the next statement.
  • Convex: Fixed grid filters, sorting and paging returning the wrong rows.
  • Databricks: Fixed BEGIN…END compound statements being split at their inner semicolons.
  • Db2: Fixed BEGIN ATOMIC blocks being split at their inner semicolons.
  • DuckDB: Fixed $$ strings and CREATE FUNCTION macros splitting into the wrong statements.
  • Firebird: Disconnecting no longer hangs on a running query or leaves a connection open.
  • Firebird: Added SET TERM support, and fixed EXECUTE BLOCK being split at its inner semicolons.
  • Ignite 3, GridGain 9: Writes are now visible right away on other connections.
  • DuckLake, Iceberg: SQL editors now find catalog tables without the catalog name.
  • MariaDB: Fixed BEGIN NOT ATOMIC blocks being split at their inner semicolons.
  • MySQL: Fixed a semicolon inside a # comment splitting the statement.
  • Oracle: Fixed compound triggers and TYPE BODY definitions being split at their inner END statements.
  • PostgreSQL: Fixed queries hanging when the connection pool is limited to one connection.
  • PostgreSQL: Fixed E” strings and functions with a RETURN or quoted body splitting into the wrong statements.
  • Connections: Role permissions now apply to each statement inside a block or batch, not only to the block itself.
  • Snowflake: Fixed $$ procedure bodies and Snowflake Scripting blocks being split at their inner semicolons.
  • SQL Server: Fixed a ;WITH query running without the variables declared above it.
  • SQL Server: Fixed ALTER PROCEDURE, CREATE OR ALTER and PROC bodies without BEGIN…END being cut at the first semicolon.
  • SQL Server: Fixed TRY…CATCH, IF…ELSE without BEGIN, GO with a count and [bracketed] names splitting into the wrong statements.

Permalink

v1.38.12

Changed

  • Connections: New connection settings layout.
  • DuckDB: Updated to version 2.0.
  • immudb: Run UPDATE and USE statements, drop indexes and rename tables.
  • immudb: Moved out of Preview.
  • Timeplus: Moved out of Preview.
  • Typesense: Preview support added. #1245

Fixed

  • Meilisearch: Invalid JSON errors underline the exact spot in the editor.
  • OpenSearch: SQL DATE results show as dates instead of shifted timestamps.

Permalink

v1.38.11

Changed

  • Explorer: Choose how a connection’s tree is laid out: Standard, Simple, Flat or By object type (SSMS style), per connection or as a default.
  • Editor: Join suggestions include tables whose foreign keys point at a table already in the query.
  • Meilisearch: Preview support added. #1245
  • Oracle: Added an Edition picker for databases that use edition-based redefinition.
  • Editor: A subquery’s column from the outer query is shown as a hint instead of an unknown-column warning.
  • Editor: Column completion offers alias.column only for columns shared by joined tables, or once you type a table name or alias.

Fixed

  • Editor: Fixed false syntax errors in Oracle, MariaDB, Databricks, Trino, SQLite and PartiQL.
  • Hive: Failed queries now show the server’s error message instead of “The operation failed due to an error”. #1261
  • Hive: Tables and views still list when the server can’t load metadata for one of them, such as Spark Thrift Server with an Iceberg table. #1259
  • Oracle: Scripted and pasted DDL with EDITIONABLE or NONEDITIONABLE now runs correctly, including non-editionable objects in edition-enabled schemas.
  • Explorer: Refreshing a connection or database keeps the tree expanded and the selection in place. #1260
  • Editor: Fixed false column warnings for JOIN USING, NATURAL JOIN, upsert and trigger rows, and MariaDB CTEs.
  • Editor: Improved SQL completion and error checking for joins, subqueries, CTEs and unfinished statements.

Permalink

v1.38.10

Changed

  • Editor: Execute shows the run as Connecting straight away, and an unreachable server reports its error once instead of retrying.
  • Oracle: Added a Connect As option (SYSDBA, SYSOPER, SYSBACKUP, SYSDG, SYSKM) for administrative logins such as SYS.
  • Connections: Added AWS IAM authentication for Amazon RDS and Aurora PostgreSQL, MySQL, and MariaDB through AWS auth profiles.
  • Connections: Re-authenticate runs az login for Azure CLI auth profiles.
  • Results: Result tabs show the file that ran them, and switching editors selects that file’s latest result.

Fixed

  • Auth Profiles: AWS profiles with temporary credentials, such as from aws-azure-login, now pick up refreshed credentials without reconnecting.
  • Results: Fixed the panel sometimes showing no tab after running a query.
  • CLI: --app and editor auto-detection find Antigravity IDE’s connections.
  • Editor: Fixed CodeLens icons sitting flush against their labels.
  • Editor: Fixed a failed connection showing “message must be set” instead of its error.
  • Editor: Fixed Execute doing nothing until a window reload after a connection went stale.
  • AI: Inline completions no longer use Copilot, so they don’t consume Copilot premium requests.
  • MCP: describe-table now finds views, external tables and system tables. #1258
  • AI: Antigravity, Kiro and Windsurf agents keep their DBCode connection after DBCode updates.
  • openGauss: Fixed expanding a schema failing with “column s.synlink does not exist”.
  • PostgreSQL: Fixed backup failing with “server version mismatch” when the installed pg_dump is older than the server (macOS and Windows).
  • QuestDB: Fixed Drop and Truncate table failing with “unexpected token [.]”.
  • Redshift: Fixed IAM authentication with AWS auth profiles failing with “Auth profile did not return a password”. #1256
  • Redshift: Fixed IAM authentication on Redshift Serverless workgroups.
  • Backup/Restore: Fixed MySQL and SQLite restores failing when a database name or file path contains spaces or shell characters.
  • MySQL: Fixed table details failing on ShardingSphere with “SQL federation does not support”.
  • Snowflake: Fixed queries failing with “Unknown role” when a Security Role is set.
  • TiDB: Fixed Explain and Analyze failing with “explain format ‘json’ is not supported now”.
  • Results: Fixed the cell tooltip covering the right-click menu.

Permalink

v1.38.8

Changed

  • Authentication Profiles: Added a Test button for command profiles. #1251
  • Dameng: Moved out of Preview.
  • DuckDB: Updated to version 1.5.5. #1244
  • Results: Run tab rows now jump to their statement in the editor and support multi-select copy. #1248
  • SAP HANA: Moved out of Preview.
  • MariaDB: Added Integrated (Kerberos) authentication, including Windows SSPI. #1249

Fixed

  • Authentication Profiles: Command expiry can be read in seconds, minutes or ISO dates. #1250
  • Authentication Profiles: Commands that write warnings to stderr no longer fail.
  • MariaDB: Fixed tables not loading on MariaDB 10.0 and 10.1. #1247

Permalink

v1.38.7

Changed

  • Results: Column and right-click menus list the active filters, and picking one jumps to its column.
  • Results: Grid scroll bars now show only while hovering the grid.
  • Results: Shift+Space selects the row, Ctrl+Space selects the column.
  • Results: Tab on the last cell of an editable table adds a new row.
  • Table Designer: A failed MySQL or MariaDB apply now restores the keys, indexes and constraints it had dropped.
  • Table Designer: Oracle tables open in the designer.
  • Query Builder: The + button on a Columns row adds the same column to the SELECT again.
  • Query Builder: Pick WHERE and ORDER BY columns from a searchable list, and pick a WHERE value from the column’s data or another column.
  • SAP ASE (Sybase): Added a Character Set connection option.
  • Editor: New untitled and unassigned .sql files now use the workspace default connection. #1241

Fixed

  • DB2: Fixed z/OS schema introspection failing on index, column, constraint, check, trigger, routine and sequence queries. #1015
  • Data: Fixed the inline WHERE filter erroring on tables whose name is a reserved word, like SQL Server [user].
  • Results: Fixed the cell tooltip failing to open on number, boolean and JSON values.
  • SAP ASE (Sybase): Pasted jdbc:jtds:sybase:// connection strings now import.
  • Transactions: Fixed status bar Commit, Rollback and Auto-Commit toggle in non-English VS Code. #1241

Permalink

v1.38.6

Changed

  • AI tools: The connection list now includes each connection’s default database, and the database list flags the default database.
  • ERD: The schema picker now lists every schema and loads a schema’s tables on demand when you select it.
  • ERD: Auto-layout now sizes tables from their content and groups tables without relationships into a compact block, with a toolbar toggle to hide them.
  • Results: JSON messages in the output log (such as a RAISE NOTICE payload) are now syntax-colored.
  • Results: Output log messages now show a formatted tooltip on hover, with JSON pretty-printed.
  • Query Builder: The aggregate dropdown offers COUNT DISTINCT, SUM DISTINCT and AVG DISTINCT.
  • Query Builder: Can be opened from a table’s context menu, hover icon or grid toolbar.
  • Query Builder: Tables added to the canvas are placed to the right, not below.
  • Cloudflare R2 SQL: Moved out of Preview.
  • Results: Numeric values in data grid cells are now right-aligned, toggle it in the grid settings menu or with dbcode.rightAlignNumbers.
  • Stripe: Moved out of Preview.
  • Results: Cell values in data grids are now syntax-highlighted (JSON, arrays and XML), toggle it in the grid settings menu or with dbcode.syntaxHighlighting.

Fixed

  • ERD: Fixed the schema picker not selecting or deselecting schemas when clicked. #1237
  • ERD: Refreshing a table no longer snaps the diagram back to the default schema.
  • SQL Server: Fabric and Synapse serverless no longer probe unsupported metadata views, fixing introspection errors and a stall. #1235
  • PostgreSQL: Notice messages now keep their raw text so a JSON payload stays intact, and show the severity as the action.
  • Query Builder: AI-generated filter values are no longer double-quoted in the SQL.
  • Query Builder: Joins on more than one column pair now draw a line for every pair instead of only the first.
  • Query Builder: WHERE and ORDER BY column dropdowns follow the table column order, so columns added via Add column no longer sink to the bottom.
  • Editor: Fixed qualified table autocomplete disappearing after the first character in MySQL/MariaDB/BigQuery and Oracle. #1238
  • Stripe: Deep grid paging no longer refetches from the first page each time.

Permalink

v1.38.5

Changed

  • File connections: Parquet, Arrow, and Avro tables now show a Metadata node with the file’s embedded key/value metadata.
  • Files: CSV, Excel, Parquet and Arrow rows can be edited without selecting key columns, including duplicate rows. #1191
  • InfluxDB: Added support for InfluxDB 2.x via a version selector on the connection, using InfluxQL. #1234

Fixed

  • AI: The inline completion sign-in hint now shows once per window instead of on every pause.
  • DB2: Fixed z/OS detection so connections no longer fail on the LUW-only SYSIBMADM.ENV_INST_INFO view. #1015
  • Connections: Test now opens or reuses the connection’s tunnel before connecting. #1232

Permalink

v1.38.4

Changed

  • CLI: dbcode introspect refreshes a connection’s database or schema from the terminal.
  • CLI: dbcode mcp serves the DBCode MCP tools itself when no editor is running, under the same roles, licence and masking rules.
  • CLI: dbcode open opens a tab of its own; --preview keeps the preview behaviour. New tables are found without a manual refresh.
  • Cube: Moved out of Preview.
  • Connections: Secondary secrets can now be stored in the OS secret store.
  • Oracle: Progressive loading now hides Oracle-maintained schemas and their public synonyms (SYS and similar) by default; enable “Include Oracle Maintained Schemas” to show them.
  • Table Designer: The plan now shows its success and failure paths as a branching flow, and a running apply can be cancelled.

Fixed

  • AI tools: Query, schema, and copy tools now require an explicit database when the connection has more than one. #1231
  • Oracle: Fixed schema loading failing with ORA-01795 on databases with more than 1000 owners. #1230
  • Oracle: Fixed TIMESTAMP and INTERVAL columns showing a doubled precision such as TIMESTAMP(3)(3).

Permalink

All releases

2026

2025

2024