DBeaver 24.0.0.202404011634 Ultimate x64 + macOS

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

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.
ER Diagram became accessible: users can work with it using the keyboard and the NVDA screen reader
New drivers
Azure Cosmos DB
AWS Timestream
Amazon Neptune
Influx 3
Crate DB for Postgres (thanks @proddata)
Kafka (available in Ultimate Edition)
Materialize (thanks @bobbyiliev)
Salesforce (JDBC driver created by DBeaver team)
TDengine (thanks @sangshuduo)
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

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
Query execution plain 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: mutiple issues were resolved including secure zones support and kerberos authentication
Snowflake: Schema Compare and Table constraints reading issues were fixed
Redshift: The issue with access to Redshift Datashare was resolved

Всё работает на Linux -- в архив не ту версию положили. Нужно Ultimate, а положили Enterprise.

General Improvements:
SSH jump servers 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 counts 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 files 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 was added

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 resultset enables DDL script for table creation while reviewing query results. Open the metadata panel and click DDL button.

Data Editor
New Features

Visualisation 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 behaviour 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

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 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. Target DDL generator now checks for naming conflicts within existing non-table objects for the target table. See complete list of all improvements in detailed release notes.

Database Management
New Improvements

Oracle:
Generate DDLs for Scheduler Jobs
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

Data Editor:
Option to highlight selected cell value was added
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 problem 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
EnterpriseDB extension was added
Babelfish support was improved
New database drivers:
SalesForce
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