DBeaver Ultimate Release Notes

24.2

September 9, 2024
  • General: 
    • Added presentation of structural data types in the table Properties.
    • Added the ability to disable all metadata queries. This can be useful for improving performance or reducing the number of queries to expensive databases.
    • Added import of configured connections from MySQL Workbench and other third-party database management tools.
    • Icons in Database Navigator and Data Editor were redesigned.
    • AI Assistant: GPT-4o, GPT-4-turbo, and GPT-4o-mini models are supported.
  • SQL Editor:
    • Added problem markers with semantic errors and warning descriptions. You can click on the problem description in the tooltip to find out what is wrong with the query.
    • Added highlighting, validation, and Outline viewer support for DDL statements: CREATE, DROP, and ALTER.
    • The database connection will be automatically closed when all related SQL editors are closed.
    • Auto-save in SQL Editor editor is enabled by default.
  • Data Editor: 
    • Indicators of the table status were added to the upper left corner of the grid.  When you hover the indicator, you can see a tooltip with detailed information about unique keys and the ability to edit this table.
    • Keyboard shortcut Ctrl+Shift+Alt+C allows you to use the advanced copy option with the latest settings, without opening a popup window each time.
  • Data transfer: Users can email large export result files by splitting them into multiple parts in zip format.
  • Data Compare
    • Added an ability to compare results of custom SQL queries.
    • Big tables comparison performance was significantly improved.
  • Task management: Added new password option “Automation (console)”, especially for running scheduled tasks.
  • Connectivity: It is now possible to use custom SSM Documents to connect to AWS databases.
  • Databases and drivers:
    • New driver: Huawei GaussDB.
  • Google BigQuery:
    • Legacy SQL dialect is supported.
    • Predefined monitoring dashboards were added to the Windows application.
  • Cassandra: Driver version was upgraded and added support for VECTOR data types.
  • Redshift:
    • Connection stability was significantly improved.
    • Role, User, and Group presentation was fixed.
  • Db2 z/OS: Native table DDL generation was added.
  • Added many improvements for Altibase, BigQuery, GaussDB, Cassandra, Clickhouse, CloudSQL – PostgreSQL, Couchbase, CUBRID, DuckDB, InterSystems IRIS, MariaDB, Neo4j, Ocient, Redis, Redshift, Salesforce, SAP IQ, SAP Hana, Snowflake, SQLite, SQL Server, Teradata, and Vertica.
  • Driver updates:
    • Apache Drill to version 1.21.2
    • Apache Arrow to 16.1.0
    • ClickHouse to 0.6.1
    • Cassandra to 4.18
    • Firebird to 5.0.4
    • Informix to 4.50.10.1
    • InterSystems IRIS to 2024.1
    • Redshift to 2.1.0.29
    • SAP Hana to 2.20.17
    • SQL Server to 12.8.0
    • Yugabyte CQL to 4.15
    • H2 Server to 2.1.214
  • Localization: Italian and French localization was updated.
Detailed DBeaver Ultimate 24.2 release notes.

24.1

June 10, 2024
  • Connectivity:
  • Dashboards: 
    • Users can create custom web-based charts and add them to Dashboards.
    • Dashboard user interface was redesigned: added ability to drag and drop charts, add and edit them in one click using toolbar buttons, and customize dashboard view.
  • Tableau: Users can add Tableau charts to Dashboards and see how they change when data changes inside the application.
  • Data Compare:
    • Comparison performance significantly increased. Users can now compare tables with millions of rows. 
    • Export of comparison results to SQL and HTML was added.
    • User interface on the Key configuration and Column mapping tabs was improved.
  • SQL Editor:
    • Smart mode for statement delimiter in SQL scripts was added.
    • Highlighting, validation, and outline viewer for INSERT, UPDATE, and DELETE statements were supported.
    • Auto-completion for sub-selects was supported.
  • AI enhancements:
  • Visual Query Builder: 
    • BETWEEN conditions were supported.
    • Ability to change table aliases in joined tables was added.
  • Task management: 
    • Email notifications were improved. Users can receive notifications depending on the result of task execution and the presence of attachments.
    • Running tasks can be automatically canceled after the specified timeout.
  • Cloud Explorer: Ability to see connections for selected cloud configuration was added.
  • General: 
    • Ability to import configured connections from Toad for Oracle was added.
    • Possibility to collect DBeaver diagnostic information automatically for tech support was added.
    • Migration to Eclipse 2024/06 was performed. This version does not support Windows 8 / Windows Server 2012 / macOS 10 and earlier versions.
  • Databases and drivers:
    • Neo4j driver support was significantly enhanced. The structured data can be presented in JSON or text format. Users can execute queries using Cypher query language.
    • BigQuery support was enhanced:
      • Clustered tables presentation was added.
      • Bytes processed/billed and other statistics are presented in a new panel in the data viewer.
    • AlloyDB was added to the Cloud Explorer.
    • Informix: Time Series data type was supported.
    • DuckDB: Spatial data visualization was added.
  • Localization:
    • Romanian localization was added.
    • French localization was improved.
