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.
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.0is 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
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.0is 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.
