DBeaver Enterprise 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 Enterprise 24.2 release notes.

DBeaver Enterprise 24.1

June 10, 2024

• Connectivity:
  • Shared SSH session support was added.
  • Using multiple jumps tunnels when connecting via SSH was supported.
  • AWS Session Manager (SSM) was supported.
• 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:
  • AI smart assistance and AI Chat in the SQL Editors were enabled by default.
  • Custom Llama-based AI models were supported.
• 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.
• 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.
  • Informix: Time Series data type was supported.
  • DuckDB: Spatial data visualization was added.

• Localization:
  • Romanian localization was added.
  • French localization was improved.

Detailed DBeaver Enterprise 24.1 release notes.

DBeaver Enterprise 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.

• 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 Enterprise 24.0 release notes.

DBeaver Enterprise 23.3

December 11, 2023

• 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.
• 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 Enterprise 23.3 release notes.

DBeaver Enterprise 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 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, 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 once 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
  • 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 own 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 Enterprise 23.2 release notes.

DBeaver Enterprise 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
  • 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 Enterprise 23.1 release notes.

DBeaver Enterprise 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
• 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 Enterprise 23.0 release notes.

DBeaver 22.3

December 12, 2022

• General Improvements:
  • SSH jump server support was added for SSHJ implementation
  • Multi-connections behavior configuration was improved 
  • Visual Query Builder: Join tables visualization was improved
  • New database drivers: Influx2, CouchBase3, OpenSearch, Fujitsu, TimeStream, Oracle Cloud JSON
• Data Editor
  • Refresh and row count icons were updated 
  • Export options in UI were improved
  • The top and bottom action toolbars were redesigned
• SQL Editor
  • Auto-completion with the TAB key was implemented
  • Big SQL file support was improved (automatic disablement of syntax validation)
• Data Transfer:
  • The issue with the SMTP configuration was resolved 
  • The display of a warning about override output files on data export to file was added
  • Columns auto-mappings were improved (case-insensitive search)
  • Export to XLSX now supports different modes for spreadsheet rows append
  • The description column was added to XLSX format (configurable)
  • The tables/column mapping dialog was improved
• Cloud Explorer & S3 Browser:
  • Microsoft Azure support for SQL Server was added 
  • The option to create folders in S3 using File Explorer was added
  • Google BigQuery and Google Spanner were added to the Cloud Explorer 
  • GCP support in the Cloud Explorer was improved 
• Clickhouse:
  • Clickhouse Cloud support was added
  • Execution Plan support was added
  • SSL connection configuration support was added
  • UUID data type support was added
  • Datetime64 data type support was added
• Teradata:
  • Macros support has been added 
  • LDAP to connection settings was added 
• Snowflake:
  • Java 17 support was added
  • Stored procedure and functions management were added

Detailed DBeaver PRO 22.3 release notes.

DBeaver 22.2

September 12, 2022

SQL Editor  New Features

• Introducing SQL Terminal, which captures the query statement, query results, and messages in text format. The SQL Terminal updates to append each SQL query creating a visual history of statements run, the corresponding result set, and any messages in one view. The new terminal is enabled by selecting the terminal icon on the SQL Editor screen. 

• Generate DDL from the resultset enables DDL script for table creation while reviewing query results. Open the metadata panel and click the DDL button. 

Data Editor New Features

• Visualization of arrays and multi-row data types for relational & NoSQL databases. Introduces the capability for cell expansion to see all lines in an array by selecting the down arrow icon within the data editor window. 
• Excel-like behavior for inline data editing when selecting ‘Enter’ after values are entered in a cell, the value will be saved and the field focus will move automatically to the next row. This feature is disabled by default, to enable go to settings (Preferences > Select next cell after line item).

General UI New Features

• The default embedded browser was changed to Microsoft Edge after Internet Explorer’s long-awaited retirement. Browser view is used for GIS data and other browser-based user elements.

Data Transfer New Features

• Target table properties (such as engine, charset, etc.) were added in the import wizard for data transfer. Table property values entered will automatically be included in the Target DDL creation script. To set table properties, access the import wizard and select the ‘Table Properties’ tab. 
• Multiple improvements to data transfer capabilities. Configuration was added to enable or disable the header within CSV and TXT formats when exporting to the same file multiple times. The Target DDL generator now checks for naming conflicts within existing non-table objects for the target table. See the complete list of all improvements in detailed release notes.

