#DBeaver is a free, multi-platform and universal database manager for developers, SQL programmers, database administrators and analysts. This software tool supports many databases including but not limited to:

  • MySQL
  • SQLite
  • PostgreSQL
  • Oracle
  • Microsoft SQL Server
  • IBM DB2
  • Sybase
  • MongoDB and etc.

General features includes:

  1. Connection manager
  2. Metadata browser
  3. SQL Editor
  4. Data viewer/editor
  5. Data/metadata search
  6. Database structure compare
  7. Data transfer (export/import)
  8. ER Diagrams
  9. Query Manager
  10. Extra views
  11. Driver manager
DBeaver

Homepage: http://dbeaver.jkiss.org/

Download page: http://dbeaver.jkiss.org/download/

License: Free

Version: v23.3.4 (04 Feb 2024)

Note:
1) Java notes: DBeaver requires Java 17 or higher. Since version 23.0 all distributions include OpenJDK 17 bundle.
If you want to use you own locally installed Java you may delete folder “jre” in the DBeaver installation folder.
2) DBeaver EE (Enterprise Edition) includes NoSQL databases (e.g. MongoDB) support and additional Eclipse extensions for better project management. License purchase is requried.

Change Log:

  • Metadata Editor:
    • Constraint creation was fixed
    • Editor performance on Linux was enhanced
  • SQL Editor:
    • Autocomplete for aggregate functions was added
    • Arrays highlighting was added
    • SELECT query validation was fixed
    • Color and font settings with enabled semantic analysis was fixed
    • Small font in the editor and result set was fixed
    • Creating multiple parsing jobs was fixed
  • Outline viewer:
    • Composite types and arrays support and validation was added
    • Data type decorations were added
    • Error when saving SQL console as a script was fixed
  • AI: Issue with using chat format in completion dialog was fixed
  • Data Editor:
    • Ignoring quotes option was added to Advanced paste
    • Issue with multiple checks in filters was fixed
  • ER Diagram: Self-connection rendering was enhanced
  • Data Transfer:
    • Delimiter selection when exporting in TXT format was added
    • Target table change on the mapping page was fixed
  • General: Idle connections behavior has changed, now they are automatically closed by default after some time
  • New drivers:
    • RisingWave driver support was added
    • Cubrid driver support was significantly enhanced (thanks to @longhaseng52)
  • Databases:
    • Altibase:
      • Adding and renaming constraint in metadata editor was fixed
      • Reading data in columns with quote names was fixed
    • Clickhouse: Legacy driver was fixed
    • MySQL and MariaDB: ‘Grant option’ is checked only if grant permission exists
    • Snowflake:
      • Snowflake driver was updated to version 3.14.4
      • Double-dash single-line comments highlighting was fixed
      • Functions words were added to SQL Editor
    • SQLite driver was updated to version 3.44.1.0
    • TDengine: Unqoted table names presentation was fixed
    • PostgreSQL: Option ‘Show all databases’ was moved to the main page in the Connection settings
    • Redshift: Added extended support for stored procedures for early Redshift versions
  • Misc:
    • Links to download PRO version were added
    • Ability to use waffle-jna in MariaDB, PostgeSQL, and Oracle was added
    • Flipped splash screen on macOS Sonoma was fixed