• SQL Editor:
  • Added options to trim leading or trailing spaces in the selected text or the whole script (thanks to @seroperson)
  • Resolved an issue with incorrect transaction mode display
  • Fixed an issue where the transaction monitor showed “N/A” after the toolbar was changed with drag-and-drop (thanks to @xingxing21)
  • Fixed an issue where the “Open a separate connection for each editor” preference was not saved (thanks to @xingxing21)
  • Fixed the DROP confirmation dialog layout for long SQL queries (thanks to @EastLord)
• AI assistant: Fixed the default temperature value for different AI engines
• Data Editor:
  • Fixed an issue where reference tables became empty when fetching the next page in the References panel
  • Added an option to show column data type names in column headers (disabled by default) (thanks to @seroperson)
  • Fixed an exception when expanding a custom data type value in Record mode
• Data Export: Fixed object list resizing in the Export/Dump window (thanks to @EastLord)
• Connectivity:
  • Fixed an issue where cleared driver proxy credentials were still saved (thanks to @EastLord)
  • Fixed an issue where testing an SSH connection with a passphrase failed if the passphrase was not saved
• Security: Fixed the high vulnerability (CVE-2026-3505) in the bcpg-jdk18on library. The library was updated to version 1.84.0
• Miscellaneous:
  • Added the ability to save SQL to a file from the Generate SQL dialog
  • Added the ability to import JetBrains database connections by pasting datasource configuration text directly into the import wizard (thanks to @EastLord)
  • Fixed an issue where the splash screen was flipped on macOS 14.x.
• Databases:
  • Athena: Added type casting for date values in data filters
  • BigQuery: Added a new driver BigQuery (Experimental)
  • ClickHouse: Fixed SQL Editor recognition for existing tables with uppercase letters in their names
  • Denodo: Added support for custom data types and fixed column names for nested arrays
  • DuckDB: Fixed map rendering for GEOMETRY types with CRS parameters (thanks to @EastLord)
  • Firebird: Expanded database-specific SQL dialect coverage for the SQL Editor. Added more keywords, built-in functions, and SQL generators (thanks to @fdcastel)
  • Greenplum/Cloudberry: Fixed external table recognition in the Database Navigator (thanks to @talmacschen-arch)
  • MySQL: Fixed query boundaries recognition in the SQL Editor for scripts with the DELIMITER keyword (thanks to @HellAmbro)
  • PostgreSQL:
    • Fixed debug configuration dialog layout and datasource saving
    • Fixed DDL generation for VIRTUAL generated columns (thanks to @EastLord)
  • SAP HANA: Added the ability to reset the license during connection when the database is in license-only mode (thanks to @kc1r74p)
  • SQL Server:
    • Fixed DDL generation for external tables
    • Fixed row limiting for table-valued function queries (thanks to @xingxing21)
  • StarRocks: Fixed ADD COLUMN DDL generation (thanks to @EastLord)
• Localization: Localization: Improved Chinese localization (thanks to @EastLord)

• Data Editor:
  • Added keywords autocompletion for partially typed
  • Added the source table name to column header tooltips for query results with JOIN (thanks to @bittoby)
  • Fixed an issue where the row count calculation icon did not reset after counting (thanks to @HellAmbro)
  • Fixed the display of spatial data when multiple columns were selected
  • Fixed the ability to calculate row count for non-standard SELECT statements (thanks to @fdcastel)
• Navigator:
  • Added a key binding to focus the Database Navigator filter (thanks to @EastLord)
• ER Diagram: Added preference option to load lazy comments in diagrams (thanks to @jhjalison01)
• Data Export:
  • Fixed export in SQL format for values containing single quotes (thanks to @dev-miro26)
  • Fixed a corrupted UI area during the Extraction step in Export
• Connectivity:
  • Added the ability to set Navigator filters in connection settings
  • Fixed an issue with filtering for embedded databases