Database Management New Improvements

• Oracle:
  • Generate DDLs for Scheduler Jobs
  • The Oracle Cloud database connection issue was fixed
• Redis:
  • Connect by URL, SSL support, and Cluster support
• S3 Browser:
  • Copying files from DBeaver with drag and drop was fixed
  • XML/JSON files not opening in DBeaver was fixed

  See a complete list of improvements and fixes in the detailed 22.2 release notes.

DBeaver 22.1

June 13, 2022

• Data editor:
  • Option “show whitespaces” was added
  • The ability to select spatial objects on map and data grid was added
  • NoSQL Documents in grid mode now support columns reorder
  • Data type formatting: digit group size option was added, configuration save was fixed
• SQL editor:
  • Script error visualization is now configurable
  • The command for data export automation was added
  • Schema selector now supports a large number of objects
  • Database navigator: connection read-only state switcher was added in the main toolbar/menu
• Data transfer:
  • The “Ignore duplicated rows” option was added
  • Table mapping “re-create” support was improved
  • The “Append to existing file” feature was improved (for CSV, TXT, and XLSX formats)
  • Data transfer in AWS Keyspaces and Cassandra was improved
  • Data compare: changed rows visualization was fixed, MS Access support was added
• Task manager:
  • Shell command task was added
  • A lot of improvements in task notifications and reporting
  • The possibility to pass external variables for connection configuration was added
• Entity diagrams:
  • Connected entities highlighting was added
  • Entities and columns search was improved
  • New diagram routing was added
• Google Cloud Platform (GCP) support was added:
  • Managed database drivers were added: PostgreSQL, MySQL, SQL Server
  • GCP databases are available in Cloud Explorer
  • GCP authentication support was added
  • GCP SSO support was added
  • IAM auth was added to Spanner, BigQuery, and BigTable drivers
• AWS cloud platform:
  • S3 browser: files drag and drop was improved; file region and size resolve were added
  • GOV region support was added
• Windows: DBeaver now supports workspaces on network paths (e.g.\\network-share\workspace)
• MacOS: an issue with application launch was fixed (problem with plist file modification)
• Databases:
  • Vertica: metadata performance was significantly improved
  • DB2 i: a lot of improvements in database support
  • Snowflake: metadata read performance was significantly improved
  • DynamoDB: SQL support was significantly improved
  • SQL Server: authentication configuration was redesigned, AD authentication was improved
  • Netezza: metadata read was improved
  • Redis: multi-database cluster support was fixed
• New database drivers:
  • Databricks
  • Apache Kyuubi

Detailed 22.1 release notes

DBeaver 22.0

March 14, 2022

• Data Editor:
  • The option to highlight selected cell values was added
  • The date/time editor now supports calendar-like UI
  • Сolumn filters edit dialog UI was improved
• SQL Editor:
  • The issue with app freeze on very complex queries executing was fixed
  • Parameters binding dialog now supports multiline editor
  • Auto-completion now uses the “hippie” completion algorithm by default
• Data transfer:
  • XLSX import was improved. The issue with column mapping was fixed
  • Export of columns of composite data types support was added
• AWS S3 browser was added
• Connectivity:
  • SSH: remote host verification was added
  • Auto-close of IDLE connections option was added (configurable)
  • SAP HANA SSO support was added
  • Snowflake: private key authentication support
• Session manager: Column grouping was added
• SQL Server Synapse support was improved (metadata reading)
• Oracle:
  • Metadata load performance was significantly increased
  • PL/SQL syntax support was improved
• MongoDB: advanced shell queries support
• Teradata:
  • Database navigation redesign
  • TLS driver support was added
• Redis/Elasticache:
  • Now available in Cloud Explorer
  • The issue with the visible of keys in Elasticache was fixed
  • The bug with working the key hierarchy was fixed
• EDB extension was added
• Babelfish support was improved
• New database drivers:
  • SalesForce CDP
  • Apache Kylin
  • Apache Druid
  • Denodo
• Files drag-n-drop (between DBeaver and OS file explorer) support was added in the project explorer
• Resource manager: cross-project connection drag-n-drop was improved
• Chinese, Italian, and Japanese localizations were extended

Detailed 22.0 release notes

DBeaver 21.3

