DBeaver 25.1.1

  • 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)
Posted in Releases

DBeaver 25.1

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
Posted in Releases

DBeaver 25.0.5

  • 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)
Posted in Releases

DBeaver 25.0.4

  • 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)
Posted in Releases

DBeaver 25.0.3

  • 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)
Posted in Releases

DBeaver 25.0.2

  • 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
Posted in Releases

DBeaver 25.0.1

  • 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
Posted in Releases

DBeaver 25.0

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)
Posted in Releases

DBeaver 24.3.5

  • 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
Posted in Releases

DBeaver 24.3.4

  • 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
Posted in Releases