[v23.0, v22.2] DBeaver – Free, open-source and cross-platform universal database tool & SQL client

This article along with all titles and tags are the original content of AppNee. All rights reserved. To repost or reproduce, you must add an explicit footnote along with the URL to this article!
Any manual or automated whole-website collecting/crawling behaviors are strictly prohibited.
Any resources shared on AppNee are limited to personal study and research only, any form of commercial behaviors are strictly prohibited. Otherwise, you may receive a variety of copyright complaints and have to deal with them by yourself.
Before using (especially downloading) any resources shared by AppNee, please first go to read our F.A.Q. page more or less. Otherwise, please bear all the consequences by yourself.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

When it comes to connecting to a database, Navicat this graphical and easy-to-use database connection tool is well suited to meet your various needs. But since that when it executes statements like delete from table, update table set column=’value’, you would get no indication if they were executed without additional conditions. As a result, database maintainers can cause data disasters if they are not careful enough during routine maintenance. That’s why some companies are starting to ask for a switch to DBeaver.

DBeaver is a free, open-source and cross-platform (based on Java) universal database tool and SQL client specially developed for developers and database administrators on Windows, Mac and Linux platforms. It provides a simple and user-friendly graphical user interface for viewing database structures, executing SQL queries and scripts, browsing and exporting data, processing BLOB/CLOB data, modifying database structures, and much more.

As a convenient and reliable database tool, DBeaver supports all database formats, including MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Sybase, ODBC, Java DB (Derby), Firebird (Interbase), HSQLDB, SQLite, Mimer, H2, IBM Informix, SAP MAX DB, Cache, Ingres, Linter, Teradata, as well as all other JDBC or ODBC compliant database formats. Therefore, it is able to handle any external data sources. In addition, it also supports database metadata viewing, metadata editing (including tables, columns, keys, indexes), SQL keywords highlighting, etc.

// Key Features //

  • SQL queries execution
  • Data browser/editor with a huge number of features
  • Syntax highlighting and SQL auto-completion
  • Database structure (metadata) browse and edit
  • SQL scripts management
  • DDL generation
  • ERD (Entity Relationship Diagrams) rendering
  • SSH tunneling
  • SSL support (MySQL and PostgreSQL)
  • Data export/migration
  • Import, export and backup of data (MySQL and PostgreSQL)
  • Mock data generation for the database testing
  • It is free and open-source (ASL)
  • It is multi-platform

// Supported Databases //

Relational Database NoSQL Database
  • MySQL
  • MariaDB
  • Oracle
  • PostgreSQL
  • IBM DB2
  • EXASOL
  • Microsoft SQL Server
  • Microsoft Access
  • Sybase
  • Java DB (Derby)
  • Firebird (Interbase)
  • Derby (JavaDB)
  • SQLite
  • Mimer
  • HSQLDB
  • H2
  • IBM Informix
  • Netezza
  • Apache Phoenix
  • Apache Derby
  • Apache Phoenix
  • SnappyData
  • Teradata
  • SAP MAX DB
  • Cache
  • Ingres
  • Linter
  • Vertica
  • ODBC
  • Any other database which has JDBC or ODBC driver
  • MongoDB
  • Cassandra
  • Redis
  • Persistent QM

// System Requirements //

// Edition Statement //

AppNee provides the DBeaver Enterprise/Ultimate Edition multilingual pre-activated full installers, all versions universal license agent, as well as portable full registered versions for Windows, Mac and Linux (32-bit and 64-bit).

// Installation Notes //

for Ultimate Edition v21.2.0+ on Windows:

  1. Download and install program
  2. Copy the unlocked files to the “plugins” folder under DBeaverUltimate’s installation path and overwrite
  3. Run program once and exit
  4. Copy the license file to the following path:
    • C:\Users\[user name]\.jkiss-lm\
  5. Done

for Enterprise Edition v7.x.x with Universal License Agent:

  1. Download and install/extract the latest version of DBeaver Enterprise Edition from official site
  2. Download and put the license agent file ‘dbeaver-agent.jar‘ somewhere
  3. Open the ‘dbeaver.ini‘ file under installation path, and append this line (like: -javaagent:/absolute/path/to/dbeaver-agent.jar) to the bottom (do make sure the path is correct, otherwise the program can not launch), e.g.:
    • Windows: -javaagent:C:\Users\neo\dbeaver-agent.jar
    • Mac: -javaagent:/Users/neo/dbeaver-agent.jar
    • Linux: -javaagent:/home/neo/dbeaver-agent.jar
  4. Done

*** If you see this error: Error opening zip file or JAR manifest missing : dbeaver-agent.jar, the solution is:

  • Try to use the absolute path of jar files

// Prompts //

  • For v6.2+, there are a few things to note:
    • on Windows, use ZIP package (x64x32)
    • on Mac, use DMG package (x64)
    • on Linux, use .TAR.GZ package (x64x32)
  • You’d better not use DBeaver’s built-in JRE, because it’s a castrated version

// Related Links //

// Download URLs //

License Version Download Size
Community Edition (freeware) Latest n/a
for Windows
Ultimate Edition v21.3.0 reserved 319 MB
v22.3.0 reserved 373 MB
v23.0.0 366 MB
for Mac
Ultimate Edition v22.2.0 705 MB
for Linux
Ultimate Edition v22.2.0 359 MB
All Versions Universal License Agent
Enterprise Edition v1.0.0 1.02 MB

(Homepage 1 | Homepage 2 | GitHub)

If some download link is missing, and you do need it, just please send an email (along with post link and missing link) to remind us to reupload the missing file for you. And, give us some time to respond.
If there is a password for an archive, it should be "appnee.com".
Most of the reserved downloads (including the 32-bit version) can be requested to reupload via email.