December 6, 2021

• Data transfer:
  • Possibility to send exported files by email
  • Configuration settings to improve data import performance
  • Improvements for transferring data in CSV, XLSX, and XML formats
  • UI redesign for data transfer wizard
• Data compare:
  • Configuration of columns to compare
  • Generator of SQL script for differences
• Schema compare:
  • Progress log visualisation
  • Additional configuration for comparing
  • Special form in the Preferences dialog to import Liquibase Pro licenses key
• Data viewer: a lot of minor rendering improvements
• Metadata search: search in object comments, procedures, views, and packages
• Teradata driver now supports TLS connections and extra metadata objects
• Redshift, PostgreSQL: a new view for database structure browser
• Netezza: improvements for database metadata reading
• Oracle: geometry data editor was added
• SQL Server:
  • MFA authentication support was fixed
  • A geometry editor was added
• New database drivers: Babelfish and OceanBase
• Auto-recovery for the query manager database
• ERD editor: layout improvements
• Improved dark theme support
• Possibility to access TLS databases from the corporate environment
• Security:
  • Project configuration encryption: problems with master password encryption were resolved
  • TLS 1.1/1.0 support
  • SSH jump servers support
• Apple M1 product package

Detailed 21.3 release notes

DBeaver 21.2

September 7, 2021

• Forward engineering in entity diagrams (ERD) was added
• Database tasks can be organized in folders now
• Schema comparison in DBeaver supports Liquibase Pro features
• SSH jump server support was added
• Navigator mode “Show all tables in a single list” was added
• Visual query builder: cross joins support and extra configuration options were added
• SQL editor: output and log panels UI was improved, script variables panel was added
• Data editor:
  • Multi-row record mode support was added
  • Row coloring supports LIKE and REGEX conditions now
  • A lot of minor interface improvements were added
• Enterprise authentication:
  • SSO session refresh/invalidate feature was added
  • Redshift federated authentication configuration was added
  • RDS connections support SSH tunnels
• Data transfer:
  • Data export from document databases to flat files was improved
  • Multiple improvements in column mappings
  • Configuration for performance tuning was added
• User password management was added for MySQL, SQL Server, Sybase, Oracle, and Netezza
• MongoDB: SQL queries support was improved: multiple column conditions, BETWEEN
• PostgreSQL:
  • Multi-column foreign key support was added
  • Active schema selector was improved
  • All GIS data types support was added
  • Backup/restore in custom format was fixed
• Redshift: user permission editor was added

Detailed 21.2 release notes

DBeaver 21.1

June 7, 2021

• AWS SSO support was added for AWS databases: RDS, DynamoDB, Redshift, and Athena
• MongoDB:
  • JOINs and conditional operators were added to SQL queries
  • Atlas authorization was improved
  • Client-side JavaScript processing was re-designed
• Redshift:
  • User and permission management was added
  • Redshift data share support was added
  • Federated authentication support was added
• Support for national date formats and Unicode was added to the Windows scheduler.
• Metadata read was enhanced for PostgreSQL, Oracle, Informix, Teradata, Netezza, Vertica, Exasol, DB2, Greenplum, SAP HANA, Bigquery, and Snowflake.
• SQL Server:
  • An extended properties editor was added
  • MFA authentication was supported
• Dark theme support was improved
• DBeaver migrated to the new Java version 11.0.11

Detailed 21.1 release notes

DBeaver 21.0

Mar 8, 2021

• Changes since 7.0:
  • New NoSQL databases: CouchDB, AWS DocumentDB, AWS Keyspaces, Yugabyte CQL
  • New enterprise extensions for Netezza and Informix
  • New SQL drivers: Trino, SQreamDB
  • Enterprise authentication support: AWS IAM, Oracle Wallet
  • Data transfer: UI redesign, import from XLSX and XML formats, “insert or replace” feature
  • Data compare report configurator
  • Schema compares support for plenty of databases
  • Spatial/GIS viewer: Redshift and SQLite support, possibility to add custom tiles
  • Tasks for all database maintenance tools
  • Navigator: Schema and table statistics view
  • A lot of UI improvements for SQL editor: result tabs, main toolbar, output, and log tabs
  • A lot of UI improvements for the Data editor: data rendering, highlighting, customizable boolean cells, and much more
  • A lot of MacOS bug fixes and support for BigSur
