Releases: dbeaver/dbeaver
Releases · dbeaver/dbeaver
25.2.0
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
- 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
- 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
- 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
- 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
- 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
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
- 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
- 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
- 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)