Changelog

Changed

• MongoDB: Added Command authentication provider for retrieving credentials from external secret managers (1Password CLI, Vault, AWS Secrets Manager, etc.) or custom scripts. #496
• Performance: Added experimental background schema worker to build schemas off the main thread. Enable with dbcode.useSchemaWorker setting.

Fixed

• MySQL: Fixed connection timeout on large databases (1000+ tables) by loading database sizes asynchronously. #862
• Authentication Profiles: AWS, auto runs SSO login if needed.

Changed

• DuckDB: Updated to version 1.4.2. #736
• Results: Added keyboard shortcut to focus WHERE filter (Ctrl+Shift+F / Cmd+Shift+F) and vim-style grid navigation (Ctrl+H/J/K/L). #858

Fixed

• Panel: Fixed results panel failing to load when visible during VS Code startup.
• Parameters: Ignore parameters in PREPARE statements. #857
• Language Server: Added ClickHouse support for SELECT * EXCEPT column exclusion syntax and SYSTEM REFRESH VIEW statement. #795

Changed

• Authentication Profiles: Added a view to the explorer to manage authentication profiles. #279

Fixed

• Connection Colors: Fixed empty workbench.colorCustomizations object appearing in workspace configuration file. #836
• File connections: Fixed CSV/Excel/Parquet/Avro file picker defaulting to folder mode on Windows/Linux. #845
• MongoDB: Fixed editing disabled for queries run from the editor. #851
• Results: Fixed parquet export failing when decimal columns are present. #852

Changed

• Auth Profiles: First look at centralized authentication profiles (added to Trino for OAuth). #279
• Results: Auto-focus first cell when switching to results panel for immediate keyboard navigation. #840
• Trino: Added support for OAuth authentication via new authentication profiles.

Fixed

• Databricks: Fixed SSO authentication failing in dev containers and remote environments.
• MongoDB: Fixed multi-line queries failing with “Unexpected end of input” error. #848

Changed

• Auth Profiles: First look at centralized authentication profiles (added to Trino for OAuth). #279
• Results: Auto-focus first cell when switching to results panel for immediate keyboard navigation. #840
• Trino: Added support for OAuth authentication via new authentication profiles.

Fixed

• Databricks: Fixed SSO authentication failing in dev containers and remote environments.
• MongoDB: Fixed multi-line queries failing with “Unexpected end of input” error. #848

Changed

• Databricks: Added preview support. #158
• Editor: Added “Expand SELECT *” command to replace * with explicit column list. Available via keyboard shortcut (Cmd+Shift+E / Ctrl+Shift+E) or lightbulb code action.

Changed

• Databricks: Added preview support. #158
• Editor: Added “Expand SELECT *” command to replace * with explicit column list. Available via keyboard shortcut (Cmd+Shift+E / Ctrl+Shift+E) or lightbulb code action.

Changed

• Tunnels: Added test connection button to tunnel creation/edit.
• Zero Config: Added support for framework-specific .env patterns including Laravel, Django, Spring Boot, and Node.js. #841
• Snowflake: Added support for SF_AUTH_SOCKET_PORT environment variable to use fixed port for SSO authentication callback.
• Alter/Open Table Commands: Where possible they now use the currently open table, and fallback to the quick picker.

Fixed

• Results: Fixed “Get started” screen appearing instead of query results when panel was reopened. #842
• Improved translations for several languages.

Changed

• Netezza: Added preview support. #748
• Explorer: Added drop, rename, create to more objects.
• Notebooks: Python injection toggle now appears in SQL cells even when notebook has no Python cells, enabling injection to external Jupyter notebooks. #621

Fixed

• Language Server: Fixed Windows compatibility issue where ESM dynamic imports. #204
• Connection Colors: Fixed user-level workbench.colorCustomizations being copied to workspace configuration file. #836
• SQL Server: Fixed DECLARE variables not in scope when blank lines exist between declarations and usage statements. #839
• PostgreSQL: Fixed introspection failure when user lacks permissions on pg_user_mapping table. #834
• File connections (CSV/Excel/Parquet/Avro): Fixed connection breaking when files are deleted, mapped tables will now be removed.

Changed

