Changelog

Changed

• New schema storage model.
• Clickhouse: Now has a request timeout setting in the configuration. #508

Fixed

• Oracle: Changed compatibility to 12.1.0
• Explorer in some cases could miss map columns to a table.

Changed

• Cassandra: Moved to new introspection model.
• Mongo: Moved to new introspection model.
• Files associated to connections will be remembered per workspace. #412
• Removed the @dbcode Chat Participant in favor of copilot tools and providing context.
• Setting: Workspace Connection: You can set a workspaces default connection, it will be stored in settings and used in quick open, and Copilot Tools. #237
• Copilot/MCP: Added a tool that will get the default connection that if configured for a workspace.

Fixed

• Oracle: Getting support for 12c sorted. #160
• Right click opening files in windows was incorrectly setting file path.

Changed

• Trino: Preview support added. #172
• DuckDB: Supports using a memory only database. #501

Fixed

• Definition on hover will match schemas regardless of case. #488
• Clickhouse: Datatypes are better supported. #462 #463
• Create Database: Was not working in the context menu.

Changed

• Oracle: Moved to new introspection model.

Fixed

• Oracle: Fixed byte sequence error. #477 #456
• Oracle: Use version rather than version_full. #160
• Fixed: Sample database no longer includes extension version in the path. #498

Changed

• Tab Reuse: Changed to follow VSCode enabled limit and limit value, will recycle only if limit editable and tab limit reached.
• Output tab: Shows the execution history and output statements for Databases that support them (SQL Server, Postgres).
• Allow air gapped computers to provide required packages manually. #486

Fixed

• Clickhouse: Support describe statements

Changed

• Accounts: Added a refresh to the account section to refresh information and not require a logout/in.

Fixed

• Autocomplete: Fixed issue with alias not always being matched. #484
• CockroachDB: Error with cluster id caused by SSL configuration in #445
• Tab Reuse: if workbench.list.openMode is set to doubleClick tabs wont be re used, since no way to track the double click, and without it only one tab can be opened.

Fixed

• Postgres: Was not handling infinity/-infinity dates. #482
• Quick Script: Was not setting connection on the new file. #349
• Open new file: Was not working when executed from the command pallet instead of the tree. #483

Changed

• SSL: Configurations that are discovered now use the OS ssh command. #445
• Drop items from the explorer onto the tree to script them. #348

Changed

• Quick Script: Select, Insert, Update, Delete scripts can be generated from the context menu of items like tables, views. #349
• Item Filter: Now supports SQL like and not like like filter values eg: not like pg_temp%. #461

Fixed

• Postgres: Introspection bug. #416

Changed

• External Tables: Now listed in their own section. #472
• Tunnels: Added host and port connection test.
• DB2: Out of preview #82

Fixed

• Connection Add/Edit: Disabled connection test if a tunnel was used.
• Azure: Better support for Synapse databases. #471

Changed

• Microsoft Dataverse (Power platform): Added support. #458
• RisingWave: Added Support. #465

Fixed

• Snowflake: Handle an empty error. #448
• Azure: Better support for SQL Server variants that don’t support system_columns. #460

Changed

• Reuse tabs when opening tables and views. Follows VSCode reuse based on single or double click. #211
• Connection Add/Edit: Added DNS and Port connection test.

Changed

• Tunnels: Added support for ProxyCommand in ssh.config. #445
• Tunnels: Fixed auth methods. #257

Fixed

• Snowflake: Handle an empty error. #448

Fixed

• Race condition on first time initialization. #457

Fixed

• Connection Add/Edit: Fixed responsive issues on small screens. #447
• Turso: Removed user_version statement. #446
• Escaped more SQL Keywords. #444
• FileStore: Added logging to filestore operations. #440 #425
• Clickhouse: Enabled request/response compression. #111
• Postgres: Handle switching to schemas that need escaping. #439