Skip to content
v1.31.2
Install

Changelog

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

Recent releases

v1.31.2

Changed

  • SQL Server: Lowered minimum supported version from 2012 to 2008/R2.
  • MongoDB: Bumped driver from 6.14.0 to 6.21.0, picking up SRV/TXT DNS retry on timeout and several TLS improvements.

Fixed

  • Apache Doris: Introspection no longer fails with Unknown table 'dual' on Doris 2.1.x. #1098
  • IBM i, Firebird, Derby, Sybase, Aerospike, PGlite, Pinot, Spanner, Qdrant: Existing connections created before these drivers moved to progressive introspection no longer fail tree expand with “Use v3 progressive introspection”. #1099
  • ERD: Relationship cardinality (1:1, 1:N, N:1) is detected again instead of every edge rendering as N:N.
  • ERD: Multiple inferred relationships from the same source column to different targets are now all rendered. #1100
  • Oracle: Introspection no longer fails with ORA-00904: "AI"."VISIBILITY" on Oracle 10g. #1096
  • SQL Server: CREATE OR ALTER rewrite no longer fails on 2012, 2014, and pre-SP1 2016 — falls back to IF OBJECT_ID … DROP + CREATE for any pre-2016 server.
  • MongoDB: Fixed mongodb+srv:// connection issue. #1091
  • MongoDB: Multi-host connection strings (mongodb://h1:port,h2:port,h3:port/...) can now be pasted via Import Connection String. #1091
  • Webviews: A malformed VS Code color theme no longer fails every DBCode panel with “An error occurred while loading view” — syntax highlighting falls back to a bundled default theme. #1093
  • Oracle: Applying an edited package from the explorer now recreates both the spec and the body.

Permalink

v1.31.1

Fixed

  • Redshift: Fixed SELECT queries always reporting “Success, 0 rows affected” since 1.30.7. #1090
  • IBM i: Fixed SSH tunnel connections failing with ExtendedIllegalStateException: socketProperties: Property was not changed. #976

Permalink

v1.31.0

Changed

  • PGlite: Supports in-memory and directory storage. #939
  • Apache Derby: Preview support added supporting in-memory, directory, and network server modes. #398
  • MCP: stdio transport is now supported and enabled by default. The HTTP MCP server remains available behind the existing dbcode.ai.mcp.autoStart #1074
  • MCP: Auto-registers with VS Code / Cursor’s MCP
  • Settings: Unified row-limit handling across editor, notebook, explore, compare, join, and union. Renamed dbcode.editorRowLimit to dbcode.queryRowLimit

Fixed

  • Editor: PostgreSQL CREATE TRIGGER no longer consumes the next statement. #1086
  • PostgreSQL: Better message when introspection hits a $libdir/... extension load error. #1087
  • Editor: Fixed “command ‘dbcode.editor.exportQuery’ not found” when right-clicking Export Query Results.
  • Notebook: Added Export Query Results action to SQL cells.

Permalink

v1.30.8

Fixed

  • MSSQL: Fixed arithmetic overflow when listing databases on servers with multi-TB databases. #1083
  • Connections: Stopped the false “Connection has changed, do you want to close and reopen it?” prompt firing on certain settings saves.

Permalink

v1.30.7

Changed

  • Editor: Default 100,000 row limit on editor and notebook queries, with a “Row limit reached” status item offering re-run at a higher limit. Configurable via dbcode.editorRowLimit. #476 #724 #1078
  • DB2: Preview support for DB2 for z/OS. #1015
  • DB2: Added progressive introspection.
  • H2: Added progressive introspection.
  • Access: Added progressive introspection.
  • Netezza: Added progressive introspection.
  • SQLite: Updated to 3.53.0

Fixed

  • Results: Fixed editing not working in some cases where SQL contained commented out lines.
  • ClickHouse: Fixed query execution failing with “Multi-statements are not allowed” when the statement has a trailing comment after the semicolon. #1082
  • MSSQL: Windows Integrated Authentication failed with “Failed to load SSPI module” because the native binding download was silently skipped for connections configured via the new auth method UI.
  • PostgreSQL: Script CREATE (DDL) for tables now includes COMMENT ON TABLE and COMMENT ON COLUMN statements. #1077
  • Query Builder: added tables now auto-load their columns when the connection uses progressive introspection.
  • Connections: Reload prompt on connection changes now fires once per connection instead of once per open database.

Permalink

v1.30.6

Changed

  • Monitoring: Stats now group by category (Cache, Memory, CPU, etc.), summary at the top, hover any bar to see its value, across every card simultaneously; click to pin. Added per-metric descriptions, copy-snapshot to clipboard.
  • DynamoDB: Added progressive introspection and system monitoring.
  • Neo4j/Memgraph: Added progressive introspection, transaction monitoring.
  • Language Server: Defer startup until first SQL document opens or a SQL-dependent feature is used. #1066
  • Tabs: Tab preview behavior now respects workbench.editor.enablePreview. Added dbcode.tabPreview setting to override it for data viewer tabs specifically. #1070
  • Tabs: A data viewer tab now auto-locks (won’t be reused as preview) when you type or apply a WHERE filter, sort, paginate, resize or reorder a column, or scroll away from the top.

Fixed

  • Monitoring: Queries now run serially over a single pinned connection per panel, session hints are applied on SQL Server / PostgreSQL / MySQL so monitoring de prioritizes, and default refresh intervals on heavy categories raised from 5s to 10s. #1069
  • SQLite: Fixed ANALYZE throwing “raw() method is only for statements that return data”. #1072
  • Introspection: Expanded “Update Statistics” setting to Trino (+ Athena) and CockroachDB.
  • Introspection: Added row counts and size to single-table refresh for DuckDB, Snowflake, BigQuery, and ClickHouse.
  • Editor: Fixed END keyword outside of procedures causing statement highlighting to extend past active statement.

Permalink

v1.30.5

Changed

  • Editor: Added “Export Query Results” action to export a query’s results directly to a file from the SQL editor. #1062
  • Introspection: Added optional “Update Statistics” setting in connection introspection settings. When enabled, updates database stats before refreshing a single table so the row count in the explorer stays accurate. Supported on Oracle, PostgreSQL, Redshift, MySQL, MariaDB, SQL Server, SQLite, Sybase, Databricks, and Hive. #1054
  • Explore: Added Unique and Zero metrics to measure summary, and a new Summary section for dimensions with Distinct, Unique, Nulls, Empty, and Min/Max for date dimensions. #1064
  • MCP: Added dbcode.ai.mcp.allowExternalConnections setting to expose the MCP server beyond localhost, for Dev Containers or LAN access. Requires OAuth. #741
  • SurrealDB: Added progressive introspection and system monitoring.
  • RavenDB: Added progressive introspection, system monitoring, and connection string parsing.
  • Redis/Valkey: Added progressive introspection, server monitoring, client monitoring, and connection string parsing.

Fixed

  • SQL: Expanded reserved-word list used for identifier quoting with names like character, binary, read, etc. are correctly quoted. #1067

Permalink

v1.30.4

Changed

  • ClickHouse: Progressive introspection is now the default for new connections.

Fixed

  • Results: Fixed chart state being reset when refreshing query results in the same tab. #921
  • Grid: Fixed duplicate “With Headers” item in the Copy As submenu, second one now correctly shows “Without Headers”.
  • ClickHouse: Fixed introspection failure when the server reports “No synonims extensions” error from system.functions query. #1063
  • MCP: Auto-start now starts the MCP server when VS Code opens, rather than waiting for the user to interact with DBCode. #1060

Permalink

v1.30.3

Changed

  • Connections: Changed progressive introspection default for “Prefetch Details” to off for progressive introspection.

Fixed

  • Hive: Parallelized introspection queries. #1053
  • Accounts: Enable generate activation token commands. #1055
  • SAP ASE (Sybase): Fixed stored procedures only returning the first result set when multiple result sets are returned.

Permalink

v1.30.2

Changed

  • InfluxDB: Added progressive introspection, server monitoring, EXPLAIN support, and connection string parsing.
  • Hive/Impala: Added progressive introspection, server monitoring, EXPLAIN support, and connection string parsing.
  • Databricks: Added progressive introspection, server monitoring, EXPLAIN support, and connection string parsing.
  • Elasticsearch/OpenSearch: Added progressive introspection, cluster monitoring, EXPLAIN support, and connection string parsing.
  • Cassandra/ScyllaDB: Added progressive introspection, node monitoring, and connection string parsing.
  • MongoDB: Added progressive introspection.
  • Grid: Added top-level Copy action to context menu for quick one-click copy.
  • Grid: Added Ctrl+Insert keyboard shortcut for copy to support Dvorak keyboard layouts.
  • Accounts: Team admins can generate tokens for seat members to enable automatic license activation via DBCODE_ACTIVATION_TOKEN environment variable. #1055
  • Accounts: DBCODE_REQUIRE_LICENSE environment variable to block all DBCode functionality without a valid license.

Fixed

  • RisingWave: Fixed introspection error caused by missing cache_size column in pg_sequences. #1058
  • MongoDB: Fixed db.collection() method not working in SQL file. #1047
  • Athena: Fixed “mismatched input OFFSET” error when scrolling through table data. #1057
  • SQL Server DW, Access, Sybase: Fixed pagination when scrolling through table data.
  • Editor: Improved syntax highlighting in Monaco editors (inspector, WHERE filter, SQL panel) to match VS Code’s theme colors. #1042

Permalink

All releases

2026

2025

2024