• Miscellaneous: Fixed an issue with an inverted splash screen on macOS Tahoe
• Databases:
  • ClickHouse: Fixed the display of Array(JSON) types in the data grid (thanks to @EastLord)
  • CUBRID:
    • Fixed a CSV export error caused by a missing child object (thanks to @longhaseng52)
    • Fixed a binding failure in PreparedStatement for table names containing single quotes (thanks to @longhaseng52)
    • Fixed incorrect partitioning DDL generation for values containing commas (thanks to @longhaseng52)
  • Databricks: Added a logo and fixed the link on the connection page
  • H2GIS driver was updated to the latest version
  • MySQL: Fixed an issue when the Dump database tool did not work with URL-based connections (thanks to @mango766)
  • MySQL/MariaDB: Fixed an issue when changing an auto-increment value generated an incorrect query on the first attempt
  • Oracle: Fixed an issue in the Metadata Editor when clicking a procedure moved the cursor to a comment containing the procedure name instead of the procedure itself
  • Redshift: Set the client_protocol_version driver property to default, which fixed an issue with the availability of external schemas
  • SQL Server:
    • Fixed an issue where user-defined data types based on NVARCHAR were shown with double length (thanks to @EastLord)
    • Removed redundant spaces between CREATE and PROCEDURE in the procedure view
    • Fixed an issue that prevented creating a view in the Metadata Editor

• Navigator:
  • Fixed Copy/Paste for active connections
  • Returned the ability to show/hide system objects in Simple view mode
• Data Editor: Fixed “Access blocked” error in Spatial Viewer when loading OpenStreetMap
• Miscellaneous:
  • Fixed an issue where Git and Proxy settings could break the workspace path
  • Fixed -con attribute handling when starting the application from the command line
• Databases:
  • Athena: Default driver was updated to AWS Athena JDBC driver. The previous driver is still available as Athena (Legacy)
  • ClickHouse: Fixed an issue where the database failed due to unknown driver parameters
  • DuckDB: Fixed geometry type display for database versions > 1.5 (thanks to @EastLord)
  • MariaDB: Fixed an issue when zero dates were displayed as NULL (thanks to @EastLord)
  • MySQL:
    • Added MANUAL to the keyword list (thanks to @EastLord)
    • Fixed user management
  • Oracle:
    • Fixed an issue where the default schema was not selected automatically
    • Restored navigation from procedure to the corresponding package body code line
  • SQL Server:
    • SQL Server driver was updated to version 13.4.0 (thanks to @EastLord)
    • Added warning about expired password (thanks to @bittoby)

• SQL Editor:
  • Queries cancelled by users are no longer marked as invalid
  • Fixed layout issue when the first few rows of text were not visible
• Grouping panel:
  • Percent function now shows 2 significant digits
  • Added the ability to reorder grouping columns
• Metadata Editor: Fixed hash code display when the table name is empty (thanks to @dahyeong-yun)
• Data Transfer: the Proceed button is now enabled earlier, on every page that is properly filled
• Query Manager became accessible even if the database password is lost
• Connectivity:
  • Added connection name and background color to the Ctrl+E editor switcher dropdown (thanks to @bittoby)
  • Fixed an issue when changes in connection parameters were not applied correctly
• Miscellaneous:
  • Added an option to disable automatic connection attachment to scripts
  • Made simple/advanced mode switcher more visible
  • We migrated to Eclipse 2026-03
• Databases:
  • ClickHouse: fixed IP address display by removing the leading slash
  • CUBRID:
    • Default generated key names are now lowercase (thanks to @longhaseng52)
    • Fixed issues with trigger display in the Navigator and DDL generation (thanks to @longhaseng52)
  • GaussDB Driver: fixed connection issues and errors when viewing constraints and foreign keys in M-Compatibility databases (thanks to @MuStevenic)
  • InterSystems IRIS driver was updated to version 3.10.5 (thanks to @bdeboe)
  • MySQL: fixed an issue where views appeared in the list even when the “Show views” option was disabled
  • Oracle: improved viewing of packaged procedures. You can open a specific procedure directly instead of entire package
  • PostgreSQL: fixed an error when connecting via URL if the database name contains a hyphen (thanks to @Ajaz10)
  • Vertica: fixed column order in the Metadata Editor to match the actual table structure (thanks to @darkag)

Changes since 25.3.5:

• AI assistant: added the ability to filter database objects in AI scope settings
• Data Editor:
  • Fixed an issue where adding a new row in record mode inserted an existing row instead of creating a new empty one
  • Fixed incorrect DDL generation for tables without keys
  • Fixed a bug where a new column could be replaced with the percent column after it had been enabled and then disabled
• ER Diagram: Fixed an issue where table names were truncated after saving in PNG format
• Task Management: fixed the ability to run tasks with linked scripts
• Connectivity:
  • Fixed jump host edits. Changes take effect as soon as the hostname is updated
  • Fixed the “Test tunnel configuration” functionality that did not work for custom network profiles
• Miscellaneous:
  • Fixed the arm64 build in the dbeaver-ce snap package
• Databases:
  • Athena was updated to version 3.27.0
  • Hive 4: fixed the ability to edit binary files in the Value panel
  • Microsoft Fabric/Azure SQL Server: fixed table name autocompletion when querying tables using schema-qualified names
  • MySQL/MariaDB: fixed an issue with ER diagram creation for tables with foreign keys
  • PostgreSQL: fixed a bug where the “Role” field in the table policy view displayed only a single role when multiple roles were assigned
  • Salesforce: added support for the currency data type
  • SingleStore: adding new tables and rows now uses the correct encoding defined by the database

• AI assistant: added descriptions for the custom prompts
• Data Editor:
  • Improved the presentation of multiple foreign keys
  • Fixed dark mode display for single-tab results
  • Fixed several minor issues related to background rendering, exceptions, and cursor behavior
• Metadata Editor: Fixed tab styling
• Task Management:
  • The “Save Task” button was moved to the same row as the other action buttons
  • Added a tooltip to the Auto-commit option in the SQL Script task settings
• Miscellaneous:
  • Added an option to exclude the application from Windows Defender during installation
  • Fixed Linux installation using Debian
  • Fixed the ability to manage software installation
  • Fixed file opening from the main menu
• Databases:
  • IoTDB: Fixed an SQL execution error (thanks to @LJW21-02)
  • PostgreSQL: Added DDL display support for PostgreSQL policies (thanks to @shAn-kor)
  • Salesforce Data Cloud was renamed to Salesforce Data 360 (thanks to @geoffrothman)
  • SQLite: Fixed an issue where creating a foreign key with a new column failed on the first attempt (thanks to @eusebe-cda)

• SQL Editor:
  • When no text is selected, pressing “Ctrl+C” and “Ctrl+X” will copy or cut the entire line at the caret position (thanks to @jihoon0413, @jihoon0413)
  • Fixed status bar visibility in the result set for single and multiple query execution
  • Added result set display for pause commands in scripts
  • Non-result presentations include filters and actions after executing a script
• AI assistant: fixed the SQL generation for the OpenAI engine
• Grouping Panel:
  • Added Percent of Total function
  • Columns and functions can now be reordered
  • Pressing the Add button opens a submenu with available items and columns
  • Choosing Custom adds an empty, editable column or function
• Data Transfer:
  • Added the ability to export fetched rows without querying the database (in the extraction settings step)
  • Fixed data migration from database to database when the “Selected rows only” option was enabled
• Connectivity:
  • Fixed an SSH connection error on Windows related to permissions for temporary files created by the application
  • The “Database Native” authentication type was renamed to “Username/password”
  • Fixed “Transaction settings” opening in the connection editor
• Miscellaneous: added the ability to open DuckDB and MS Access files via File
• Open in the main menu
• Databases:
  • Athena: Fixed an issue when the connection stopped working after an application upgrade
  • Azure Synapse Dedicated SQL Pool: Fixed the display of stored procedure definitions
  • ClickHouse:
    • Fixed an issue with displaying arrays of UUID, IPv4/IPv6, and Map types. They are now shown as strings in the Data Editor
    • Fixed issues with timestamp insert and update operations with enabled date formatting
  • CUBRID: Fixed an error occurring when executing a script generated after changing the view schema owner (thanks to @longhaseng52)
  • PostgreSQL: Fixed Complete backup behavior and table selection visibility during dump(thanks to @mikiubo)
  • Redshift: Fixed an issue when changing the schema failed if no schema matched the user’s name
  • Salesforce Data Cloud: Fixed default schema detection, which resolved issues with autocomplete
  • TimescaleDB: Fixed incorrect table size display (thanks to @mkanetsuna)

