DBeaver Enterprise 25.1

June 9, 2025
Changes since 25.0:
  • AI Assistant: 
    • AI object description: AI now automatically generates a helpful summary for database objects like schemas, tables, views, indexes, triggers, and procedures. Just use the “Describe Database Object” option in the Navigator or Properties menu to get smart, informative descriptions instantly. Learn more
    • AI  error explanation and fix: You can now ask AI to explain and fix SQL errors with ease: just click the new “Explain and Fix” button next to the error message, and you’ll see the explanation and a corrected query right in the AI Chat. Learn more
    • AI query explanation is a new feature that explains what your SQL query does and what will happen when it runs, helping you better understand query behavior before execution.
    • AI smart SQL suggestion (beta) lets you build complete SQL queries using the AI assistant. Activate suggestions via the right-click menu or the keyboard shortcut (Option+Cmd+Right Arrow / Alt+Ctrl+Right Arrow), and easily accept them with the Right Arrow key. Learn more
    • AI Chat is redesigned into a persistent panel with a dedicated connection selector and an improved, more user-friendly interface. Learn more 
    • Integration with GitHub Copilot: You can now select GitHub Copilot as your AI engine in DBeaver and use it across all AI-powered features for enhanced coding assistance and smarter suggestions. Learn more
    • Google Gemini engine support was significantly improved.
  • SQL Editor:
    • CTE completion and navigation support were significantly improved.
    • Added support for STRAIGHT_JOIN and LATERAL JOIN.
    • SQL columns completion was fixed (issue with overlapping names).
    • Several navigation shortcuts were fixed to avoid conflicts with European keyboard layouts.
    • Fixed the single quotes handling.
    • Fixed SELECT .. FOR UPDATE queries execution.
    • When the “Blank Line is Statement Delimiter” option is set to Smart, blank lines are now correctly recognized as script delimiters while executing queries as Script.
    • Query cancellation after retry was fixed.
    • Fixed missing space after the leading keyword in some cases.
    • Fixed a bug in single-tab mode where script execution displayed results from the previous execution.
    • Fixed the SQL formatting for procedure calls with multiple arguments.
    • Improved button layout in the result set view on execution error.
    • Auto-refresh is now stopped if the result is not visible or the DBeaver window is collapsed.
    • Fixed the ability to expand columns for table_alias.* 
    • Added the ability to use the “Short object names” code completion option for columns.
    • Command parameters are now always highlighted with black.
    • If a referenced table has an alias, it’s now always prepended before the column name for semantic completion.
    • Added a new setting for semantic completion to control fully-qualified column names.
    • Fixed bind variables dialog layout for large fonts.
  • Data Editor: 
    • Added the ability to sort data by the primary key (Preferences / Editors / Data / Editor / Default ordering).
    • When an inline editor is active and the user starts typing, the grid now automatically scrolls to the cell being edited to avoid unexpected cell editing.
    • Fixed data types coloring for foreign and primary keys.
    • Removed options for copying column names and row numbers from the context menu for data cells.
  • Data Transfer: 
    • Removed the “All but nulls” and added the “All including nulls” option for “Quote always” option in CSV export.
    • Fixed export of dates before 1900 to XLSX files.
  • ER Diagram:
    • Updated the scrollbar color in the Diagram to match the application design.
  • Visual Query Builder: 
    • Fixed the ability to add and change table alias in an existing query.
    • Fix conditions expression creation and editing when column data type is string and value must be quoted.
  • Metadata: 
    • Added the ability to resize multiline fields.
    • Fixed an issue where folder content in the Metadata Editor was not displayed immediately after opening an object.
  • Navigator:
    • Improved filter behavior in the Database Navigator. Learn more
    • Fixed filters for secondary application window.
    • Added the number of elements in folders (configurable).
    • Fixed an issue that prevented schemas and databases from opening.
    • Ascending table sorting was fixed.
  • Connectivity:
    • Added the OAuth2 authentication and the ability to use a token with Vault secret provider.
    • Added an option to update a driver to a recommended version automatically if the user didn’t select it manually.
    • Fixed an issue with replacing localhost with the IP address when connecting via SSH.
    • Fixed an issue when credentials in the Test connection overwrite credentials of the previously created connection.
    • Resolved the issue related to font rendering in the connection creation window.
    • Added the ability to load AWS and Java certificates to the Custom Truststore.
  • Security: 
    • Added the ability to enable TLS/SSL debug logging.
    • Fixed vulnerability in Apache POI (CVE-2025-31672).
  • Miscellaneous:
    • Updated Light theme.
    • Added an extra CLI runner: dbeaverc. It respects settings in dbeaver.ini.
    • Fixed application launch in CLI mode.
    • Fixed the ability to use the application when certain accessibility tools are enabled.
    • Added an option to display the breadcrumbs in either the status bar or at the top of editors.
    • Breadcrumbs now occupy less horizontal space in the status bar.
    • Breadcrumbs now update immediately when any included object is renamed.
    • Added the DBeaver icon to aarch64-linux package .
    • Windows that appeared at app start were reordered to improve the user experience.
    • Fixed an issue where the “Tip of the Day” window could block the application interface from loading.
    • Fixed the Open File dialog issue on Linux.
    • Fixed misaligned editor window in the Bind Parameters dialog for macOS.
    • Fixed inconsistent application of connection colors for test and production connection types.
    • The “All file types” option was moved to the top of the file open dialog for easier access.
  • Technical specification:
    • Upgraded to Eclipse 2025-03.
  • New drivers: 
    • Added support for Kingbase database.
    • Added support for Teiid database.
  • Databases:
    • Apache Cloudberry: Fixed fetching server version .
    • Azure SQL Server: The “CREATE VIEW” statement was replaced with “CREATE OR ALTER VIEW” in the view DDL for Azure SQL Server v16 and higher.
    • Cassandra: 
      • Fixed the string filtering.
      • Fixed SQL generated for UPDATE and INSERT for tables with timestamp.
      • Fixed timestamp import to CSV.
      • Fixed table creation and editing.
    • Clickhouse:
      • Clickhouse driver was updated to version 0.8.5.
      • Data type display was fixed.
      • Fixed issue with reading geometry data.
      • Fixed quoting of nested array values.
    • CUBRID: 
      • Added the ability to update users.
      • Added statistics and trace information to the result tab.
      • Fixed incorrect script generation when creating a trigger via UI.
      • New column creation was fixed.
      • Added the ability to create and modify synonyms.
      • Fixed Info panel visibility.
    • Dremio driver was updated to the latest version.
    • Dameng: Added support for unique and check constraints.
    • Databend: Fixed an issue with changing catalog names containing special characters.
    • DuckDB:
      • Added option to hide system objects.
      • Fixed geometry display issues in DuckDB version 1.2.2+.
      • A simple structure compare wizard was fixed.
    • Denodo: The connection name was changed from “Denodo 8” to “Denodo” to reflect that this driver works with all Denodo versions
    • GBase 8s: 
      • Fixed creation of a table with a primary key.
      • Enhanced support for editing unique constraints and CHECK constraints.
      • Added the ability to edit table and column comments.
    • Firebird: Fixed native binary presentation.
    • MariaDB: 
      • Fixed the ability to create backup. Now it is performed with the mariadb-dump.
    • MariaDB/MySQL: Fixed creation of auto_increment columns with primary key.
    • MySQL: 
      • Fixed ‘remove definer’ option of backup/restore in a special case.
      • Fixed primary key column creation.
    • Oceanbase: Diagram display was fixed.
    • Oracle: 
      • Added supporе foк Oracle SQL*Plus PAUSE command.
      • Added the ability for administrators to lock users.
      • Added the Declaration tab to the Metadata editor with DDL for creating users.
      • Set `Use UNION for table metadata reading` preference to true by default.
      • Fixed view creation via the Metadata editor.
      • Oracle global variables, such as SYSDATE and UID are now supported in query validation.
    • PostgreSQL:
      • Added the ability to use SSPI without access to Maven Central for PostgreSQL.
      • Fixed foreign servers display when no access to ‘pg_user_mapping’ table.
      • Execution hang on a query with a huge JSON in dollar-quoted strings with tag was fixed.
      • Fixed an issue causing hangs when working with large JSON files.
      • Allowed unquoted identifiers started with underscore.
      • Added the ability to backup all database schemas (using the Completed backup option).
      • Fixed an issue with opening of the Foreign data wrappers configurator.
      • The retrieval of Collation was removed for older PostgreSQL versions (versions earlier than 9.1).
      • Fixed changing auto-increment sequence parameters.
      • Fixed updating arrays via the Value panel.
      • Fixed the ability to connect to the database when executing a query.
      • Fixed typo in the description of “Replace legacy timezone” setting in the New PostgreSQL connection wizard.
      • Fixed an issue where selecting “Exclude auto-generated columns” excluded only identity columns but not other auto-generated columns.
      • Fixed an issue where the “Show partitions” option was hiding permissions in the DDL view.
      • Added the ability to cancel queries in the Session manager.
      • Fixed the display of the back slash symbol in comment blocks after refresh.
      • Added support for wildcards in ILIKE filters within the data grid.
    • SAP HANA: fixed an issue with name editing when creating a table in the Metadata Editor.
    • Snowflake: 
      • Fixed metadata queries for driver versions 3.13.20 and higher.
      • Snowflake driver was updated to version 3.23.0.
    • SQLite: 
      • Added information about a table’s Strict mode to the Table Metadata section.
      • Added the ability to display GUID type as UUID.
    • SQL Server: 
      • Fixed table hints parsing.
      • Fixed the “Only connections” option in Session Manager to display only active connection sessions as intended.
    • TDengine driver was updated to the latest version. 
    • Teradata: 
      • Added the ability to use SSO for the authentication
      • Fixed an exception that occurred during code completion.
      • Native date/time formatting is now disabled by default and it can be enabled in the connection settings.
      • Fixed date formatting (case with 00 instead of month).
    • Yellowbrick: Added support for geospatial data.