• Changes since 7.3:
  • Schema Compare now supports SQL Server, Snowflake, Netezza, Vertica, SQLite, and Firebird
  • Mock data generator: UI redesign and performance improvements
  • Redis/Elasticache: user name/password authentication support was added
  • MongoDB: SQL GROUP BY and aggregation functions support were added
• Other:
  • We switched to calendar versioning: version 21.0 comes after 7.3.

Detailed 21.0 release notes

DBeaver EE 7.3

Dec 7, 2020

• New features:
  • DocumentDB support
  • Tasks scheduling for MacOS and Linux
  • Folding for SQL-editor
  • New extension for Informix
  • Action icons for the Navigation tree
  • Quick filters for the Navigation tree
  • SSL support for MS SQL Server
• Major improvements:
  • MongoDB extension:
    • Aggregate functions support in SQL editor (group by, having)
    • Old MongoDB versions support
    • Multiple data transfer improvements
  • Additional improvements for Netezza metadata support
  • DynamoDB: many enhancements for the data editor and SQL editor
• Other:
  • A lot of fixes for MacOS-specific UI issues

Detailed 7.3 release notes

DBeaver EE 7.2

Sep 7, 2020

• New features:
  • Database statistics in the navigation tree for tables, schemas, and databases
  • Tasks for all database maintenance tools
  • CouchDB support
• Major improvements:
  • Import to database:
    • Import from XLSX
    • Import to the new table
    • Import from multiple files
  • Grouping as a new feature for Visual Query Builder
  • Netezza extension:
    • Native table metadata support: constraints, table distribution, DDL
    • Synonyms support
    • Sequences support
    • Databases and table size statistics
    • Procedure editor
  • DynamoDB support:
    • SQL and JSON queries for data search
    • Table data editor
    • Table filters
  • AWS IAM authentication improvements:
    • Session token support
    • Third-party account access
• Other:
  • YugabyteDB and SQreamDB drivers
  • 32-bit versions are out of support

Detailed 7.2 release notes

DBeaver EE 7.1

Jun 8, 2020

• New features:
  • Simplified database structure view
  • Pin (freeze) column in the data viewer
  • Advanced authentication:
    • AWS IAM authentication for RDS for MySQL and PostgreSQL
    • Kerberos for PostgreSQL, MariaDB, Oracle and Presto
    • Oracle Wallet authentication
    • PgPass authentication
  • User profiles
  • Netezza extension
• Major improvements:
  • MongoDB client-side JavaScript processing
  • Redis key filter
  • Exasol support
• Other:
  • Portuguese (BR) localization was added
  • Japanese localization was significantly improved
  • Visual query builder UIX was improved

DBeaver EE 5.3

Dec 10, 2018

• New features:
  • Charts as an additional view in Data Editor, Grouping panel, and results of SQL request
  • Various options for word highlighting in SQL Editor
  • Support for script sharing in Git: information about connection can be stored in the SQL script now
  • Data migration from SQL databases to MongoDB and Cassandra
  • Administrative panel for remote connections management for PostgreSQL, Oracle, DB2, MySQL, MariaDB, and MongoDB.
  • Easy way to install additional extensions
  • Tip of the day
• Major UI improvements:
  • Metadata Editor was completely renewed.
  • Keyboard shortcuts were reworked to fit various languages and OSes better.
  • A lot of new options were added to preferences for better flexibility and driver tuning.
  • Support for the Darkest Dark theme was added.
  • SQL completion proposals were improved: better object search, and better performance.
  • German, Chinese, and Russian localizations were significantly improved.
• New databases:
  • Google BigQuery
  • Microsoft Azure
  • DBF files
• The wide range of new features for databases:
  • MS SQL Server: new advanced extension with all main specific features support
  • Apache Hive/Spark/Impala:
    • table data edit support
    • table/view source reading
    • driver version upgrade
  • Greenplum: native metadata support
  • AWS Athena: new special connection page
  • AWS Redshift
  • Google BigTables
  • PostgreSQL
  • Oracle
  • Firebird
  • Clickhouse
  • Cockroach

DBeaver EE 5.2

Sep 10, 2018

• New features:
  • Visual Query Builder – the new simple way to construct SQL queries
  • Import from CSV files: direct import from CSV into your database table(s)
  • Native database backup and restore for MySQL/MariaDB and PostgreSQL
  • Support for special security tools:
    • SSH over SOCK proxy support
    • Advanced cryptography and authentication algorithms
