Skip to content
v1.33.0
Install

Changelog

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

Recent releases

v1.33.0

Changed

  • Couchbase: New driver (Preview) - browse buckets/scopes/collections, run SQL++, edit documents. #255
  • Apache CouchDB: New driver (Preview) - browse databases and documents, run Mango queries, edit documents, manage indexes, EXPLAIN, and monitoring.
  • Apache Druid: Preview support added. Connect via the SQL HTTP API, browse the druid/sys/lookup schemas and datasource columns, and run SQL queries.
  • DuckDB: Updated to version 1.5.3, fixing extension installation when behind a proxy. #1117
  • Exasol: Preview support added. Connect over WebSocket to browse schemas, tables, views, functions and scripts, run and edit queries with streaming results, and use transactions and server monitoring.
  • Results: Foreign-key related records now show a header with their source table and match condition; click the table to open it.
  • SQLite: Updated to 3.53.1.
  • DB Explorer: Show table modification (and creation) timestamps in the tooltip and hover for ClickHouse, SQL Server, Oracle, Snowflake, MySQL/MariaDB and BigQuery.
  • Milvus, Qdrant, Pinecone: Added server monitoring panels (Milvus nodes + collections, Qdrant collection status/counts, Pinecone index + namespace stats).
  • Vertica: New database driver (OpenText Analytics Database) with introspection, data editing, DDL scripting, EXPLAIN, and server monitoring. #338

Fixed

  • Results: JSON/XML cells on columns with a default value now open the full-value editor instead of a dropdown that showed (and could save) a truncated value. #1102
  • Elasticsearch, OpenSearch, InfluxDB, D1: Cancelling a running query now aborts the in-flight request instead of being ignored.
  • Azure Synapse: Fixed introspection failing with “Catalog view ‘sequences’ is not supported in this version”. #1115

Permalink

v1.32.4

Changed

  • Editor: Added a DDL link to the table/view hover that opens the full CREATE statement in a new editor. #1079
  • LanceDB: Preview support released. Open a local Lance database directory to browse tables, run vector search with SQL filters, and edit scalar columns.
  • Pinecone: Preview support released. Browse indexes and namespaces, run vector search with metadata filters, and edit record metadata.
  • Query Builder: Filter conditions and groups can now be dragged to reorder and moved between AND/OR groups.
  • Query Builder: WHERE filters now auto-quote values by column type (strings quoted, numbers bare), split IN lists into quoted elements, and add a per-condition raw toggle to emit a value verbatim.
  • Editor: New “Remember Connection Per File” setting (default on); turn it off to be prompted for a connection each time a SQL file is reopened.
  • Results Grid: Added a Source Timezone column formatter and the option to apply any formatter to all columns of a base type on a connection. #1089

Fixed

  • ClickHouse: Restricted users without system-table access can now open the Query Builder again.
  • Editor: Fixed losing focus after executing a query when results show in the panel, so you can re-run without clicking back in. #879
  • Query Builder: Tables added after a table with many columns no longer render off-canvas.
  • Query Builder: Select-all columns now works with a single table on the canvas.
  • Editor: Status bar now shows a SQL file’s bound connection even when it’s not connected.
  • Qdrant, ChromaDB, Milvus: Editor queries now honour the row-limit and show the “load more” indicator when results are capped.

Permalink

v1.32.3

Changed

  • Results: Removed the remote-only “Export locally” right-click option; Export now saves to a local folder via the dialog’s Show Local Files. #1112
  • Query Builder: use tables from other databases on the same connection (where supported).
  • Query Builder: SELECT columns are now a flat list with free cross-table reordering, multi-select move/delete, a searchable add-column menu, and per-table aliases.
  • Query Builder: More filter operators (NOT LIKE, NOT BETWEEN, CONTAINS, NOT CONTAINS), a case-insensitive filter toggle, per-table column select-all, and automatic GROUP BY for aggregates.
  • KingbaseES: Added support for KingbaseES.
  • Query Builder: AI assist understands the new filter operators, nested AND/OR groups, cross-database tables, and table output.
  • Query Builder: WHERE clauses can be grouped with parentheses and combined with AND/OR.
  • Query Builder: optionally write the result to a new table (CREATE TABLE AS SELECT).

Fixed

  • Grid: Filtering and sorting number columns now works for integers beyond JavaScript’s safe range (e.g. MySQL bigint). #1108
  • ER Diagram: Fixed broken rendering (missing relationship lines, wrong text colors) after changing the diagram theme and reopening. #1111
  • Export: Fixed exporting results to a local folder failing silently when connected to a remote host. #1112
  • Webviews: Fixed dropdowns (diagram theme, export format, connection and tunnel pickers) not applying the selected value.
  • ER Diagram: Fixed Export/Share doing nothing - PDF, PNG and Web Page exports now save correctly.
  • Grid: Cell tooltips now appear faster and only when a cell is actually truncated.
  • Neo4j/SurrealDB: Filtering or editing integers beyond JavaScript’s safe range no longer rounds them in the generated query.
  • Notebooks: Scrolling the column menu or the Columns side panel no longer jerks the whole notebook.

Permalink

v1.32.1

Changed

  • ChromaDB: Preview released.
  • Milvus: Preview released. #1122
  • Results: Multi-statement scripts now show a Run tab with live progress, per-statement detail, and an error summary, instead of one tab per statement. DML/DDL statements flow into the Run tab and output log; SELECTs still get their own tabs, with extra results stacked into an overflow, configurable via the setting dbcode.stackThreshold. #967

Fixed

  • Notebooks/DuckDB: Stopping a running cell now actually interrupts the query. #1105
  • DuckDB/Firebird/Pinot: autocomplete now works for these connections.
  • PostgreSQL: Editor autocomplete no longer silently stops working on SQL containing operators (<<, >>, <>, >=, <=), dollar-quoted strings, or block comments.
  • PostgreSQL: Typing EXPLAIN ... directly in the editor now works. #1107
  • SQL Server: Script CREATE (DDL) for tables now generates a best-effort CREATE TABLE script (columns, PK/UQ/FK/CHECK constraints, indexes with INCLUDE/filter, extended properties, temporal/partition/graph table clauses, Synapse DISTRIBUTION). Output includes a header listing what is and isn’t covered. Previously errored with “MS SQL does not have table in getObject”. #866 #1016 #1084

Permalink

v1.32.0

Changed

  • Firebird: Preview support released. #492
  • Qdrant: Preview vector-database driver. #475
  • ClickHouse: jdbc:ch:// connection URLs are now recognized when pasting a JDBC URL into the connection dialog.
  • DB Explorer: New “Copy Qualified Name” copying the fully-qualified, escapeed if needed name (e.g. schema.table, database.table).

Fixed

  • MySQL/MariaDB: Introspection no longer fails with a syntax error near where false. Regression from 1.31.2. #1103
  • ClickHouse: Restricted users without system.parts access no longer fail with “Not enough privileges”.
  • ERD: Removing an inferred-relationship mapping now also clears the relationship line from the diagram. #1100
  • MongoDB: Fixed “is not a function” error when reading collections that store UUIDs as legacy Binary or mix UUID and non-UUID values in the same field. #1101

Permalink

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

All releases

2026

2025

2024