Awesome Universal Database Tool for multiple tables, scripts, triggers...

DBeaver

DBeaver

  -  121 MB  -  Open Source
  • Latest Version

    DBeaver 24.3.4 LATEST

  • Review by

    Daniel Leblanc

  • Operating System

    Windows 10 / Windows 11

  • User Rating

    Click to vote
  • Author / Product

    DBeaver Corp / External Link

  • Filename

    dbeaver-ce-24.3.4-x86_64-setup.exe

DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.

DBeaver is a free and open-source universal database tool for developers and database administrators.
  • Usability is the main goal of this project, program UI is carefully designed and implemented.
  • It is free and open-source (ASL).
  • It is multiplatform.
  • It is based on an opensource framework and allows writing of various extensions (plugins).
  • It supports any database having a JDBC driver.
  • It may handle any external data source which may or may not have a JDBC driver.
  • There is a set of plugins for certain databases (MySQL, Oracle, DB2, SQL Server, PostgreSQL, Vertica, Informix, MongoDB, Cassandra, Redis, InfluxDB in version 5.x) and different database management utilities (e.g. ERD, data transfer, compare, data export/import, mock data generation, etc).
What`s new:
  • Database navigator
  • Create an object menu was improved (no redundant sub-menu)
  • Connection folders creation was fixed
  • Elements coloring was improved (for different connection types)
  • Shortcuts processing was fixed (broken shortcuts after some actions)
  • Table editor tabs activation was fixed
  • Columns Editor: auto-completion was fixed in drop-downs.
  • Data transfer: export from multiple queries was fixed (target file names)
  • SQL Editor: SQL formatter was fixed (exp numbers and other minor fixes)
  • Spatial data editor:
  • Geography/geometry value editor (plaintext, WKT)
  • Numerous fixes in different SRIDs support
  • Oracle: metadata (constraints, foreign keys) reading performance was significantly improved
  • PostgreSQL:
  • Multiple query result sets support was added
  • Table partitions information was extended
  • Native database backup was fixed
  • Database creation was fixed (special characters in db name)
  • Sequence rename was fixed
  • Full schema DDL generation was fixed
  • Greenplum, Redshift: execution plan explain now supports plaintext format
  • SQLite: sample database was updated
  • Sybase (12 and older): stored procedures source reading was fixed
  • Apache Ignite: identifiers quoting was fixed
  • DB2 iSeries: schema reading was fixed
  • Extra command line parameters (connection opening)
  • Connections import from SQL Developer was fixed
  • Windows installer: config files (dbeaver.ini) backup
  • Extensions (Office, SVG, etc) installer was fixed
  • Checking for multiple DBeaver instances was added
Note: Requires Java Runtime Environment.

Also Available: Download DBeaver for Mac

  • DBeaver 24.3.4 Screenshots

    The images below have been resized. Click on them to view the screenshots in full size.

    DBeaver 24.3.4 Screenshot 1
  • DBeaver 24.3.4 Screenshot 2
  • DBeaver 24.3.4 Screenshot 3
  • DBeaver 24.3.4 Screenshot 4
  • DBeaver 24.3.4 Screenshot 5

What's new in this version:

SQL Editor:
- Added the ability to use multi-line variables in SQL scripts
New autocompletion engine was improved and enabled by default:
- Autocomplete performance was significantly improved
- Fixed an issue with autocomplete failure after the dot
- Fixed autocomplete for JOIN conditions
- Fixed an issue with not executed included scripts
- Fixed alias case sensitivity in autocomplete
- Changed an icon for derived column in autocompletion proposals
- ER Diagram: added the ability to generate SQL with INNER JOIN and SIMPLE JOIN from a diagram
- Query Manager: query duration formatting was fixed

Data Editor:
- Fixed an issue where unchanged cells were incorrectly marked as updated after pasting data
- Fixed row coloring when querying multiple tables
- Data transfer: removed the ability to change data type for existing columns in Data Export
- Database Navigator: database object filter was improved. Connection filter is enabled by default

Miscellaneous:
- We migrated to the Java 21
- Added the ability to associate different file types with DBeaver on Windows and macOS
- Bookmark vew is now working again
- Font in error messages was changed to monospace
- Commit/Rollback monitor was fixed
- Fixed bold font display for theming on macOS

Databases:
- Azure Databricks: information_schema was added to Database Navigator
- Databend: icons were updated

CUBRID:
- Fixed index creation preview
- Fixed column creation with STRING and similar data types
- Procedure, function, and view names are now displayed in lowercase
- Added the ability to change comment for foreign key columns
- LibSQL: UI for token-based authentication was added
- Machbase: driver was updated to version 8.0.2
- MySQL/MariaDB: explain plan now works for all types of SQL queries

Oracle:
- Fixed DDL generation for table spaces
- Fixed user password changing
- PostgreSQL: fixed an issue with disappearing ENUM definition after the refresh in Metadata editor

Salesforce Data Cloud:
- Removed the ability of edit database metadata
- The latest driver version is now downloaded by default
- SAP HANA: partition view was added
- SQLite: STRICT mode support was added

SQL Server:
- Index creation was fixed
- Fixed an issue where the index type couldn't be changed to unique

Teradata:
- XML column value save was fixed
- Removed incorrect warning message after executing SHOW and similar queries