DBeaver Enterprise 26.0

 

AI assistant:

• AI Chat: 
  • Added the ability to attach files to the chat and either open them as tables or import data from them. Opening as a table is supported for CSV, JSON, Parquet, SQL, XML, and XLSX files. Import supports all formats available in Data Transfer.
  • AI Functions are now enabled by default. You can run popular DBeaver tools, such as Data Transfer and Data Comparison, directly from the Chat.
  • Added streaming to the Chat. AI responses now appear in real time as they are generated.
  • Added token usage statistics. It is disabled by default and can be configured in the Chat settings.
  • All messages, including errors, warnings, and function calls, are now saved in the Chat.
  • Fixed rendering issues for AI responses containing code blocks.
  • Fixed the display of the audio recording histogram in the Chat.
  • Fixed empty conversation name when no conversation was selected in the Chat.
• Added support for custom AI instructions for all AI features. Custom instructions can be configured in Preferences and used alongside the default instructions.
• AI engines:
  • Added support for using Copilot with GitHub Enterprise accounts.
  • Added support for the Azure OpenAI Legacy API.
  • Added the ability to choose an authentication method for AWS Bedrock, including Access Key/Secret Key and AWS Profile.
  • Fixed SQL generation for the OpenAI engine.
  • Fixed issues where AI provided irrelevant responses due to cached context.
  • Disabled the temperature setting for models that do not support it.

SQL Editor:

• Improved performance when executing multiple SQL queries simultaneously.
• When no text is selected, “Ctrl+C” and “Ctrl+X” now copy or cut the entire line at the caret position.
• Fixed status bar visibility in the result set for single and multiple query execution.
• Added result set display for pause commands in scripts.
• Improved the script numbering algorithm.
• Fixed issues with the Find/Replace panel and the “Ctrl+Enter” shortcut.
• Dangerous query confirmation is now shown for all DROP statements.
• Fixed query confirmation messages for queries including the DROP command.

Data Editor:

• Redesigned row ordering by primary key; the feature now works only for tables. 
• “Calculate row count automatically” feature is now enabled by default and applies only to SELECT queries.
• Improved the presentation of multiple foreign keys in the Data grid.
• Fixed dark mode display for single-tab results.
• Fixed several minor issues related to background rendering, exceptions, and cursor behavior.
• Removed an incorrect warning that a column could not be edited due to a missing key when the “Use all table columns as a key upon saving” option was enabled.
• Resolved an issue where generating tooltips for large JSON values took too long and caused the application to hang.
• Fixed value change cancellation.
• Resolved an issue with the incorrect detection of read-only columns.

 

Grouping Panel:

• Added the “Percent of Total” function.
• Columns and functions can now be reordered by drag-and-drop.
• Pressing the “Add” button opens a submenu with available items and columns.
• Choosing “Custom” in column configuration adds an empty, editable column or function.

 

Metadata Editor: Fixed tab styling.

ER Diagram: Changing notation applies immediately without diagram refresh.

Visual Query Builder: 

• Added the ability to drag-n-drop a table from a non-active project.
• Fixed redundant double escaping.

Data Transfer:

• Added the ability to export fetched rows without querying the database (in the extraction settings step).
• Data import wizard now shows the file selector automatically.
• Fixed data export in DbUnit format (escaping issue).
• Fixed data migration from database to database when the “Selected rows only” option was enabled.
• Resolved an issue with an oversized data transfer window.

Data Compare: 

• Added the ability to compare more than two objects at once.
• The Data Compare wizard was simplified to just two steps.
• Improved automatic column mapping. Columns are matched by name, ignoring case and underscores.

• Fixed the incorrect completed step display.

 

Task Management:

• Added the ability to exclude the DBeaver signature from emails with task results.
• The “Save Task” button was moved to the same row as the other action buttons.
• Added a tooltip to the Auto-commit option in the SQL Script task settings.

Schema Compare:

• Resolved an issue when the “Open in Editor” button did not open the SQL editor for the target container.
• Fixed an error when switching the active page.

Security: 

• Fixed an issue where the master password was always requested when saving a project.
• Fixed an issue where enabling a project password could overwrite existing database credentials.

 

Connectivity: 

