This article details the key updates in DBeaver version 26.0.4, covering improvements in SQL Editor, AI assistant, Data Editor, Data Export, Connectivity, Security, and Miscellaneous features.
DBeaver is a popular open-source database tool that provides a unified interface for working with various databases. The latest version, 26.0.4, brings several important improvements and bug fixes across different components. Let's take a closer look at what's new.
Core Changes
SQL Editor
Space Trimming: New options have been added to trim leading or trailing spaces in the selected text or the whole script. This can be extremely useful when formatting SQL code. For example, if you have a SQL statement like:
SQL
1SELECT column1, column2
2FROM your_table;
You can easily trim the extra spaces to make it more standardized:
SQL
1SELECT column1, column2
2FROM your_table;
Transaction Mode Display: An issue with incorrect transaction mode display has been resolved. This ensures that users get accurate information about the transaction state in their SQL operations.
Transaction Monitor Fixes: Two issues related to the transaction monitor have been fixed. One where it showed "N/A" after the toolbar was changed with drag-and-drop, and another where the "Open a separate connection for each editor" preference was not saved.
DROP Confirmation Dialog Layout: The layout of the DROP confirmation dialog for long SQL queries has been fixed, providing a better user experience when deleting database objects.
AI Assistant
The default temperature value for different AI engines has been fixed. This parameter in the AI assistant can affect the creativity and determinism of the generated responses, and now it is set correctly for better performance.
Data Editor
Reference Tables: An issue where reference tables became empty when fetching the next page in the References panel has been fixed. This ensures the integrity of data exploration in the data editor.
Column Data Type Display: An option to show column data type names in column headers has been added (disabled by default). This can be enabled in the settings to provide more information at a glance. For example, in a table view, instead of just seeing the column names, you can also see their data types like INT, VARCHAR, etc. in the headers.
Custom Data Type Expansion: An exception when expanding a custom data type value in Record mode has been fixed, allowing for smoother handling of custom data types.
Data Export
Object list resizing in the Export/Dump window has been fixed, ensuring a more stable and reliable data export process.
Connectivity
Driver Proxy Credentials: An issue where cleared driver proxy credentials were still saved has been resolved. This ensures that proxy settings are properly managed.
SSH Connection Testing: Testing an SSH connection with a passphrase now works correctly even if the passphrase was not saved previously.
Security
The high vulnerability (CVE-2026-3505) in the bcpg-jdk18on library has been fixed. The library was updated to version 1.84.0 to address this security concern.
Miscellaneous
SQL Saving: Added the ability to save SQL to a file from the Generate SQL dialog. This can be handy for storing generated SQL scripts for later use.
JetBrains Connection Import: Added the ability to import JetBrains database connections by pasting datasource configuration text directly into the import wizard, providing more flexibility in managing connections.
Practical Impact
For Database Administrators (DBAs)
Improved SQL Editing: The space trimming and transaction mode display fixes in the SQL editor make it easier to write and manage SQL scripts. The correct handling of transaction monitors also helps in better understanding and controlling database transactions.
Enhanced Connectivity: Resolving issues related to proxy credentials and SSH connection testing ensures smoother access to databases, especially in complex network environments.
Security Assurance: The update of the bcpg-jdk18on library to fix the security vulnerability provides peace of mind, knowing that the tool is more secure.
For Developers
Better Data Exploration: Fixed issues in the data editor, such as reference table integrity and custom data type handling, allow for more efficient data exploration and development work.
AI Assistant Improvements: The fixed default temperature value in the AI assistant can potentially provide more useful assistance during the development process, for example, when generating SQL code snippets or getting insights from the database schema.
Upgrade Suggestions
Backup Your Data: Before upgrading, it's always a good idea to backup your existing database connections, scripts, and any important data related to your work in DBeaver.
Check Compatibility: Ensure that the new version is compatible with your operating system and the databases you are working with. Although DBeaver is generally compatible with a wide range of systems and databases, it's best to double-check.
Test Thoroughly: After upgrading, perform comprehensive testing of all the features you use regularly. This includes running SQL queries, data editing, exporting, and connection testing to make sure everything works as expected.
Summary
DBeaver 26.0.4 brings a series of valuable improvements and bug fixes across multiple areas. From enhancing the SQL editor and data exploration capabilities to improving connectivity and security, these updates make DBeaver an even more powerful and reliable tool for working with databases. Whether you're a DBA managing complex database environments or a developer writing SQL code and exploring data, the new features in this version are likely to enhance your productivity. Make sure to follow the upgrade suggestions to smoothly transition to the new version and enjoy the benefits it offers.