DBeaver Ultimate 25.0

March 10, 2025
Changes since 24.3:
  • SQL Editor:
    • The new autocomplete engine was renamed “Semantic” and enabled by default. The previous model is now called “Legacy”
    • Semantic model was significantly improved: added support for USING, SELECT INTO, INSERT statements, nested queries, and fixed multiple issues
    • Added the ability to use multi-line variables in SQL scripts
    • Fixed indentation behavior when adding a new line
    • Added support for ${time} variable in data source variables for script templates
    • Changed default shortcuts for the Result set zoom to Alt+0 and Alt+9 to avoid conflicts with system shortcuts
    • Fixed the issue where the old result set tab didn’t close when switching between multiple and single tab modes
    • Fixed a stack overflow error that occurred when a user tried to execute a script for an open result set with row coloring
    • When an error occurs, the last executed query is now displayed next to the error message
    • Icons in the SQL Editor toolbar were redesigned
    • Improved performance of reading data in the SQL console
  • AI assistant:
    • You can now use the @ai command in SQL Editor to generate queries. Simply configure the AI engine, describe in the SQL Editor what you need in plain language, and get a ready-to-use query instantly
    • Fixed syntax issues in queries generated by Azure Open AI
    • Fixed excessive AI requests when AI is disabled
  • Query Manager:
    • Added the ability to filter queries by data sources and date range
    • Added the ability to clean and compact query history
    • Query duration formatting was fixed
  • Data Editor:
    • Completely redesign displaying for hints, additional information blocks for cells and columns displayed in tooltips and directly in the cells:
      • Depending on the data type, cell hints display information about foreign and primary keys, array elements, binary data size, geometries, and timezones. Using hints, you can also navigate to related tables
      • Column hints continue to display information about keys and column status, but they were redesigned for better readability
      • All hints can be configured on the Context menu: you can choose which hints to display for cells and columns, for this table, for the current connection, or globally
    • Added backslash escaping when generating scripts
    • Added an option to disable the dictionary view (set “Maximum amount of elements” to 0)
    • Added an option to save XML and JSON files in compressed format
    • Added support for the composite types for the Grouping panel
    • Dark theme support was improved, selection background was changed
    • Context menu for Filters was simplified: all items are now on the same menu level
    • Fixed freezing issues when pasting a big number of rows or when performing find/replace
    • Fixed data editor filters for common table expressions
    • Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
    • Fixed row coloring when querying multiple tables
  • Diagram: 
    • Table comments and fully qualified names now appear instantly when the option is enabled
    •  “ER Diagram” tab was renamed to “Diagram”
    • Added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
    • Made Diagram edit mode more noticeable so users can easily see when it’s active
  • Visual Query Builder: 
    • Users can now enable table comments display on the diagram
    • Query builder is now available only when the connection is established 
  • Metadata editor:
    • Fixed real-time updating of column order
    • Fixed issue with duplicate constraint display
  • Navigator: 
    • Database object filter was improved. Filter by connections is enabled by default
    • Indexes, triggers, and other database entities are now sorted in ascending order
    • Fixed table search
  • Data Transfer: 
    • Added the ability to use default spreadsheet names (e.g., Sheet0, Sheet1) for exporting to XLSX
    • Added an option to replace line break characters when exporting to CSV
    • Added the ability to format arrays during the data export
    • Added the ability to use comma as a delimiter in the Advanced Copy option
    • Removed the ability to change data type for existing columns in Data Export
    • Export to Parquet with time data types was fixed
  • Task Management: Fixed the ability to drag-n-drop composite tasks
  • Connectivity:
    • Added the ability to retrieve database credentials securely from the AWS secret manager and HashiCorp Vault secret provider
    • The product now supports importing certificates from a predefined folder at startup
    • Proxy configuration loading was fixed
    • Title for the Test Connection details was corrected
    • Fixed an issue with network profile saving
    • Fixed update of the path to Kubectl through Preferences
    • Users can now see all available contexts after uploading a Kubernetes config file
    • Error handling for reading AWS configuration files was improved
    • Fixed an issue where the connection name was replaced with “localhost” on macOS
  • Miscellaneous:
    • Added the ability to associate different file types with DBeaver on Windows and macOS, and open them directly from OS file explorer or with Ctrl+O shortcut
    • The bottom toolbar now features breadcrumbs, showing the hierarchical path to the open entity in the active connection (e.g., a specific table). They also allow quick navigation to any sibling or parent node in the hierarchy
    • Metadata configuration files were moved to the .metadata/config folder
    • Added the ability to create bookmarks from the context menu of object tabs
    • Commit/Rollback monitor was fixed
    • Added numerous minor UI improvements related to editors and dialogs coloring and fonts
    • Scrolling in the “Tip of the day” window was fixed
    • Added word wrap for hints to controls
    • Search in Preferences was improved
    • Monospace font is now used for HEX, JSON, XML, and other content editors
    • When user selects the Reset Settings option during installation, plugin settings are also reset
    • Status bars in Data and Metadata editors were improved: the schema selector is now hidden when no connection is available, and background color and fonts were updated
    • Fixed issue with saving timezone in Preferences
  • Technical specification: 
    • Migrated  the application to Java 21 (using open-source OpenJDK)
    • Upgraded to Eclipse 2024-12
  • New Drivers: 
    • Cloudberry driver was added
    • Databend database was added 
  • Driver updates:
    • Google BigQuery was updated to version 42_1.5.4.1008
    • Jennifer to v5.5.3.2
    • Machbase to 8.0.2
    • MariaDB to 3.5.2
    • SQLite to 3.48.0.0
    • Snappy to 2.11-1.3.0
    • Spanner to 2.15.5
    • Teradata to 20.00.00.38
    • For InterSystem IRIS, OrientDB, and Salesforce Data Cloud, the latest driver version is now downloaded by default
  • Databases:
    • Apache Cassandra: Fixed autocompletion for materialized views
    • Azure Databricks: Information_schema was added to Database Navigator
    • Azure PostgreSQL: Fixed the ability to connect using Microsoft EntraID
    • CUBRID: 
      • Added REUSE_OID, COLLATE, and COMMENT to the table DDL 
      • Fixed view name generation in DDL
      • Fixed index creation preview
      • Fixed column creation with STRING and similar data types
      • Procedure, function, and view names are now displayed in lowercase
      • Added the ability to change comments for foreign key columns
    • Ability to connect to Data Virtuality and Kognito databases was removed
    • Google BigQuery: added the ability to enable session mode
    • LibSQL: UI for token-based authentication was added
    • Microsoft SQL Server: 
      • Primary Key ordering in DDL generation is now respected
      • Index creation was fixed
    • MySQL:
      • MySQL driver was removed from the package. The application now prompts users to download it from Maven during connection configuration
      • Added a setting to not export routines to the backup tool
      • USAGE privilege is now hidden if any other privilege was granted
      • Fixed loading of DBA privileges
      • Fixed an issue with restricted access for users without SHOW DATABASES permission
    • MySQL/MariaDB: 
      • Added the ability to change expired password
      • Removed redundant slashes in data export to SQL format
      • Explain plan now works for all types of SQL queries
    • OpenEdge: query generation was fixed
    • Oracle:
      • Added the ability to change user password and create and clone users
      • Added support for the SQL Plus ACCEPT keyword
      • Fixed user password changing
      • Fixed DDL generation for table spaces
      • Fixed index declaration in Oracle 23.1.0
    • PostgreSQL:
      • Added default privileges grantor to DDL
      • Syntax error in DDL generated for the role settings was fixed
      • Both Asia/Calcutta and Asia/Kolkata time zones are now supported
      • Fixed an issue with disappearing ENUM definition after the refresh in Metadata editor
      • Fixed the display of infinity for date values
      • Added the ability to replace legacy timezone
      • Fixed transaction mode changing after the connection reopen
      • Fixed an issue with display database size after the connection refresh 
      • Added the ability to change the storage strategy (PLAIN, EXTERNAL, EXTENDED) for a column
    • Salesforce: 
      • Added the ability to select data from multiple tables
      • Export from Salesforce to other databases was fixed
      • Viewing more than 2000 rows in the data grid was fixed
    • Salesforce Data Cloud:
      • Removed the ability to edit database metadata
      • The latest driver version is now downloaded by default
    • SAP HANA: partition view was added
    • Snowflake: Added support for table aliases in autocompletion
    • SQLite: creating new constraints from selection was fixed
    • Teradata:
      • Removed incorrect warning message after executing SHOW and similar queries
      • Added a tooltip with timestamp timezone
      • Fixed data type name for TIMESTAMP WITH TIME ZONE
      • Supported FORMAT for datetime
      • XML column value save was fixed
    • Yugabyte: Fixed connection issue with TLS certificates
  • File drivers:
    • Added new drivers for working with files as databases. These drivers allow you to open files in the Data Editor, execute complex SQL queries, and work with files in cloud storage (AWS, Google Cloud, Azure). Currently, the drivers operate in read-only mode:
      • XML driver
      • JSON driver
      • Multi-source driver – allows you to combine files of different formats into a single database and join data from multiple files using a single SQL query
    • Added the ability to open Parquet files from cloud storage
    • Added support for geospatial data types
    • File opening dialog was completely redesigned
    • Fixed an issue with the quoted table name in DDL
    • XLSX file driver: file name is now used as schema name
    • Added support for GIS data types
    • Temporary connection UI was improved
  • Localization:
    • Localization files were converted to UTF-8 to improve the localization process and enhance code readability
    • Localization of basic controls, settings, and menu items was fixed