Detailed DBeaver Ultimate 24.1 release notes.

24.0

March 11, 2024
  • New Google Firestore driver allows you to display collections and subcollections in the data grid, and edit database entities using metadata editor. You can connect to Firestore using Cloud Explorer.
  • SQL Editor:
    • New SQL query highlighting and script validation were enabled by default
    • Outline viewer of the SQL query structure was added.
  • AI enhancements:
    • Google Gemini support was added.
    • GPT-4 model was added, and legacy OpenAI models were removed.
    • Chat mode was improved: AI comments representations and the ability to disable all comments were added, Chat mode interface and behavior were enhanced.
  • Data Editor: 
    • Advanced paste was improved: ability to ignore quotes was added and the paste of multiple records was enhanced.
    • Scrolling multiple tabs results was improved. You can scroll all result sets using Ctrl. 
    • Filter and value selector panel were improved.
  • ER Diagrams: Orthogonal paths routing was significantly improved. Connection rendering was enhanced, bridges can be highlighted according to the selected column, and a separate presentation of vertical routes was added.
  • Metadata Editor:
    • Primary/unique key can be created automatically along with new columns
    • Object creation dialog was redesigned.
  • Data transfer:
    • Multithreading support for multiple table export was added.
    • Users can select any character as a delimiter when exporting in TXT format
    • Configuration of exported columns has been improved. You can quickly select a single column for export.
    • Many bug fixes and enhancements have been made.
  • Task management: 
    • Users can change the file format in the saved task, for data export and data import.
    • Variables support was added for the Composite tasks.
  • Accessibility: Notifications can be read with a screen reader (JAWs, NVDA, or Narrator).
  • Security
    • Master password policy was added: master password can be configured or disabled.
    • Many third-party drivers were upgraded due to security issues: Dameng, Flight SQL, MariaDB, Oracle, Snowflake, SQLite, and SQL Server.
    • GCP SDK and Microsoft Azure SDK were upgraded due to security issues.
  • New drivers:
    • Altibase
    • Firestore
    • RisingWave
    • StarRocks
    • Cubrid driver support was significantly enhanced
  • Databases: Added many improvements for BigQuery, ClickHouse, Dameng, DB2, DynamoDB, EDB, Firebird, Google Bigtable, Google Cloud SQL, Greenplum, Microsoft Access, MariaDB, MySQL, MongoDB, Oracle, PostgreSQL, Redis, Redshift, Salesforce, ScyllaDB, Snowflake, SQLite, SQL Server, Sybase, TDengine, and Teradata.
  • Localization:
    • Ukrainian localization was added.
    • French, Japanese, Italian, and Portuguese localizations were improved.
    • All standard UI translations were updated for all languages.
Detailed DBeaver Ultimate 24.0 release notes.

23.3

