10 ways to use AI with your databases

Catch the webinar recording from Aug 4th on YouTube

DBeaver Community

Open-source version
  • Basic support for relational databases:
    MySQL, SQL Server, Postgres and others
  • Data Editor
  • SQL Editor
  • Task management
  • Database maintenance tools
  • AI Chat & @ai command

DBeaver PRO

Commercial version
  • All DBeaver Community features
  • Advanced security
  • AI Chat & advanced AI features
  • Advanced support for relational databases
  • Connection through ODBC drivers
  • NoSQL databases support:
    MongoDB, Cassandra, Redis, CouchDB and others
  • Cloud databases support:
    Redshift, Google BigQuery, Oracle Cloud and others
  • Native support for AWS, Google Cloud, and Azure
  • Cloud storage support
  • Database development tools
  • Database performance visual tools
  • Multi-component task management
  • Task Scheduler
  • Visual Query Builder
  • Ongoing technical support

dbvr Community

Open-source version
  • Basic support for relational databases:
    MySQL, SQL Server, Postgres and others
  • Username + password auth support
  • SSH tunnels support
  • Query result export to the local disk
  • Metadata management

dbvr

Commercial version
  • Advanced security:
    master password and strong credentials encryption
  • Enterprise-level authentication methods:
    SSO, SSL, and Kerberos. SSO authentication cloud services such as GCP, AWS, and Azure
  • Secret management: AWS, Vault, CyberArk
  • Advanced SQL databases support:
    MySQL, PostgreSQL, SQL Server, Oracle and others
  • NoSQL databases support:
    MongoDB, Cassandra, Redis, CouchDB and others others
  • Cloud databases support:
    Redshift, Google BigQuery, Oracle Cloud and others
  • Amazon S3, Azure Blob Storage and GCP cloud storages support
  • Query result export to the cloud storages
  • MCP configuration to expose a database connection as an MCP server
  • Ongoing technical support

DBeaver 26.2.2

  • AI Assistant:
    • Redesigned the AI engine selector with a native drop-down, engine icons, and improved keyboard accessibility
    • Fixed model discovery for self-hosted OpenAI-compatible endpoints with non-OpenAI model names
    • Improved error messages for HTTP redirects from custom OpenAI-compatible endpoints by showing the redirect target and configuration guidance
    • Fixed model listing and chat requests for self-hosted OpenAI-compatible endpoints when the base URL has no trailing slash (thanks to @Ashfaqbs)
    • Improved guidance and validation when the custom AI scope contains no database object
    • Fixed an issue on macOS where opening the AI profile or model picker could immediately select an item
  •  SQL Editor:
    • Added a setting to choose whether Enter, Tab, both, or neither accepts autocomplete suggestions
    • Added a preference to disable the large-script result-fetch warning (thanks to @akmalsyrf)
    • Fixed SQL Editor toolbar background colors for color-coded connections in the dark theme
      -=
  • Metadata Editor:
    • Fixed invalid table DDL generation when column comments contain double hyphens (thanks to @MicBun)
    • Data Editor:
    • Made the issue-reporting link clickable when the calendar editor encounters an unsupported date/time value
    • Fixed spacing and background inconsistencies in the virtual structure editor
  • Connectivity:
    • The connection wizard now prompts users to choose a connector when the selected database has multiple options
    • Improved navigation between project and global network profile settings
    • Improved the confirmation dialog for removing a network handler
  • Navigator:
    • Restored context menus for breadcrumbs in object editors and the status bar
    • Fixed a startup freeze when Database Navigator was in a detached window
  • Miscellaneous:
    • Fixed a Linux startup crash when the Product Configuration wizard opened
    • Redesigned and reorganized the General preferences page
    • Improved Preferences search by adding keywords to preference pages
    • Fixed inaccurate progress reporting during native tool file transformations (thanks to @cuishuang)
    • Fixed overly bright hover highlighting for view minimize and maximize buttons on Windows in the dark theme
    • Improved editor tab visibility by adding separators between unselected tabs
    • Fixed excessive accumulation of temporary files and improved cleanup of abandoned files
    • Fixed diagnostic archive collection to include all rotated log files
    • Fixed version-update controls to prevent duplicate downloads and keep the update button correctly positioned
    • Improved drop-down list sizing, scrolling, and theme colors
    • Improved UI color updates after changing the application theme without restarting DBeaver
    • Improved the contrast of inactive editor tabs for color-coded connections in the dark theme
    • Added theme selection with live preview to the User Interface preferences
  • Databases:
    • Apache Doris: Fixed CSV import into schemas and post-import table refresh
    • GBase 8s:
    • Fixed JSON value handling in the “Copy As SQL” command (thanks to @Downstream1998)
    • Fixed the Columns tab failing to load when the read_defaultstr routine is unavailable (thanks to @sakshichitnis27)
    • PostgreSQL: Added support for viewing and managing the PUBLIC pseudo-role in Permissions tabs (thanks to @NikRom5531)
    • TiDB Cloud Lake: Added the TiDB logo to the connection page (thanks to @akshar27)
    • Timeplus: Fixed incorrect numeric values and intermittent hangs during CSV import (thanks to @EastLord)

