• SQL Editor:
  • Tables with foreign keys are now displayed at the top of the autocompletion list
  • Fixed foreign key conditions and join suggestions for subqueries
  • SQL processing settings were redesigned
• AI assistant: added confirmation for executing dangerous AI-generated queries (configurable)
• Data Editor: added the ability to filter values with plus and other special characters in the column data filter
• Navigator: updated filter icons and moved them to the same line as the search bar
• Data Transfer:
  • Added a setting to save SQL logs in Query Manager during data transfer
  • Fixed issue with editing the database name in data transfer wizard
• General:
  • File editor now closes automatically if a folder or file was deleted
  • Issue with unexpected dialogs resize was resolved
• Connectivity: driver version configuration was redesigned
• Miscellaneous:
  • Save/save as icons were redesigned
  • Colors for connection types were changed to less bright
  • Fixed “Show resource in explorer” option in the project context menu
• Databases:
  • Azure Databricks:
    • Fixed default database switching when browsing tables in different databases
    • Fixed an issue where no default database selection
  • Clickhouse: Fixed primitive array editing for all engines
  • CUBRID:
    • Added support for sharded database connections (thanks to @longhaseng52)
    • Fixed incorrect query generation for comments on view columns (thanks to @longhaseng52)
    • Fixed an issue causing duplicate tables in the Navigator (thanks to @longhaseng52)
  • MariaDB/MySQL: reference navigation performance was improved
  • MySQL:
    • “Show all databases” setting was added to the connection page
    • Fixed the ability to copy a user
  • Oracle:
    • Added support for Oracle sequences by autocomplete and semantic analysis in SQL Editor
    • Added a setting to read sequences metadata in Oracle properties (disabled by default)

• SQL Editor:
  • Fixed autocomplete for tables which names conflicts with keywords
  • Fixed WHERE keyword autocompletion
  • Fixed collapse/expand of result tabs
  • CEIL and CEILING are no longer highlighted as keywords
• Data Editor:
  • Fixed the icon for the “Move to Top” action (thanks to @Mattwmaster58)
  • Query text is now displayed near the filter panel when the results are filtered
• Data Transfer:
  • Fixed an issue where an excessively wide window was created during data export
  • Fixed the button order in the export dialog for better consistency and usability
• Navigator: added an indicator to show when entities are filtered using the search bar
• General: if you try to run the application on an unsupported operating system, a notification will inform you that the OS is not supported
• Databases:
  • CUBRID: added a tab that allows users to view the full text of the execution plan
  • Clickhouse:
    • Fixed incorrect representation of nested array values in the Value panel
    • Fixed the ability to edit boolean arrays
  • Databricks: added UserAgentEntry parameter with information about product version
  • LibSQL: connection configuration issue was fixed
  • Oracle:
    • Fixed autocomplete for synonyms in the SQL editor
    • Fixed the ability to add comments via Action tab in Metadata editor

• AI integration is now included in the Community packaging, extension install is not needed anymore
• SQL Editor:
  • Fixed an issue when files modified externally could not be closed without overwriting
  • Schemas/catalogs support in the Generic driver was improved
• Metadata: fixed an issue where virtual keys created via the popup dialog were not saved
• Data Editor: fixed the Copy as CSV option in Advanced Copy
• General: editor tabs now use connection color for visualization
• Connectivity:
  • SSHJ encryption keys support ws improved
  • Issue with network profiles name wrapping was resolved
• Databases:
  • CUBRID:
    • Metadata objects search was fixed (thanks to @longhaseng52)
    • Partition support was enhanced (thanks to @longhaseng52)
    • Added support for PLCSQL (thanks to @hwany7seo)
    • Added support for DONT_REUSE_OID keyword (thanks to @longhaseng52)
  • Clickhouse:
    • Fixed the presentation of tuples and map data types in the data editor
    • Fixed support for temporary tables, all queries to them now run within the same session
  • DD2 driver was downgraded to version 11.5.9 (because of issues with Kerberos authentication)
  • MySQL and Clickhouse: Fixed aliases generation and quotation in SQL Editor
  • SAP HANA: Added support for HALF_VECTOR type (thanks to @fredi-sap)