December 11, 2023
  • Cloud Storage Services integration. We added support for Google Cloud storage, Microsoft Azure, and Amazon S3. Now you can open, save, and copy scripts and other files in the most popular cloud storage services by using Cloud File Explorer.
  • AI enhancements
    • AI Chat is a new way to use artificial intelligence to build SQL queries: you post a phrase in a human language in the chat, receive a working SQL query, and modify it with AI until you get a perfect result.
    • Azure OpenAI service is now available as an alternative AI configuration.
  • ER Diagrams
    • New diagram notations are available: Crows Foot and Bachman.
    • Diagram presentation was significantly improved.
    • Experimental feature: you can enable Orthogonal routing that shows not only relationships between tables but also relationships between specific columns.
  • Security
    • A master password is requested to protect secure data, such as cloud configurations. We have improved the master password dialog so that users can choose how to protect their credentials.
    • Performed a serious security assessment and updated several third-party drivers where major vulnerabilities had been found: Redis, IBM DB2, Google BigQuery, AWS Athena, Amazon Neptune, Kafka, Couchbase.
    • The Export functionality and Version Update can be completely disabled.
  • Data Editor
    • Multiple query results can be displayed vertically.
    • `Go to column` action (Ctrl+Shift+G) allows you to find a specific column.
    • Column search was added to the Metadata panel.
    • User can add a shortcut for setting row color.
    • The Grouping panel now shows the actual executed SQL.
    • Many minor bug fixes, enhancements, and improvements have been made.
  • SQL Editor
    • Numerous improvements have been made to some processes, such as single-tab results visualization, output panel display in the statistics tab, tab closing, error representation, working with SQL console, and others.
    • Experimental feature: enhanced smart completion can be enabled in Preferences.
  • Data transfer
    • When transferring data from one table to another, you can choose how new tables and column names are transformed by using Mapping Rules.
    • Excel (XLSX) export supports columns auto-fit: you can customize column widths in DBeaver, export the data to Excel, and the output columns will be the same width as the original columns.
  • Schema compare: The results of change tree migration can be exported to a text file.
  • Cloud Explorer
    • You can connect to Google Bigtable via Cloud Explorer
    • SSH tunnel configuration was added — SSH tunnel is automatically assigned to a cloud database when you add it to the Database Navigator from Cloud Explorer
  • New drivers
    • ScyllaDB
    • AlloyDB
    • Azure Cosmos DB (Cassandra)
    • Dameng
    • JDBCX driver
  • Databases
    • Google BigQuery DDL for storage procedure is now available.
    • Greenplum 7.0 is supported.
    • Oracle XML presentation is supported.
    • PostgreSQL Debugger was improved: we fixed many significant bugs and enhanced the performance.
    • Vertica stored procedures are supported, you can view and execute them. The execution plan is available, including JSON queries.
  • Localization
    • Traditional Chinese, Chinese Simplified, German, and Portuguese translations are improved
    • Users can now select Portuguese as the default language during installation
Detailed DBeaver Ultimate 23.3 release notes.

23.2

September 12, 2023
  • Tableau integration: You can connect to Tableau to edit Tableau custom queries in DBeaver interface.
  • Kubernetes proxy. Now, you can connect to a database using a Kubernetes proxy. To configure it, click the “Network configuration” button in the connection dialog.
  • Spatial data presentation is enhanced: you can copy coordinates, viewport bounds, and selection. You can also view PostGIS data and labels on the map.
  • Accessibility
    • Screen readers’ support and keyboard navigation were improved: connection dialogue is accessible, and you can use JAWs screen, reader on the connection dialogue, Data grid, Object properties, ER Diagrams, and other application areas. 
    • High contrast theme was better supported: you can choose a high contrast theme in your OS, and the DBeaver high contrast theme is enabled.
  • ODBC driver became more stable. It supports any database with the available ODBC driver,  the most popular ones being Amazon Redshift, BigQuery, DB2, DB2 for IBMi, MariaDB, MySQL, Oracle, PostgreSQL, Snowflake, SQLite, and SQL Server.
  • New drivers
    • Azure Cosmos DB
    • AWS Timestream
    • Amazon Neptune
    • Influx 3
    • Kafka
    • Crate DB for Postgres 
    • Materialize 
    • Salesforce 
    • TDengine 
  • Security
    • Certificate management was added: You can find CA certificates used for SSL access in the Trust store section in Preferences or import your certificate.
    • Project and user password security was improved.
    • We have improved the security of storing user settings.
    • SQLite driver version was updated due to the vulnerability CVE-2023-3269.
  • Databases
    • Google BigQuery DDL for storage procedure is now available.
    • Greenplum 7.0 is supported.
    • Oracle XML presentation is supported.
    • PostgreSQL Debugger was improved: we fixed many significant bugs and enhanced the performance.
    • Vertica stored procedures are supported. You can view and execute them. The execution plan is available, including JSON queries.
  • Localization
    • Traditional Chinese, Chinese Simplified, German, and Portuguese translations are improved.
    • Users can now select Portuguese as the default language during installation.
