Changelog

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

Changed

• Table Tabs: Added customizable tab title setting dbcode.tabTitle.format format with template variables for tables and views. #579
• SQL Formatting: Added support for .sql-formatter.json configuration files in workspace folders
• SQL Formatting: Added tabulateAlias option to align AS keywords in column lists for improved readability. #103
• Settings: Added Formatting section to specify default formatting configuration.

Fixed

• SQL Parser: Fixed comments after semicolons being treated as separate statements causing execution errors.
• SQL Server: Fixed semicolons now treated as statement boundaries alongside GO delimiters. #802

Changed

• Scratch Files: Added “none” rotation option for persistent scratch files without timestamp.
• Language Server: Added Clickhouse support. #795
• PostgreSQL: Added support for external tables (FDW). #800
• Filters: Can now be edited/deleted from the explorer, and maintain sync with the results grid.

Fixed

• Export: Fixed grid data not visible in webpage/notebook exports. #799
• Filters: Fixed filters duplicating when saved and not updating across panels and notebooks. #790
• Hover: Fixed table column preview formatting with improved layout, smart column hiding, and better alignment. #797
• PostgreSQL: PostGIS geometry columns now display as readable EWKT format instead of raw hex in result grids.
• Language Server: Fixed case-insensitive column name matching in both editor and grid WHERE filters. #792 #773
• Language Server: Fixed partial keyword matching in autocomplete suggestions. #792

Fixed

• ClickHouse: Fixed infinity and NaN values displaying as null in query results. #794
• Language Server: Fixed diagnostics incorrectly showing for unsupported dialects like ClickHouse. #795
• Editor: Fixed “No SQL to execute” error when executing queries in files without assigned connections. #798
• Results: Fixed initial loading performance. #789
• PostgreSQL: Fixed table row counts showing stale data by using pg_stat_all_tables when available. #791

Fixed

• Results: Fixed tooltip sizing and formatting for JSON content.
• Results: Fixed json cell editor saving JSON with whitespace instead of condensed format.
• SQLite: Fixed attached databases showing main database’s tables instead of their own tables. #784
• Filters: Fixed WHERE clause filters not including schema qualification, causing “table not found” errors. #787
• Connection: Fixed USE statement not triggering database context switch after parser update.