• Transaction Control: Rolled out to MySQL/MariaDB, SQL Server, Oracle, DB2, ClickHouse, and Snowflake. #368
• PostgreSQL: Added Foreign Data Wrapper (FDW) support to explorer. Foreign servers now appear at database level with their tables and user mappings. Also supported in Yugabyte, Timescale, Greenplum, and RisingWave derivatives.
• PostgreSQL: Filtered out pg_temp and pg_toast schemas from explorer.
• Explorer: Database-level containers (Schemas, Foreign Servers, etc.) are now always shown. Will require re applying any schema filters.
• Explorer: Updated connections to show refreshing icon when introspection is in progress.

Fixed

• Commands: “Alter Table” and “Entity Relationship Diagram” commands failing when invoked from command palette without tree selection.
• PostgreSQL: Fixed foreign tables appearing under Types in explorer.
• Snowflake: Fixed SSO authentication failing in dev containers and remote environments. #814
• ClickHouse: Fallback to SHOW commands when system tables are inaccessible. #817

Changed

• Core Plan: Testing usage-based access for select Pro features. Core users can now use certain features up to a limited number of times per month.
• Oracle: Ability to alter packages.
• SQL Server: Statements with DECLARE, temp tables, or variable assignments now stay together as one batch unless separated by GO or blank lines. #822
• Language Server: Added Snowflake support.
• History: Added setting to enable logging of failed queries. #827

Fixed

• ERD: Fixed position saving not persisting correctly. #829
• Results: Fixed WHERE filter input not expanding to fill available space when toolbar is constrained. #828
• MySQL: Fixed ER diagrams incorrectly showing One-to-Many relationships for foreign keys with UNIQUE constraints.

Changed

• Export: You can now export a table, view, or filter directly from the explorer in the right click context menu. #559 #796
• Language Server: Added multi-schema search path support for completions and semantic validation (PostgreSQL search_path, Oracle multi-schema access, SQL Server schema resolution). #773

Fixed

• CockroachDB: Fixed introspection error when connecting via zero-config with postgres:// protocol by auto-detecting CockroachDB and switching to the correct driver. #823
• Language Server: Fixed ClickHouse parser to support trailing commas in CREATE TABLE column lists. #818
• Language Server: Fixed Trino and ClickHouse UPDATE/DELETE WHERE completions not suggesting table columns.
• Language Server: Fixed ClickHouse UNION queries requiring ALL keyword when optional syntax is valid.
• Language Server: Fixed ClickHouse ORDER BY WITH FILL syntax not being recognized. #795

Changed

• Oracle: Added preliminary support for packages in database explorer.

Fixed

• Explorer: Fixed sequence/identity column default values being truncated in database tree (missing closing bracket after type cast). #807
• SQLite: Fixed introspection error when database contains orphaned views (views referencing dropped tables). #819
• MySQL/MariaDB: Fixed backup and restore failing over SSH tunnels by forcing TCP protocol to prevent socket connection attempts. #808
• PostgreSQL: Fixed SSL connection failures with servers using ECDSA P-521 certificates (secp521r1) by appending missing signature algorithm to BoringSSL defaults. #777
• Snowflake: Added debug logging to help diagnose connection issues. #814

Changed

• Notebooks: Added Python cell support with Jupyter kernel integration and SQL-to-Python result injection using @var annotations. #621
• Team Seats: Added role management with Owner, Admin, and Member roles for team subscriptions. Admins can manage seats while only owners can change roles.

Fixed

• Activation: Fixed web and email activation causing account section to not display license details. #810
• ClickHouse: Fixed connection failure when connecting to servers with readonly mode enforced at credential/server level. #817

Changed

• Transaction Control: Manual transaction management with auto-commit toggle, commit/rollback actions, and uncommitted change tracking for supported databases. #368
• CSV/Excel/Parquet/Avro: Now supports opening a folder of files and loading all files as tables in a single connection.
• ERD: Added multi-table selection support #812

Fixed

• PostgreSQL: Fixed backup failing on macOS due to pgAdmin 4.app extraction errors in the PostgreSQL tools package.
• SQLite: Fixed sqlean extension not loading due to incorrect required check and filename handling.
• Connection Tree: Fixed tables starting with underscore not appearing in tree view.
• PostgreSQL: Fixed DDL scripting for external tables (FDW). #806
• Language Server: Fixed incorrect suggestions for CTEs in autocomplete. #204
• Zero Config: Fixed postgres:// protocol not being recognized in .env files for PostgreSQL connection discovery. #813