• SQL Editor:
  • Added variables for virtual column manipulation: row (a map of column names to their values) and table (with name, schema, and container fields)
  • Aliases can now be used in a case-insensitive manner
  • Fixed issue where the selected schema wasn’t recognized after reconnecting
• AI Assistant:
  • Improved GitHub Copilot authorization: the auth token is now displayed during the authorization process and can be copied.
  • GitHub Copilot now displays the up-to-date list of available models.
  • Fixed the AI button not working when the AI extension is installed
  • Hide script ruler when executing queries from AI chat
• Data Editor:
  • Fixed incorrect code generation and saving for Virtual key updates
  • Added an option to show column ordinal position next to the column name in the data grid (thanks @330079598)
• Data Transfer: Improved NVARCHAR mapping accuracy during data import
• Security: Fixed CVE-2023-48795
• Connectivity:
  • Improved UI controls on the connection settings
  • Fixed “–newInstance” option when starting the application via CLI
  • “Change Connection(s) Driver” option is now working again
  • Fixed an issue where newly created connection types couldn’t be deleted
• General:
  • English is now the default language. If a user has never selected a language manually, the UI will switch to English
  • Fixed an issue where UI elements disappeared when using a display scale other than 100%
  • Most icons in the application have been updated to SVG format
  • Based on Eclipse 2025-06. Earlier versions are no longer supported
• Development:
  • JSQL Parser library was updated to version 5.3
  • Fixed the ability to install CE bundles in Eclipse
• Databases:
  • BigQuery:
    • Added BigQuery to the SQL category in the connection dialog
    • Fix column aliases visibility validation
    • column aliases are not available in WHERE but are visible in other SELECT query parts
  • Clickhouse:
    • Fixed identifiers quotation
    • Added support for complex types nested in arrays
  • CUBRID: Fixed VARCHAR length not displaying in Navigator (thanks @longhaseng52)
  • DB2 LUW: Added support for changing expired passwords (not available for databases running in Docker)
  • MySQL:
    • Fixed the ability to create a dump
    • Fixed an exception when opening the partition Virtual tab (thanks to @sogladev)
  • Oracle: Fixed CREATE PROCEDURE statement boundaries detection (thanks @EastLord)
  • PostgreSQL:
    • Fixed misplaced comment in DDL generation
    • Fixed the ability to connect when the port is specified in the URL for PgPass authentication
    • Fixed display issue with time zones when date formatting is enabled
    • Added support for MAINTAIN privilege (thanks @f-m-t-t-m)

• SQL Editor:
  • Added support for column expansion for CTEs
  • Added support for TSQL “TOP” expression
  • Added support for CTE names in sub-queries
  • Disabled SQL autocomplete inside DBeaver SQL commands
  • Fixed an issue where code completion failed in long queries when using column aliases
  • Fixed an issue where most of the output was lost after performing a search
• AI assistant: GitHub Copilot authorization dialog was improved
• Metadata Editor:
  • Added progress visualization for loading items and a message indicating when the list is empty
  • Fixed sorting of objects such as indexes
  • Fixed layout issues when resizing stacked multi-line fields
• Data Editor: fixed cursor positioning after filter auto-completion
• Navigator:
  • Fixed the “Hide” and “Show Only” filter options, added support for filtering by name with arguments
  • Fixed an exception that occurred when deleting an open project
• Connectivity:
  • Fixed an issue where SSL settings were removed after adding an SSH profile
  • Redesigned the DBeaver connection profiles for improved structure and usability
  • After changing an expired database password, you can now immediately test the connection with the new password
• General:
  • Transaction commit/rollback buttons now have drop-down menu which can show queries within this transaction
  • Fixed compact DDL generation for tables
  • Set English as the default language in the Microsoft Store distribution
  • Improved the appearance of several database logos in dark theme
  • Fixed an exception in the Output viewer