DBeaver 26.2.1

  • Product configuration:
    • Fixed an issue where toolbars for disabled tools remained visible
  • AI Assistant:
    • Added profile and model selectors to AI Chat
    • Fixed a white flash when opening AI Chat in the dark theme
    • Improved AI Chat prompt caching, reducing repeated input-token processing in multi-turn conversations
  • SQL Editor:
    • Detached query result tabs now preserve the original result tab name and tooltip
    • Disconnecting a data source no longer prompts to save or automatically saves an open SQL script (thanks to @gsastraw)
    • User-defined Escape key bindings now work when no inline suggestion is visible (thanks to @danielpallettfr)
    • Fixed default formatting of column lists in CREATE TABLE constraints
    • Fixed intermittent errors in the Error Log when editing INSERT statements
    • Fixed an error that could occur when editing or moving the caret quickly while code completion was open
  • Metadata Editor:
    • Added a tooltip explaining that object names are transformed according to database naming conventions
  • Data Editor:
    • Added an option to display very small numbers in scientific notation instead of rounding them to zero
    • Fixed dictionary lookups for columns with composite foreign keys (thanks to @gsastraw)
    • Fixed an issue where hiding a column reset manually adjusted widths for other columns (thanks to @gsastraw)
    • Fixed incorrect row filtering when navigating composite foreign-key references
    • Improved performance when pasting a large number of cells
    • Improved Value panel performance when navigating between text columns
    • Fixed an issue where Advanced Paste could make the application unresponsive when inserting a large number of rows
  • Data transfer:
    • Fixed invalid exported DDL when apostrophes in inline column comments caused separator commas to be misplaced (thanks to @MicBun)
  • Connectivity:
    • Connection URLs can now be selected and copied while using host-based connection settings
    • Added support for specifying a custom SSH agent socket for SSH tunnel authentication on macOS (thanks to @LystranG)
    • Fixed importing connections from custom CSV files when optional URL parameters were missing
    • Network profiles are now sorted alphabetically
  • Navigator:
    • Fixed object filtering in Database Navigator folders when the “Connected only” filter was enabled
    • Connection type color changes are now applied immediately in Database Navigator (thanks to @sernopay)
    • Fixed an issue where the active project disappeared from the Projects view after being renamed (thanks to @anton-erofeev)
    • Fixed an issue where changing connection view settings without reconnecting could leave the connection tree empty
    • Fixed an issue where connections were not displayed in Database Navigator after switching workspaces in the Eclipse plugin
  • Miscellaneous:
    • Version updates are now shown in the toolbar instead of a pop-up dialog, and update download progress was improved
    • Added a “Run DBeaver” option to the Windows installer
    • Improved editor tab highlighting for colored connections: active tabs now use the connection color, while inactive tabs use a lighter shade
    • Fixed UNC path handling for DBeaver data directories on Windows (thanks to @gsastraw)
    • Fixed low-contrast text in read-only dropdown menus when using the dark theme on macOS
    • Improved dark theme colors for progress bars and embedded SQL editors
    • Fixed an issue where log rotation failures could interrupt tasks and data transfers
    • Windows ARM: Fixed a startup crash
    • Fixed excessive CPU usage when the update notification appeared over the master password prompt
    • Reorganized standard preference pages for easier navigation
    • Windows: Restored the splash screen when DBeaver is installed in Program Files
  • New drivers:
    • Added the Manticore Search driver (thanks to @akmalsyrf)
    • Added the TiDB Cloud Lake driver (thanks to @hantmac)
  • Databases:
    • Apache Doris: Fixed SQL query execution in the default schema without requiring the database and schema to be reselected
    • Apache IoTDB: Fixed changing the active database in the SQL Editor (thanks to @LJW21-02)
    • DuckDB:
      • Added SQL LIMIT clauses to Data Editor queries to prevent excessive memory use with large tables
      • Added support for connections on Windows ARM64
    • Firebird: Fixed function DDL generation to preserve parameter and return types, nullability, and SQL security mode (thanks to @sakshichitnis27)
    • GBase 8s: Fixed loading large CLOB and TEXT values when DBeaver is installed for all users on Windows (thanks to @Downstream1998)
    • MariaDB:
      • Fixed an issue where the Constraints tab could show a CHECK expression from another table (thanks to @zanlucathiago)
      • Named CHECK constraints are now shown in the Constraints tab for users with SELECT-only access (thanks to @zanlucathiago)
    • MySQL: Fixed execution of the SOURCE command in SQL scripts (thanks to @gsastraw)
    • Oracle: Standalone indexes used by constraints are now preserved in generated DDL
    • PostgreSQL:
      • Fixed active schema changes in manual commit mode by prompting users to commit the current transaction and updating the schema indicator
      • Fixed errors when displaying curved PostGIS geometries in the Spatial data viewer
      • Fixed the ability to backup selected tables
    • SQL Server: Added support for selecting target column collations during data transfer
    • Timeplus: Fixed data transfer and CSV import by generating STREAM DDL for target objects (thanks to @EastLord)
    • VeloDB: Fixed an issue where Describe object failed for VeloDB
  • Localization:
    • Windows installer: Restored the language selector

Recent News

Keep up with DBeaver

Subscribe to our news and get the list of the most useful shortcuts in DBeaver.


Explore the DBeaver blog for practical tips and product news.

License

DBeaver Community Edition is free and open source (ASL) product.
Just download and start using it.