• Major UI improvements:
  • The connection manager interface was significantly simplified.
  • Entity diagram design became more convenient and attractive.
  • Quick access to all main controls in the SQL editor was implemented.
  • SQL formatter and autocompletion were significantly improved.
  • Mockdata generator now works for MongoDB and Cassandra
• New supported databases:
  • InfluxDB:
    • Full support of InfluxQL
    • Time series charts rendering
    • Database schema browser
  • TimescaleDB: time-series database based on SQL interface
  • AWS Redshift: brand new driver with Redshift-specific features
  • Yellowbrick: super-fast analytical database
  • CockroachDB: distributed SQL database built for data survival
  • Elasticsearch: JDBC driver for Elasticsearch SQL
  • Other: AWS Athena, Progress OpenEdge
• New driver versions for:
  • PostgreSQL 10+
  • MySQL 8.x
  • Apache Hive 1.2+
  • Cassandra 3.5.1
  • MongoDB 3.8.0
  • Snowflake: new connection page design
• A wide range of administration features was added for:
  • PostgreSQL
  • MySQL/MariaDB
  • Oracle
  • MS SQL server
  • SAP Hana
  • Vertica

DBeaver EE 5.1

June 11, 2018

• UI was significantly improved:
  • a possibility to expand the filter field for long requests was added
  • high-resolution screen was supported
  • some icons were updated
  • problems with editable fields were fixed
• New analytical features:
  • a new panel for data grouping was added
  • existing aggregation panel was improved (and renamed into Calc)
• Interaction with data in the result viewer table was simplified:
  • drag-n-drop for columns was improved
  • navigation by links was improved
  • some shortcuts were replaced to avoid conflicts with native OS shortcuts
• SQL Editor became more stable and clear:
  • memory and resource leaks were fixed,
  • SQL formatting was made clear
  • procedures were added to the autocomplete function
• Data in a user-specific format can be generated through the Mock data generator
• New formats were added to Data Export:
  • Markdown and DbUnit formats were added
  • Export to XLS format was improved
  • Export to SQL INSERT was fixed
• New improvements for ER diagrams:
  • Columns and tables can be copied from the ERD
  • Export to images and SVG was fixed
  • Drag-n-drop was improved
• A search in query history was added
• Database-specific improvements:
  • Postgres:
    • stored procedures debugger was added
    • permissions editor was significantly improved
    • active schema switch was redesigned
    • a lot of metadata read/edit functions were added
    • PostgreSQL v10 support was improved
  • MySQL: MySQL v8 support was added.
  • MariaDB: packages support was added
  • Oracle:
    • JDBC driver version was upgraded to 12g
    • expired password change support was added
    • timezone support was added
    • jobs scheduling was added
    • PL/SQL parser was improved
    • error position detection was improved
    • metadata read was improved
  • SQL Server: metadata read/edit was improved
  • MongoDB:
    • JSON renderer was improved
    • date/time attributes renderer was fixed
  • Cassandra:
    • Support for complex data types was added: text columns viewer, collections of complex types, tuple types support, UDT support
    • materialized view DDL was added
    • error position detection was added
  • Vertica:
    • table columns editor was added
    • metadata reading was improved
  • DB2: table columns editor was added
  • Redshift, Firebird: driver version was updated

DBeaver EE 5.0

March 12, 2018

DBeaver EE 5.0 is the first major Enterprise version release. Tons of bug fixes and improvements oriented on enterprise customers were made. A few extra enterprise databases were added in the list.

• New features
  • Mockdata generator (EE version bundled with advanced generators).
  • Referencing foreign keys navigation in the results viewer
  • JOINs auto-complete in SQL editor
  • Git integration (using external Eclipse Git plugin)
• General improvements
  • Chinese, German, French, and Russian localizations were significantly improved. The UI language can be changed in preferences
  • Icons were replaced with a new custom DBeaver icon set
  • HighDPI monitors support has been improved
  • Some keyboard shortcuts were fixed (conflicts with MacOS/Linux OS shortcuts)
  • The auto-reconnect feature has been added (optional, can be configured in preferences)
  • SQL editor: extra warnings, stored procedures quick execute, syntax highlighting and other features were added
  • The connection properties dialog was improved
  • The results viewer has been improved (grid and plaintext UI renderer, UI, data types coloring)
  • Foreign keys/references navigation was improved
  • A lot of small UI fixes were added
