Changelog

Changed

• Inferred Relationships: Ability to define relationships for databases without native foreign key support (MongoDB, DynamoDB, etc.). Configure patterns in connection settings or visually in the entity relationship diagram to detect relationships based on column naming conventions (e.g., user_id → users.id).
• Results: Hold Shift while executing (Shift+Cmd+Enter / Shift+Window+Enter) to refresh the last result tab instead of opening a new one, preserving chart configuration. In single-tab mode (maxTabs=1), this behavior is inverted. #921
• Results: Added column selection via Shift/Cmd/Ctrl+click on column headers, or “Select Column” in context menu. Shift selects a range, Cmd/Ctrl adds to selection. #921
• Athena: Added multi-catalog support. Database list now shows all data catalogs (data sources) including federated connectors. #920
• Settings: Added dbcode.discovery.enabled setting to disable automatic zero-config connection discovery from workspace files (.env, config files, etc.).

Fixed

• Formatting: SQL formatter now properly respects .editorconfig insert_final_newline setting at file level.

Fixed

• AWS: Fixed SSO credentials not refreshing after user re-authenticates via CLI, previously requiring VS Code restart.
• DB2: Fixed connection failure on Windows due to CLI driver path not being resolved. #918
• Results: Fixed date filter on datetime/timestamp columns not matching rows when using equals with date-only values. Now expands to match any time on that date.

Changed

• H2: Added experimental support. #371 #788
• Table View: Added loading status text (“Connecting…”, “Loading data…”) to provide feedback during slow initial database connections.

Fixed

• Hive: Fixed column comments not appearing on Hive 2.x (legacy) servers. #669
• MySQL: Fixed progressive schema loading still timing out on very large table counts. #862
• PostgreSQL: Fixed introspection error on openGauss and PostgreSQL < 9.5 due to missing array_position function. #917

Changed

• MySQL/Trino/Athena: Added experimental progressive schema loading for faster initial connections. Enable via editing connection, going to Advanced > Introspection settings. Includes on-demand detail fetching, background prefetch, and configurable cache TTL. #908 #875 #862

Changed

• Opensearch: Added preview support. #874
• Elasticsearch: Added Aliases, Scripts and Ingest Pipelines to explorer.

Changed

• Tunnels: Added command tunnels for local proxy tools (cloud-sql-auth-proxy, kubectl port-forward, AWS SSM, etc.) with presets, variable substitution, and ready detection. #625
• Tunnels: Added per-tunnel output channels for viewing tunnel logs via “View Logs” command.
• SurrealDB: Added relationships and events for tables, and functions as well as auto complete support. #254
• Results: Added setting to show column comments below column names in grid headers. #669

Fixed

• Formatting: SQL formatter now respects files.insertFinalNewline setting from VS Code/EditorConfig.
• BigQuery: Fixed CLONE and SNAPSHOT tables not appearing in the db explorer. CLONE tables now show in Tables, SNAPSHOT tables in a separate Snapshots section. #914

Fixed

• Results: Fixed pivot mode calculating incorrect aggregates for decimal values with trailing zeros (e.g., 175.20). #913

Changed

• SurrealDB: Added preview support for SurrealDB with namespace/database browsing, SurrealQL queries, and document editing. #254
• InfluxDB: Added preview support for InfluxDB 3 with SQL query execution, line protocol writes, and soft/hard delete options. #168
• Results: Column header tooltips now show datatype info and column comments (where available). #669
• Inspector: NoSQL databases now allow the inspector JSON mode to be editable, as well as the form mode to add remove columns.
• Inspector: If selecting multiple rows, you can now edit the value for all selected rows at once.
• Inspector: Now shows the data type of each column in the form view and comments where available.

Fixed

• MongoDB: You can now insert a document into a blank collection.
• Editor: Fixed format-on-paste mangling pasted values like UUIDs by adding spaces around hyphens. #896

Changed

• MSSQL: Added Named Pipe and LocalDB connection support for Windows, allowing connections via named pipes or LocalDB instance. #497
• Neo4j/Memgraph: Added relationship visualization to entity diagrams, showing connections between Labels.

Fixed

• Hive: Fixed introspection failure due to integer overflow in HiveServer2. #904

Changed

• Neo4j/Memgraph: Added preview support. #572 #622 #617
• PostgreSQL: Added “Truncate Cascade” option for tables to handle foreign key constraints.
• Netezza: Added query cancellation support, removed from preview. #748
• MSSQL: Added Windows Integrated Authentication (SSPI) (Testing).

Fixed

• Connections: Fixed SSL/TLS settings not being preserved in “Copy Connection String” and “Import Connection String”. #905
• Hive: Not fetching all data during introspection. #904

Changed

• Editor: Added signature help for user-defined functions and procedures, showing parameter names, types, and active parameter position.

Fixed

• SingleStore: Fixed introspection error due to missing generation_expression column. #903
• Hive: Fixed introspection limited to 100 tables due to default fetch size. #904
• ClickHouse: Fixed connection failure on legacy versions (< 21.11) due to missing comment column in system tables. #902

Fixed

• PostgreSQL: Fixed introspection failing when user lacks access to system tables (pg_inherits, pg_trigger, pg_matviews, pg_policies, pg_foreign_server).
• Zero Config: Fixed discovered connections not updating when adding folders. #900
• MSSQL: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.
• Oracle: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.
• MySQL/MariaDB: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax. #898
• MySQL: Fixed procedures/functions not using DROP statement for alter workflow. #898

Changed

• Hive: Added protocol version selection (V7 for Hive 1.2+, V10 for Hive 3+) to connection settings. #661

Fixed

• Hive: Fixed transactional table detection for Hive 2.x to enable grid editing on ACID tables. #661
• Access: Fixed download by hosting package in DBCode repository with manual file fallback for air-gapped environments. #546
• BigQuery: Fixed functions incorrectly showing as procedures and added proper return type display.
• BigQuery: Fixed DROP PROCEDURE and DROP FUNCTION commands to use correct syntax.

Changed

• MongoDB: Added authentication mechanism selection (SCRAM-SHA-1, SCRAM-SHA-256, X509, AWS, LDAP, Kerberos) to connection settings. #892

Fixed

• Results: Fixed first cell not receiving focus when opening tables via Quick Open. #840
• Results: Fixed ESC key not closing relationship sub-tables when focus was inside the nested grid.
• Hive: Fixed materialized view DDL generation to output CREATE MATERIALIZED VIEW instead of CREATE TABLE.
• MongoDB: Fixed connection string import not parsing query parameters (authSource, authMechanism, tls). #892

Changed

• DynamoDB: Added DynamoDB (Preview). Supports AWS credential chain, access keys, auth profiles, and DynamoDB Local. #495, #887
• Hive: Added Apache Hive (Preview). Supports HiveServer2 via Thrift protocol with TCP and HTTP transports. #661
• Impala: Added Apache Impala (Preview). #190
• RavenDB: Added RavenDB (Preview). #252

Fixed

• Results: Fixed copy/paste not preserving null and boolean values between grid cells.