• SQL Editor: improved performance when executing multiple SQL queries simultaneously
• AI Assistant: the temperature setting is disabled for models that do not support it
• Data Editor: “Calculate row count automatically” was enabled by default and applies only to SELECT queries
• Data Transfer: resolved an issue with an oversized data transfer window
• Miscellaneous:
  • Auto-commit settings were redesigned
  • Redesigned visual page structure in Preferences and some dialogs
  • Resolved an issue with incorrect transaction mode display
  • Restored the splash screen on macOS
• Databases:
  • ClickHouse: fixed broken spatial data presentation
  • Sybase: fixed table opening via double-click in the Navigator
  • DuckDB: added support for the dollar-quoted string syntax
  • Redshift:
    • Materialized views are displayed as system tables with a special icon
    • Fixed multiple issues related to permissions, incorrect empty table display, and the data import wizard
  • Netezza: added the ability to search metadata objects by definitions

• Data Editor: Fixed value change cancellation
• Search: Fixed text input for Chinese, Japanese, and other similar languages on macOS
• Data transfer: Removed a warning from the logs that appeared during CSV import
• Miscellaneous:
  • Linux Debian package was fixed
  • Snap:
    • Packaging switched to classic mode
    • Issues with web browser activation were resolved
    • Issues with Office integration were resolved
    • Problem with DuckDB embedded driver connection was fixed
• Databases:
  • MySQL: Fixed database dump when SSH is enabled
  • ClickHouse:
    • Driver version was updated to version 0.9.5
    • JSON data type reading was fixed
    • Issue with CTE expressions was resolved
    • Active database selector was fixed
    • Issue with LIMIT clause and read-only connections was resolved
    • Big numbers rendering was fixed
    • Tuple data types rendering was fixed
    • A number of issues with array data types fetch/render was fixed

• SQL Editor:
  • New script numbering algorithm was improved
  • Bug in Find/Replace panel and Ctrl+Enter shortcut was resolved
  • Dangerous query confirmation now shown for any DROP statements
  • Query confirmation message was fixed
• Data Editor:
  • Ordering of rows by primary key feature was redesigned and now works only in tables
  • Issue with virtual keys and “use all columns as key” option was resolved
  • Issue with tooltips for JSON columns was resolved
  • Value change cancellation was fixed
  • Data export in DbUnit format was fixed (issue with escaping)
  • Data import wizard now show file selector automatically
  • Issue with incorrect detection of read-only columns was resolved
• Miscellaneous:
  • Driver download dialog was fixed (issue with wrong focus and details panel)
  • New connection name generator was improved
  • Connection configuration import from pgAdmin was added
  • Internal connection information page was added to the connection edit dialog
  • Check-buttons and radio-buttons rendering was fixed on Linux
  • Warning related to custom driver icons were removed
  • Option “Open separate connection for metadata reads” save was fixed
  • pt_BR localization was fixed (thanks to @imoliveira88)
• Databases:
  • Azure SQL Server: active database detection was fixed
  • CUBRID: (thanks to @longhaseng52)
    • Issue with duplicated primary key columns was fixed
    • SQL query execution plan layout was fixed
    • Shards support was added
  • Denodo: driver version was updated to 9.0 (thanks to @dlopezc-denodo)
  • TDengine: non-latin encodings support was improved (thanks to @DuanKuanJun)
  • Microsoft Fabric:
    • Stored procedures body reading was fixed
    • Extended properties reading was fixed
  • MySQL: table column DDL generator was added (thanks to @mikiubo)
  • Oracle:
    • issue with active user name detect was fixed (thanks to @alexeyleping)
    • GRANT statements were fixed in object’s DDL
  • PostgreSQL:
    • Login event triggers support was added (thanks to @Morgunov-Vitaly)
    • SSPI authentication was fixed
    • Issue with redundant change of “search_path” variable was resolved
    • Issue with wrong native binary for database restore was resolved
  • Redshift: materialized views read was fixed