Detailed DBeaver Ultimate 23.2 release notes.

23.1

June 12, 2023
  • ODBC driver was improved:
    • The ability to work on Linux and macOS was added
    • The ability to use ODBC instead of JDBC for most data sources was added 
    • Driver substitute selector was added to the new connection dialog
    • Legacy ODBC driver in Community Edition was deprecated
  • SQL Editor:
    • The ability to use spell checking, including checking SQL keywords and data types, was added.
    • Result tabs can now be detached.
    • The toolbar became customizable: users can choose which buttons to show or hide 
    • Hovering information for SQL errors and spelling annotations was added
    • The ability to directly execute SQL scripts in native clients was added for Oracle, MySQL, and PostgreSQL
  • ER Diagram became accessible: users can work with it using the keyboard and the NVDA screen reader
  • Data Editor: 
    • The bottom toolbar became customizable. Users can select which buttons to show or hide
    • Disconnected editors can be easily reconnected
    • Data filter support in the Grouping panel was added
  • Data Transfer: the ability to select a sheet for import from Excel was added
  • Tasks: email notification about the failed scheduled tasks was added
  • Connectivity:
    • Kerberos subject authentication support was added.
    • It is now possible to connect through Azure Cloud without entering a username.
    • The issue with the inability to connect via Azure SSO after token expiration was fixed
  • General UI:
    • Part divider UI was redesigned
    • Database editors remain open after disconnect (configurable)
    • Many font issues were fixed
    • A lot of UI rendering improvements were made
  • Database drivers:
    • Oracle NetSuite driver was added
    • Raima driver was added
    • SingleStore support was added
    • TiDB driver was added 
    • TiDB Cloud Telemetry support was added 
  • Databases:
    • Greenplum: support for version 7.0 was added
    • Redshift: Support of Redshift servlets on Cloud Explorer was added
    • Snowflake: spatial data support was added
    • SQLite: the ability to open ER Diagram in Simple View was added
  • Localization:
    • Traditional Chinese, Brazilian Portuguese, German, and Italian translations were updated.
    • Traditional Chinese language was added to the Windows installer
Detailed DBeaver Ultimate 23.1 release notes.

23.0

March 13, 2023
  • Database drivers:
    • A new ODBC driver was added
  • ChatGPT:
    • OpenAI (ChatGPT) integration was implemented out-of-the-box in PRO versions
  • Cloud Explorer:
    • Azure Cloud support was added
    • PostgreSQL and MySQL support was added in Azure Cloud
  • Accessibility:
    • The text reader for the entity editor was improved
    • The text reader for the data grid was improved
    • Font settings are now respected in all editors/popups
    • Many new keyboard shortcuts were added
    • The catalog/schema selector now supports keyboard-only mode
    • Reader texts were localized
  • Data Editor:
    • A few elements and behavior in Data Editor were redesigned
    • The issues with filtering and ordering data were fixed
    • The context menu was improved
  • SQL Editor:
    • Query generation from human language text was added
    • The query execution plan was improved
    • Auto-completion issues were fixed
  • Data transfer:
    • Data export to Google Sheets and Google Drive was added
    • Data export in SQL INSERT format now supports custom target table name configuration
  • Databases:
    • PostgreSQL: The ability to create a full backup and SSL keys automatic conversion was added
    • SQL Server: VARCHAR(MAX) data type support and table column comments support were added
    • MongoDB: issues with running db.runCommand, JSON view and boolean values display were fixed
    • Teradata: multiple issues were resolved, including secure zones support and Kerberos authentication
    • Snowflake: Schema Comparison and Table constraints reading issues were fixed
    • Redshift: The issue with access to Redshift Datashare was resolved
Detailed DBeaver Ultimate 23.0 release notes.