SQL Editor: improved performance when executing multiple SQL queries simultaneously
AI Assistant: the temperature setting is disabled for models that do not support it
Data Editor: “Calculate row count automatically” was enabled by default and applies only to SELECT queries
Data Transfer: resolved an issue with an oversized data transfer window
Miscellaneous:
Auto-commit settings were redesigned
Redesigned visual page structure in Preferences and some dialogs
Resolved an issue with incorrect transaction mode display
Restored the splash screen on macOS
Databases:
ClickHouse: fixed broken spatial data presentation
Sybase: fixed table opening via double-click in the Navigator
DuckDB: added support for the dollar-quoted string syntax
Redshift:
Materialized views are displayed as system tables with a special icon
Fixed multiple issues related to permissions, incorrect empty table display, and the data import wizard
Netezza: added the ability to search metadata objects by definitions
Data Editor: Fixed value change cancellation
Search: Fixed text input for Chinese, Japanese, and other similar languages on macOS
Data transfer: Removed a warning from the logs that appeared during CSV import
Miscellaneous:
Linux Debian package was fixed
Snap:
Packaging switched to classic mode
Issues with web browser activation were resolved
Issues with Office integration were resolved
Problem with DuckDB embedded driver connection was fixed
Databases:
MySQL: Fixed database dump when SSH is enabled
ClickHouse:
Driver version was updated to version 0.9.5
JSON data type reading was fixed
Issue with CTE expressions was resolved
Active database selector was fixed
Issue with LIMIT clause and read-only connections was resolved
Big numbers rendering was fixed
Tuple data types rendering was fixed
A number of issues with array data types fetch/render was fixed
SQL Editor:
New script numbering algorithm was improved
Bug in Find/Replace panel and Ctrl+Enter shortcut was resolved
Dangerous query confirmation now shown for any DROP statements
Query confirmation message was fixed
Data Editor:
Ordering of rows by primary key feature was redesigned and now works only in tables
Issue with virtual keys and “use all columns as key” option was resolved
Issue with tooltips for JSON columns was resolved
Value change cancellation was fixed
Data export in DbUnit format was fixed (issue with escaping)
Data import wizard now show file selector automatically
Issue with incorrect detection of read-only columns was resolved
Miscellaneous:
Driver download dialog was fixed (issue with wrong focus and details panel)
New connection name generator was improved
Connection configuration import from pgAdmin was added
Internal connection information page was added to the connection edit dialog
Check-buttons and radio-buttons rendering was fixed on Linux
Warning related to custom driver icons were removed
Option “Open separate connection for metadata reads” save was fixed
pt_BR localization was fixed (thanks to @imoliveira88)
Databases:
Azure SQL Server: active database detection was fixed
CUBRID: (thanks to @longhaseng52)
Issue with duplicated primary key columns was fixed
SQL query execution plan layout was fixed
Shards support was added
Denodo: driver version was updated to 9.0 (thanks to @dlopezc-denodo)
TDengine: non-latin encodings support was improved (thanks to @DuanKuanJun)
Microsoft Fabric:
Stored procedures body reading was fixed
Extended properties reading was fixed
MySQL: table column DDL generator was added (thanks to @mikiubo)
Oracle:
issue with active user name detect was fixed (thanks to @alexeyleping)
GRANT statements were fixed in object’s DDL
PostgreSQL:
Login event triggers support was added (thanks to @Morgunov-Vitaly)
SSPI authentication was fixed
Issue with redundant change of “search_path” variable was resolved
Issue with wrong native binary for database restore was resolved
Redshift: materialized views read was fixed
Changes since 25.2.5:
SQL Editor:
Fixed the ability to select multiple rows on macOS
Fixed an issue with the unavailable script execution button
Data Editor: fixed incorrect behavior when applying filters with extra conditions
Metadata editor:
Fixed an issue with duplicate unique index create statement when generating DDL
Table size presentation was fixed
Navigator: fixed an issue when filters didn’t work in a new DBeaver window (thanks to @klassik86)
Query Manager: execution time is now always displayed in milliseconds
Data transfer: fixed an issue when the application freezes during the export of a large number of tables
Task Management: added a loading progress indicator for the task view
Security: fixed a security issue in the Spatial Viewer for the HTML content to prevent a third-party script execution
Miscellaneous: added the application installer for Windows ARM (beta version)
Databases:
CUBRID: Fixed an issue with the column list duplicates with reused foreign key names (thanks to @longhaseng52)
H2GIS: Driver version downgraded to 2.2.1 due to a driver error
Oracle: Fixed REFCURSOR fetching
Redshift driver configuration was fixed
Yellowbrick:
The driver was changed to the native Yellowbrick driver
Added support the OAuth2 authentication
Data Editor:
Icons for data edit commands were updated
Data loading progress messages now show more details
SQL Editor:
Resolved the issue with performance lag during long scripts scrolling
`@include` command processing was improved
Error processing in nested scripts was fixed
`CTRL+Enter` shortcut was fixed in Find/Replace panel
AI: OpenAI legacy API support was added
Miscellaneous:
Opening of sql files by using command line of file explorer was fixed
Potential security breach was resolved in GIS map viewer
Splash screen is now disabled on MacOS
Data transfer:
“Write to the single file” option was fixed
Input file selector UI now allows file name copy/edit
Databases:
Apache Derby: driver version was updated to 10.17.1.0
Athena: driver version was updated to 3.6.0
BigQuery: driver version was updated to 42_1.6.3
Clickhouse: query canceling support was added
Databricks: OSS driver configuration was fixed
PostgreSQL: GIS data types support was fixed
Redshift:
Driver version was updated to 2.2.0
Issues with network disconnects were resolved for all Redshift driver versions
Snowflake: driver version was updated to 3.27.0
SQL Server: driver version was updated to 13.2.1
Sybase/SAP ASE: issue with stored procedures body reading was resolved
Data Editor:
The default shortcut for Advanced Copy with previous settings on macOS was changed to CTRL+SHIFT+4
Added the option to disable numeric identifier columns formatting
SQL Editor: Added support for temporary tables in semantic analysis
AI assistant: added the confirmation for query types that DBeaver cannot recognize as valid SQL
Data Transfer: Added connection and database info to backup/restore wizards
Connectivity: fixed an issue that prevented deleting network profiles
Miscellaneous:
Fixed a crash on Windows that occurred when the username contained non-ASCII characters
Fixed an issue where notifications stole focus when the user was in another application
Added the ability to import connections from DataGrip
Databases:
ClickHouse: Improved array data types display in the Data Editor
DuckDB: Fixed an issue when the catalog selection was lost upon disconnect
Oracle: Privileges tab now opens for non-admin users
SQLite: Fixed an issue where foreign keys created with shorthand syntax were not recognized as references
Snowflake: Procedures with multiple versions are now displayed correctly
AI assistant:
Added the ability to test AI configuration in Preferences
Fixed bug in AI command which lead to an error whenever a query contained a trailing delimiter
Data Editor:
Removed the default shortcut for Select Row Count (Ctrl+Alt+Shift+C) due to a conflict with the Advanced Copy shortcut
Fixed an issue when the boolean inline editor was read-only in tables without a primary key
Metadata Editor:
Updated the UI for object comments editing
Removed object name comments duplicate in view DDL
Navigator:
Added an option for case-insensitive alphabetical sorting
Fixed an issues with tree inconsistency after disconnect
Fixed an issue with table list reading in certain drivers (Databricks, Sybase and others)
Connectivity:
Fixed an issue that prevented deleting an SSH jump server in connection settings
Network profile settings are now easier to find in Preferences
General:
Fixed an issue when it was impossible to set the result set fetch size to 0
Improved panel and result set maximize behavior
Fixed a startup issue in the Snap version related to the NO_AT_BRIDGE variable
Driver download window was redesigned
Databases:
Athena driver updated to version 2.2.2.1000
Google Cloud Spanner driver was updated to version 2.33.1
Greengage: Added database icon (thanks to @tigrulya-exe)
SQL Editor:
Fixed an issue where the wrong ID was selected after a join operation
Improved behavior of the progress control
AI assistant: Fixed an issue when model names case
Metadata: Fixed an issue with object editor resize
Data Editor:
Panel context menu was redesigned
Improved filter visuals and layout: unified background color, fixed separator line, and merged two panel toolbars into one
Data Transfer: Fixed column casing issues when importing from XML
General:
Added the ability to configure the “Show all databases” property via CLI
Fixed truncated labels in Preferences on Linux
Fixed broken colors in Dark theme after Eclipse update
Unified the appearance of toolbar separators
Improved color-coding for Test connections
Set NO_AT_BRIDGE=1 for Linux applications
Clarified error message when a driver is unavailable
Databases:
ClickHouse: Fixed several bugs related to incorrect type handling, including array, tuple presentation, and nested column presentation (thanks to @Hubbitus)
CUBRID: Fixed some issues on full text query plan (thanks to @longhaseng52)
MySQL: Added “Compress” flag in the dump wizard (thanks to @mikiubo)
PostgreSQL: Creating a database with “Show all databases” disabled now shows an error
Redshift:
Fixed an issue that prevented updating the driver
Jobs and system databases are now hidden in the Navigator
Snowflake: Driver updated to version 3.24.0
SQLite: Fixed “Cannot determine target node for File” error
Localization: Spanish localization was improved (thanks to @anton-erofeev)
SQL Editor:
Result grid minimizing now works correctly
Fixed an issue when alias names were duplicated in join table completion
Fixed an issue when the selected schema in new scripts reset on reconnect
Autocomplete proposals are no longer shown for values inside quotes
Fixed recognition of pseudo columns in semantic analysis
Improved parsing and execution of multiple queries
Restricted the generation of aliases that match SQL keywords
AI Assistant:
No-query AI command responses are now shown in the Output tab
Fixed the ability to disable AI integration in the Community version
Data Editor: Fixed dictionary lookup for composite foreign keys to show only distinct values in the Value pane
Metadata Editor: Redesigned panel with reduced empty space and improved field layout
Data transfer:
Added the option “Ignore characters outside quotes” when importing from CSV
Added BIGINT support and numeric type widening during data import
Dashboards: Corrected the date format displayed in tooltips
Connectivity: Added support for connecting via JDBC URLs with custom protocol parts, such as “jdbc:mysql:loadbalance”
General:
General: CLI commands now return valuable proccess exit codes that indicate the execution result
Fixed an issue when connection color was incorrectly applied to result sets in text format
Improved the appearance of disabled checkboxes in dark theme
All tabs for the same Production or Test connection are now color-coded for easier identification
New driver: Added support for Greengage Database (thanks to @VitekArkhipov)
Databases:
Athena: Fixed identifier naming rules for the Athena dialect
CUBRID:
Fixed DDL generation for tables with multi-column keys (thanks to @longhaseng52)
Fixed an issue when a newly created table would disappear from the schema after a refresh (thanks to @longhaseng52)
Databricks:
Renamed the driver to Databricks
Added host and URL selectors to the connection page
Added Databricks OSS driver version
Ingres: Fixed driver download (thanks to @clach04)
Kingbase: Fixed unsupported vector type com.kingbase8.util.KBobject (thanks to @Kingbasewyx)
MariaDB: Fixed node costs on Execution plan (thanks to @fergonzr)
Oracle: Fixed an issue where user metadata information was not displayed unless ‘Always use DBA_ views’ was selected
PostgreSQL:
Fixed filtering issues for composite types with identical column names (thanks to @mikiubo)
Added support for hash indexes in the Metadata Editor (thanks to @mikiubo)
Redshift: Fixed incorrect DDL generation for materialized views
Localization: German translation was improved (thanks to @hendrik-r)
Changes since 25.1.5:
AI Assistant:
Added query preview to the @ai command and AI chat query confirmation
Added support of a custom OpenAI API base URL (thanks to @p12tic)
Improved query analysis performance
SQL Editor:
Issues with slow auto-completion of schemas/tables was resolved
Context information (F2) was fixed and noe works without text selection
Fixed issue with query re-parsing at the very end of the script
Fixed aliases completion when dialect doesn’t support them
Fixed issue with scrolling after script formatting
Data Editor:
Fixed advanced paste for tables without a key (thanks to @mikiubo)
Fixed value display issue when switching to a record via foreign key
ER Diagram: fixed incorrect key highlighting for tables with self-referencing columns
Data transfer: icons for export and import providers were improved
Connectivity: fixed scroll display in Connection settings
General:
Updated coloring for test and production connection types, as well as in Query Manager
Fixed inconsistent font changes when running DBeaver as an Eclipse plugin
Toolbar colorization in the dark theme was improved
Fixed background rendering issues in Dark Theme
The timezone name in the status bar now reflects daylight saving time
New driver: Added support for TimechoDB/IoTDB (thanks to @LJW21-02)
Databases:
ClickHouse:
Maps are now displayed as strings in the Data Editor
Fixed connection issues for read-only users
CUBRID:
Corrected label name for Views in the Metadata Editor (thanks to @longhaseng52)
Added support for AUTO_INCREMENT on SMALLINT and NUMERIC(x,0) column types (thanks to @longhaseng52)
MySQL: improved performance of foreign key and references reading
Oracle:
Column copy was improved
Issue with public synonyms loading was fixed
New optimizer preference was added to the connection settings
Snowflake: added support for SHOW, GRAN, and TRUNCATE keywords
SQL Server: fixed data mapping issue during export
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Read more Privacy & Cookies Policy