Changelog

Changed

• Access: Removed from preview, added support for views (Access Queries), indexes, foreign keys, and read-only mode. #546
• H2: Removed preview badge - H2 Database driver is now stable. #371
• Results: Added chart toolbar button with dropdown for quick chart creation from selection, with persistent chart type preference (Ctrl/Cmd+G). #921

Fixed

• Autocomplete: Fixed keyword sort priority so SQL keywords (SELECT, etc.) appear before procedures/functions in completion results. #948
• Redis: Fixed raw commands (KEYS, SCAN) still blocking the extension, changed abort signal handling. #946
• DuckLake: Fixed Windows connection failure by normalizing backslashes to forward slashes in local catalog and data paths.

Changed

• DuckLake: In preview for connecting to DuckLake catalogs with local or database-backed metadata and local/S3/GCS data storage.
• Iceberg: In preview for connecting to Apache Iceberg catalogs via AWS Glue or S3 Tables.
• Formatting: Added preserveShortStatements setting to skip formatting for short SQL statements, leaving them exactly as written.
• Connections: Added “Editor Connection Idle Timeout” setting to auto-release editor connections after a period of inactivity. Useful for serverless databases to prevent unexpected billing from keepalive queries. If there are uncommitted changes, a warning notification is shown with a grace period before auto-rolling back.

Fixed

• Alter Table: Fixed alter table and hover actions not working. #928
• Redis: Fixed MCP queries hanging and blocking the extension on large scans by yielding and configurable max scan limit. #946

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