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

DBeaver

DBeaver

  -  116 MB  -  Open Source
  • Latest Version

    DBeaver 24.3.1 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.1-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.1 Screenshots

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

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

What's new in this version:

SQL Editor:
- Added AS before table alias in FROM clause for all relevant databases
- New autocompletion: added support for USING and some improvements for JOIN condition
- Fixed indentation behavior when adding a new line
- Added support for ${time} variable in data source variables for script templates

Data Editor:
- Cell hints were redesigned. You can configure them on the Context menu
- Added support for the composite types for Grouping panel
- Items with the too long text in query history were truncated
- Navigator: Saving filter for database objects was fixed
- Data Transfer: Added the ability to use comma as a delimiter in the Advanced Copy option
- Connectivity: Proxy configuration loading was fixed

Miscellaneous:
- Proper names for catalog/schema are now used for different drivers
- Added word wrap for hints to controls
- Search in Preferences was improved
- Scrolling in the "Tip of the day" window was fixed
- Metadata configuration files were moved to the .metadata/config folder
- Localization of basic controls, settings, and menu items was fixed
- We migrated to Eclipse 2024-12

Development:
- .gitignore for IDEA files was configured
- Building IDEA project was fixed
- New Drivers: Databend database was added

Databases:
- CUBRID: Added REUSE_OID, COLLATE, and COMMENT to the table DDL
- Google BigQuery driver was updated to version 42_1.5.4.1008
- InterSystem IRIS driver was updated

MySQL:
- Now users can change expired password
- Added a setting to not export routines
- OpenEdge: query generation was fixed
- OrientDB driver was updated

PostgreSQL:
- Added default privileges grantor to DDL
- Syntax error in DDL generated for the role settings was fixed
- Default privileges for new roles were fixed
- Salesforce Data Cloud driver was updated
- Snowflake: Added support for table aliases in autocompletion
- SQLite: creating new constraint from selection was fixed
- SQL Server: Primary Key ordering in DDL generation is now respected