• Database specific
  • GIS (geometry) data types support was added to MySQL, MariaDB and PostgreSQL
  • Ref cursors support was fixed for PostgreSQL and Oracle.
  • Objects DDL generatation was improved in Oracle, PostgreSQL and MySQL
  • Extra metadata objects support was added for PostgreSQL, MySQL, MariaDB, Oracle, HANA, Firebird
  • PostgreSQL: role permission management was implemented
  • MS SQL and Sybase : schema/tables list reading was fixed (including older SQL Server versions)
  • MS SQL: modern Microsoft driver was added
  • Sybase/SAP ASE: native jConnect driver configuration was added
  • Vertica: extra features support was added (flex tables, projections), driver is bundled in distribution.
  • Firebird: Jaybird 3.0 driver support was added
  • Snowflake extension has been added
  • MongoDB: multiple bugfixes, datetime data type support was improved
  • Cassandra: list, set and map data types support was improved. Driver TCP/IP configuration was added.
  • A lof of small db-specific bugfixes and improvements

DBeaver EE 4.3

December 11, 2017

DBeaver EE version 4.3 is the first real Enterprise version. We are thankful to everyone who have bought DBeaver licenses and thus supported our development efforts. And we are really inspired by the multiple things that we can do for the product thanks to the Enterprise version. When working on this release, we mostly concentrated on the standard workflow for big customers and attempted to simplify the integration process of DBeaver to a corporate environment. Here are the main features that were added to DBeaver version 4.3:

• All major database drivers included in distribution: Oracle, DB2, MySQL, PostgreSQL, Vertica, CSV, Derby, Firebird, H2, Apache Hive, HSQLDB, Informix, SQL Server, Sybase, ODBC, MS Access
• MacOS X installer (PKG)
• no need to setup Java any more
• Eclipse plugin version
• DBeaver now based on the most recent Eclipse 4.7 platform
• Java 9 support
• Office integration: opening query results directly in Excel/Calc
• Vertica extension: support of native Vertica metadata model
• Configuration of new drivers: OrientDB, Neo4j, Solr, Cloudera Impala, CUBRID, PrestoDB
• Chinese, Russian and German localizations were fixed and added back to the default distribution
• Improved HighDPI monitors support
• Fixed connectivity problems for Mongo DB: SSH tunnels, replica sets, etc.
• A fixed key browser in the multi-database mode for Redis
• Major changes for results viewer:
  • Referencing tables navigation
  • Viewer zoom support
  • Data types coloring
• Improved multi-cell copy-paste support
• ERD: diagrams custom coloring, export in SVG format
• Many fixes and improvements in SQL auto-complete, auto-format and specific dialects support
• Major user interface improvements
• A lot of minor UI fixes

DBeaver EE 4.2

September 10, 2017

• Sample database (SQLite) is included in DBeaver distribution
• Oracle, DB2, MySQL, PostgreSQL and Vertica drivers are included in DBeaver distribution
• Results viewer: save filters settings for each table
• Results viewer: columns reordering with drag-n-drop
• Results viewer: open in Excel
• Results viewer: dark theme support was improved
• Results viewer: copy column names/row numbers configuration
• Custom (named) object filters support was added
• SQL editor: variables support was fixed (global vars)
• SQL editor: quoted identifiers support was improved
• ERD: bring to front/send to back, notes coloring
• ERD: export in SVG
• SQL editor: delimiters transform utility
• Database navigator: additional view customization
• Full-text search processor was fixed (failed on the first error)
• MySQL: local client detection was fixed, and multiple metadata reading fixes
• PostgreSQL: XML values view/edit were fixed
• PostgreSQL: SSL configuration was fixed
• PostgreSQL: access methods/operators metadata support was added
• PostgreSQL: database dump wizard was improved
• Exasol: object comments support was improved, and DEFINE command support was added
• SQL Server: support of [] quotes
• Informix: active database change was added
• Informix: metadata reading was fixed and improved
• Redshift: driver version was updated
• The drivers download was fixed
• EE version Windows installer was fixed
• A number of minor UI bugs (including UI freeze issues) were fixed