• Added the ability to import the connection list with all settings from pgAdmin.
• Added an internal connection information page to the connection edit dialog.
• Renamed the “Database Native” authentication type to “Username/Password”.
• Fixed an issue where AWS SSM settings were overridden by secret settings.
• Fixed an SSH connection error on Windows caused by permissions on temporary files created by the application.
• Fixed an issue where “Transaction settings” did not open in the connection editor.
• Fixed the driver download dialog (issues with wrong focus and details panel).
• Improved the new connection name generator.
• Fixed rendering of check-buttons and radio-buttons on Linux.
• Removed warnings related to custom driver icons.
• Fixed saving of the “Open separate connection for metadata reads” option.

Miscellaneous: 

• Redesigned visual page structure in Preferences and some dialogs.
• Added the ability to open DuckDB and MS Access files via “File – Open” in the main menu.
• Fixed text input for Chinese, Japanese, and similar languages in Search on macOS.
• Auto-commit settings were redesigned.
• Resolved an issue with the incorrect transaction mode display.
• Redesigned visual page structure in Preferences and some dialogs

Installation: 

• Added an option to exclude the application from Microsoft Virus Defender during installation.
• Fixed Eclipse plugin installation in PRO versions.
• The Linux Debian package was fixed.
• Fixed the ability to manage software installation.

New database support:

• Azure SQL Server: added the ability to connect to Мicrosoft Fabric.

 

Databases:

• Athena and Redshift:
  • Fixed non-working connectors.
  • Fixed IAM authentication when connecting with username/password credentials. 
• Athena: 
  • Driver was updated to version 3.27.0.
  • Fixed an issue when the connection stopped working after an application upgrade.
• Azure Synapse Dedicated SQL Pool: Fixed the display of stored procedure definitions.
• Azure SQL Server: Active Database Detection has been fixed.
• ClickHouse:
  • ClickHouse driver was updated to version 0.9.5.
  • Fixed JSON data type reading.
  • Resolved an issue with CTE expressions.
  • Fixed the active database selector.
  • Resolved an issue with the LIMIT clause on read-only connections.
  • Fixed rendering of large numbers.
  • Fixed rendering of tuple data types.
  • Fixed multiple issues with fetching and rendering array data types.
  • Fixed an issue with displaying arrays of UUID, IPv4/IPv6, and Map types. They are now shown as strings in the Data Editor.
  • Fixed issues with timestamp insert and update operations when date formatting is enabled.
  • Fixed broken spatial data presentation.
• CUBRID: 
  • Fixed an error occurring when executing a script generated after changing the view schema owner.
  • The issue with duplicate primary key columns was fixed.
  • The SQL query execution plan layout was fixed.
  • Shards’ support was added.
• Databricks: Added support for spatial data.
• Denodo: driver version was updated to 9.0.
• Db2 LUW: Added Microsoft Entra ID authentication.
• DuckDB: added support for the dollar-quoted string syntax.
• MongoDB: Milliseconds are now displayed correctly in the Data grid.
• Microsoft Fabric:
  • Stored procedures body reading was fixed.
  • The extended properties reading was fixed.
• MySQL: 
  • Fixed database dump when SSH is enabled.
  • The table column DDL generator was added.
• Netezza:
  • Implemented bulk load support to improve data import and migration performance.
  • Added the ability to search metadata objects by definitions.
• Oracle:
  • The issue with active user name detection was fixed.
  • GRANT statements were fixed in the object’s DDL.
• PostgreSQL: 
  • Fixed “Complete backup” behavior and table selection visibility during dump.
  • SSPI authentication was fixed.
  • Added DDL display support for PostgreSQL policies.
  • Fixed event triggers DDL for the latest PostgreSQL server versions.
  • The issue with the redundant change of the “search_path” variable was resolved
  • The issue with the wrong native binary for database restore was resolved.
• Redshift: 
  • Fixed an issue where changing the schema failed if no schema matched the user name.
  • Materialized views are now displayed as system tables with a special icon.
  • Fixed multiple issues related to permissions, incorrect empty table display, and the data import wizard.
  • Fixed materialized view reading.
• Salesforce Data Cloud: 
  • Salesforce Data Cloud was renamed to Salesforce Data 360.
  • Fixed default schema detection, which resolved issues with autocomplete.
• Sybase: fixed table opening via double-click in the Navigator
• SQLite: Fixed an issue where creating a foreign key with a new column failed on the first attempt.
• TDB: Fixed an SQL execution error.
• TDengine: support for non-Latin encodings was improved.
• TimescaleDB: Fixed incorrect table size display.

 

Localization: Brazilian Portuguese localization was fixed.