• Databases:
  • CUBRID:
    • Added the ability to delete comments on Serial and Views (thanks to @longhaseng52)
    • Fixed an error that occurred when deleting properties and comments on the server (thanks to @longhaseng52)
    • Fixed an error when editing null values in the metadata editor (thanks to @longhaseng52)
    • Fixed an issue where view DDL was truncating UNION ALL statements (thanks to @Srltas)
  • Clickhouse:
    • Fixed the display of nested arrays in the data grid and SQL generation
    • Fixed an issue with folder display in the Navigator when using driver version 8.0.x or higher
    • Fixed data type loading and array editing issues
    • Removed Foreign Keys and References tabs from the Metadata Editor
  • DuckDB: Improved display of structured data type keys in the Data Editor
  • Exasol driver was updated to version to 25.2.3
  • Firebird: Removed “AS” before table alias for legacy Firebird
  • Neo4j was deleted from Community version
  • Oracle: Added column-level privileges to the Privileges view
  • PostgreSQL:
    • Fixed syntax highlighting for the INTERVAL keyword
    • Fixed an issue where database names containing slashes caused a connection error when accessing schemas
  • Salesforce Data Cloud: Now uses the shaded driver version by default (thanks to @jschneidereit)

Changes since 25.0.5:

• SQL Editor:
  • If referenced table has an alias, it’s now always prepended before column name for semantic completion
  • Added a new setting for semantic completion to control fully-qualified column names
  • Fixed bind variables dialog layout for large fonts
• Data Transfer: removed the “All but nulls” and added “All including nulls” option for CSV export
• Miscellaneous:
  • Fixed misaligned editor window in the Bind Parameters dialog for macOS
  • Fixed an issue where the “Tip of the Day” window could block the application interface from loading
  • Fixed inconsistent application of connection colors for test and production connection types
  • Fixed application launch in CLI mode
  • General: The “All file types” option has been moved to the top of the file open dialog for easier access
• Databases:
  • Clickhouse:
    • Clickhouse driver was returned to version 0.8.5
    • Fixed quoting of nested array values
  • CUBRID: Fixed Info panel visibility
  • DuckDB:
    • Added option to hide system objects
    • Fixed geometry display issues in DuckDB version 1.2.2+
    • Simple structure compare wizard was fixed
  • MySQL: fixed primary key column creation
  • PostgreSQL: added support for wildcards in ILIKE filters within the data grid
  • SQL Server: fixed the “Only connections” option in Session Manager to display only active connection sessions as intended
  • Teradata: native date/time formatting is now disabled by default and can be enabled in the connection settings

• SQL Editor:
  • CTE completion and navigation support was significantly improved
  • SQL columns completion was fixed (issue with overlapping names)
  • Added support of STRAIGHT_JOIN and LATERAL JOIN
  • Several navigation shortcuts were fixed to avoid conflicts with European keyboard layouts
• Metadata: Added the ability to resize multiline fields
• Navigator:
  • Added the number of elements in folders (configurable, thanks to @isai-salazar-enc)
  • Fixed an issue that prevented schemas and databases from opening
• Miscellaneous:
  • Added an extra CLI runner: dbeaverc. It respects settings in dbeaver.ini
  • When a user selects the driver version manually, it will no longer be updated automatically
  • Fixed the ability to use application when certain accessibility tools are enabled
• Databases:
  • Clickhouse: Fixed the ability to connect to the version 0.8.5
  • MySQL: Fixed ‘remove definer’ option of backup/restore in a special case
  • Oracle: Set `Use UNION for table metadata reading` preference to true by default
  • PostgreSQL:
    • Fixed foreign servers display when no access to `pg_user_mapping` table
    • Execution hang on a query with a huge json in dollar-quoted strings with tag were fixed
    • Fixed an issue causing hangs when working with large JSON files
    • Allowed unquoted identifiers started with underscore
• New drivers: Added support for Kingbase database (thanks to @Kingbasewyx)

• SQL Editor: Added support for Common Table Expressions (CTE) by semantic analysis and autocompletion
• Data Editor: When an inline editor is active and the user starts typing, the grid now automatically scrolls to the cell being edited to avoid unexpected cell editing
• Connectivity:
  • Added an option to update a driver to a recommended version
  • Fixed an issue with replacing localhost with the IP address when connecting via SSH
