Changelog

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.

Changed

• Language Server: Now enabled by default. Disable with dbcode.useLanguageServer setting if needed.
• QuestDB: Now generally available (out of preview). #527

Fixed

• BigQuery: Fixed stored procedure DDL script missing parameters.
• BigQuery: Improved introspection to gracefully handle permission-denied errors. Dataset browsing now shows accessible objects (like procedures) even when table access is restricted.
• Elasticsearch: Fixed connection errors with Elasticsearch 7.x and 8.x servers. #890
• MongoDB: Fixed introspection error on system.profile when user lacks listIndexes permission. #863
• PostgreSQL: Fixed connection failure when user lacks SELECT permission on pg_database view.

Changed

• Date/Time Display: Added “Raw” option to date style setting that preserves original database values without formatting or timezone conversion. Maintains full precision (microseconds) as stored in the database.

Changed

• Parameters: Added support for positional parameters ($1, $2, etc.) outside of function bodies. #889
• Authentication Profiles: Extended .pgpass and command auth profiles to CockroachDB, Greenplum, QuestDB, RisingWave, Timescale, and YugabyteDB.
• Oracle: Added support for Oracle 11g when using Instant Client (Thick mode).

Fixed

• Language Server: Fixed false “Unknown column” warnings for stored procedure/function parameters and DECLARE variables.
• Language Server: Fixed JOIN hints not using table aliases in ON clause conditions (e.g., ON a.id = b.user_id now uses both aliases correctly).
• Redis: Fixed authentication failing on Redis versions before 6.0 which don’t support username in AUTH command. #888