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

• SQL Editor:
  • Fixed a bug in single-tab mode where script execution displayed results from the previous execution
  • Fixed the sql formatting for procedure calls with multiple argument
  • Improved buttons layout in result set view on execution error
  • Auto-refresh is now stopped if the result is not visible or DBeaver window is collapsed
  • SQL autocompletion: Fixed the ability to expand columns for table_alias.*
  • Added the ability to use the “Short object names” code completion option for columns
  • Command parameters now always highlighted with black
• AI assistant: Fixed an issue where a query without a semicolon before @ai was skipped without an error message. Query will be executed even if there is no semicolon
• Metadata Editor:
  • Added the ability to view and edit comments in a popup window for improved user convenience
  • Fixed an issue where folder content in the Metadata Editor was not displayed immediately after opening an object
• Data Editor: Removed options for copying column names and row numbers from the context menu for data cells
• Diagram:
  • Updated the scrollbar color in the Diagram to match the expected design
• Connectivity: Resolved the issue related to font rendering in the connection creation window
• Security: Added the ability to enable TLS/SSL debug logging
• Miscellaneous:
  • Breadcrumbs now update immediately when any included object is renamed
  • Popups for version update, Tip of the Day, and Sample Database are now displayed later if other modal windows are open, improving the user experience and reducing interruptions
  • Fixed the Open File dialog issue on Linux
• Databases:
  • Azure SQL Server: The “CREATE VIEW” statement has been replaced with “CREATE OR ALTER VIEW” in the view DDL for Azure SQL Server v16 and higher
  • ClickHouse: Fixed issue with reading geometry data
  • CUBRID:
    • New column creation was fixed (thanks to @longhaseng52)
    • Added the ability to create and modify synonyms (thanks to @longhaseng52)
  • Databend: Fixed an issue with changing catalog names containing special characters (thanks to @rad-pat)
  • GBase 8s: Added the ability to edit table and column comments (thanks to @Wintianis)
  • Oceanbase: Diagram display was fixed
  • Oracle global variables such as SYSDATE and UID are now supported in query validation
  • PostgreSQL: Fixed an issue where selecting “Exclude auto-generated columns” excluded only identity columns but not other auto-generated columns (thanks to @f-m-t-t-m)
  • PostgreSQL:
    • Fixed an issue where the “Show partitions” option was hiding permissions in the DDL view (thanks to @f-m-t-t-m)
    • Added the ability to cancel queries in the Session manager (thanks to @mikiubo)
    • Fixed the display of the back slash symbol in comment blocks after refresh
  • SQLite: BLOB display was improved (thanks to @eusebe-cda)
  • SQL Server: Fixed table hints parsing
  • Yellowbrick: Added support for geospatial data

Changes since 24.3.5:

• Data Editor:
  • Added a suggestion to check spatial column visibility when enabling the spatial view
  • Data cells search algorithm fixed (find/replace)
• SQL Editor:
  • The schema selector is now hidden when it is not applicable to the current connection
  • @include command execution was fixed
  • Transaction mode refresh on script database change was fixed
  • Improved performance of reading data in the SQL console
  • Changed default shortcuts for the Result set zoom to Alt+0 and Alt+9 (to avoid conflicts with European layouts)
  • Proposal sorting in code completion was improved: joins are always on the top
  • Joins auto-completion was improved
• AI Assistant: Fixed excessive AI requests when AI is disabled (in the extension)
• Diagrams:
  • Table comments and fully qualified names visiblity was fixed
  • “ER Diagram” tab was renamed to “Diagram”
• Metadata Editor: columns and other objects reordering was fixed
• Navigator: schema indexes and triggers are now sorted in ascending order
• Connectivity: fixed an issue where the connection name was replaced with “localhost”
• Data transfer:
  • Connection recovery was fixed for stuck data transfer jobs
  • CSV export: array formatting was fixed
• Miscellaneous:
  • SQLite database files can be opened directly from OS file explorer (MacOS and Windows) or with CTRL+O shortcut
  • Splash screens were updated
  • Monospace font is now used for HEX, JSON, XML, and other content editors
  • All app settings are reset when the Reset Settings option is selected during installation
  • Blurry application icon in Windows was improved
  • Windows Store application configuration was fixed
  • Fixed issue with saving timezone in Preferences
• Databases:
  • Jennifer driver was updated to version v5.5.3.2
  • MySQL: Fixed an issue with restricted access for users without SHOW DATABASES permission
  • MariaDB:
    • Added the ability to change expired password
    • MariaDB driver was updated to version 3.5.2
  • MySQL: issue with duplicated check constraints was fixed
  • Oracle: Fixed index declaration in Oracle 23.1.0
  • PostgreSQL:
    • Added the ability to replace legacy timezone (on connection dialog)
    • Fixed transaction mode changing after the connection reopen
    • Fixed an issue with display database size after the connection refresh (thanks to @f-m-t-t-m)
    • Added the ability to change the storage strategy (PLAIN , EXTERNAL , EXTENDED) for a column (thanks to @eusebe-cda)
  • Redshift: query performance and stability was significantly improved
  • Snappy driver was updated to version 2.11-1.3.0
• Localization: Fixed typo in Russian localization (thanks to @mikiubo)

• SQL Editor:
  • Added the ability to use multi-line variables in SQL scripts
  • New autocompletion engine was improved and enabled by default:
    • Autocomplete performance was significantly improved
    • Fixed an issue with autocomplete failure after the dot
    • Fixed autocomplete for JOIN conditions
    • Fixed an issue with not executed included scripts
    • Fixed alias case sensitivity in autocomplete
    • Changed an icon for derived column in autocompletion proposals
