Skip to content

Releases: dbeaver/dbeaver

25.2.0

31 Aug 17:15
Compare
Choose a tag to compare
            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

25.1.5

17 Aug 15:01
Compare
Choose a tag to compare
            - 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)

25.1.4

03 Aug 15:47
Compare
Choose a tag to compare
            - 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

25.1.3

20 Jul 15:48
6710c9b
Compare
Choose a tag to compare
            - 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)

25.1.2

06 Jul 15:06
Compare
Choose a tag to compare
            - 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)

25.1.1

22 Jun 16:14
Compare
Choose a tag to compare
            - 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)

25.1.0

01 Jun 17:38
Compare
Choose a tag to compare
            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

25.0.5

18 May 18:17
Compare
Choose a tag to compare
            - 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)

25.0.4

04 May 17:51
c962c0b
Compare
Choose a tag to compare
            - 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)

25.0.3

20 Apr 19:01
487234c
Compare
Choose a tag to compare
            - 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)