• Databases:
  • Clickhouse:
    • Clickhouse driver was update to version 0.8.5
    • Data type display was fixed
  • CUBRID: Added the ability to update user (thanks to @rathana-pvs)
  • GBase 8s: enhanced support for editing unique constraint and CHECK constraint (thanks to @Wintianis)
  • Firebird: Fixed native binary presentation (thanks to @niekschoemaker)
  • PostgreSQL:
    • Added the ability to backup all database schemas (using the Completed backup option) (thanks to @mikiubo)
    • Fixed Foreign data wrappers configurator opening
    • The retrieval of Collation was removed for older PostgreSQL versions (versions earlier than 9.1)
  • Snowflake driver was updated to version 3.23.0
  • SQLite: Added information about a table’s Strict mode to the Table Metadata section (thanks to @eusebe-cda)
  • TDengine driver was updated to the latest version (thanks to @DuanKuanJun)

• Data Editor:
  • Added the ability to sort data by the primary key (Preferences
  • Editors
  • Data Editor
  • Default ordering)
  • Fixed data types coloring for foreign and primary keys
• SQL Editor:
  • Fixed the single quotes handling
  • Fixed SELECT .. FOR UPDATE queries execution (thanks to @f-m-t-t-m)
• AI assistant: Users on macOS now can send messages to AI assistant window with Enter and to AI Chat with Cmd + Enter (need AI extension installed)
• Navigator: Ascending table sorting was fixed
• Connectivity: Fixed an issue when credentials in the Test connection overwrite credentials of the previously created connection
• Miscellaneous:
  • Migrated to Eclipse 2025-03
  • Updated Light theme
  • Windows appeared at app start were reordered to improve user experience
• Databases:
  • Apache Cloudberry: Fixed fetching server version (thanks to @yjhjstz)
  • Dameng: Added support for unique and check constraints (thanks to @Stkai)
  • Cassandra: Fixed the string filtering
  • Clickhouse: Fixed the connection to the new driver version 0.8.2
  • MariaDB: Fixed the ability to create backup. Now it is performed with the mariadb-dump
  • PostgreSQL:
    • Fixed changing auto-increment sequence parameters (thanks to @f-m-t-t-m)
    • Fixed updating arrays via Value panel (thanks to @f-m-t-t-m)
    • Fixed the ability to connect to the database when executing a query
    • Fixed typo in the description of “Replace legacy timezone” setting in the New PostgreSQL connection wizard (thanks to @vintas)

• Navigator:
  • Filter behavior has been improved for a better user experience
  • Fixed filters for secondary DBeaver app windows
• SQL Editor:
  • Query cancellation after retry was fixed
  • When the “Blank Line is Statement Delimiter” option is set to Smart, blank lines are now correctly recognized as script delimiters while executing queries as Script
  • Fixed missing space after the leading keyword in some cases
• Miscellaneous:
  • Added an option to display the breadcrumbs in either the status bar or at the top of editors
  • Breadcrumbs now occupy less horizontal space in the status bar
  • Added the DBeaver icon to aarch64-linux package (thanks to @chirontt)
• New Drivers: Added support for Teiid database (thanks to @edulauer)
• Databases:
  • CUBRID:
    • Added statistics and trace information to the result tab (thanks to @rathana-pvs)
    • Fixed incorrect script generation when creating a trigger via UI (thanks to @longhaseng52)
  • Denodo: the connection name was modified to Denodo (thanks to @dlopezc-denodo)
  • GBase 8s: fixed creation of a table with a primary key (thanks to @Wintianis)
  • MariaDB: after changing an expired database password, you can now immediately test the connection with the new password
  • MariaDB/MySQL: fixed creation of auto_increment columns with primary key
  • Oracle: fixed view creation via Metadata editor
  • Sap Hana: fixed an issue with name editing when creating a table in Metadata Editor
  • Snowflake: fixed metadata queries for driver versions 3.13.20 and higher (thanks to @smheaton)
  • Teradata: fixed an exception that occurred during code completion