• ER Diagram: added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
• Query Manager: query duration formatting was fixed
• Data Editor:
  • Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
  • Fixed row coloring when querying multiple tables
• Data transfer: removed the ability to change data type for existing columns in Data Export
• Database Navigator: database object filter was improved. Connection filter is enabled by default
• Miscellaneous:
  • We migrated to the Java 21
  • Added the ability to associate different file types with DBeaver on Windows and macOS
  • Bookmark vew is now working again
  • Font in error messages was changed to monospace
  • Commit/Rollback monitor was fixed
  • Fixed bold font display for theming on macOS
• Databases:
  • Azure Databricks: information_schema was added to Database Navigator
  • Databend: icons were updated
  • CUBRID:
    • Fixed index creation preview
    • Fixed column creation with STRING and similar data types
    • Procedure, function, and view names are now displayed in lowercase
    • Added the ability to change comment for foreign key columns
  • LibSQL: UI for token-based authentication was added
  • Machbase: driver was updated to version 8.0.2
  • MySQL/MariaDB: explain plan now works for all types of SQL queries
  • Oracle:
    • Fixed DDL generation for table spaces
    • Fixed user password changing
  • PostgreSQL: fixed an issue with disappearing ENUM definition after the refresh in Metadata editor
  • Salesforce Data Cloud:
    • Removed the ability of edit database metadata
    • The latest driver version is now downloaded by default
  • SAP HANA: partition view was added
  • SQLite: STRICT mode support was added
  • SQL Server:
    • Index creation was fixed
    • Fixed an issue where the index type couldn’t be changed to unique
  • Teradata:
    • XML column value save was fixed
    • Removed incorrect warning message after executing SHOW and similar queries

• SQL Editor:
  • Added the ability to use multi-line variables in SQL scripts
  • New autocompletion engine was improved and enabled by default:
    • Autocomplete performance was significantly improved
    • Fixed an issue with autocomplete failure after the dot
    • Fixed autocomplete for JOIN conditions
    • Fixed an issue with not executed included scripts
    • Fixed alias case sensitivity in autocomplete
    • Changed an icon for derived column in autocompletion proposals
  • ER Diagram: added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
  • Query Manager: query duration formatting was fixed
  • Data Editor:
    • Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
    • Fixed row coloring when querying multiple tables
  • Data transfer: removed the ability to change data type for existing columns in Data Export
  • Database Navigator: database object filter was improved. Connection filter is enabled by default
  • Miscellaneous:
    • We migrated to the Java 21
    • Added the ability to associate different file types with DBeaver on Windows and macOS
    • Bookmark vew is now working again
    • Font in error messages was changed to monospace
    • Commit/Rollback monitor was fixed
    • Fixed bold font display for theming on macOS
  • Databases:
    • Azure Databricks: information_schema was added to Database Navigator
    • Databend: icons were updated
    • CUBRID:
      • Fixed index creation preview
      • Fixed column creation with STRING and similar data types
      • Procedure, function, and view names are now displayed in lowercase
      • Added the ability to change comment for foreign key columns
    • LibSQL: UI for token-based authentication was added
    • Machbase: driver was updated to version 8.0.2
    • MySQL/MariaDB: explain plan now works for all types of SQL queries
    • Oracle:
      • Fixed DDL generation for table spaces
      • Fixed user password changing
    • PostgreSQL: fixed an issue with disappearing ENUM definition after the refresh in Metadata editor
    • Salesforce Data Cloud:
      • Removed the ability of edit database metadata
      • The latest driver version is now downloaded by default
    • SAP HANA: partition view was added
    • SQLite: STRICT mode support was added
    • SQL Server:
      • Index creation was fixed
      • Fixed an issue where the index type couldn’t be changed to unique
    • Teradata:
      • XML column value save was fixed
      • Removed incorrect warning message after executing SHOW and similar queries
  Tweet

• SQL Editor:
  • Added support for SELECT INTO query smart completion
  • Changed shortcuts for result set zoom: Ctrl+Aalt+0 and Ctrl+Alt+9
  • Fixed the order of completion suggestions in the proposals list
  • New completion engine:
    • Fixed a bug with duplicating alias part during column completion
    • Fixed autocomplete for join conditions when multiple joins are present
    • Proposals list now contains only objects from the next hierarchy level
    • Fixed autocompletion for SELECT statements with table hints for SQL Server
  • Fixed the issue where the old result set tab didn’t close when switching between multiple and single tab modes
  • Fixed a stack overflow error that occurred when a user tried to execute a script for an open result set with row coloring
  • When an error occurs, the last executed query is now displayed next to the error message
  • Fixed an exception that appeared while typing
• AI assistant: Fixed syntax issues in queries generated by Azure Open AI
• Data Editor:
  • Added hints for geometries with SRID and for timestamps with time zones
  • Added the ability to configure hint visibility for a table or a datasource
  • Hints presentation was enhanced
  • Added backslash escaping when generating scripts
  • Added an option to disable the dictionary view (set “Maximum amount of elements” to 0)
  • Fixed freezing issues when pasting big number of rows or when performing find/replace
  • Added an option to save XML and JSON files in compressed format
  • Fixed data editor filters for commoт table expressions
• Miscellaneous: Added the ability to create bookmarks from the context menu of object tabs
• Databases:
  • Cloudberry driver was added
  • CUBRID: Fixed view name generation in DDL (thanks to @longhaseng52)
  • MySQL:
    • USAGE privilege is now hidden if any other privilege has been granted
    • Fixed loading of DBA privileges
  • PostgreSQL: Fixed the display of infinity for date values