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 v24.0.0 on Windows:
  1. Download and install program
  2. Use the universal patch to patch the program, and generate a valid license key for it
  3. Run program, and use the license key to register
  4. Done
for 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 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 (x64, x32)
    • on Mac, use DMG package (x64)
    • on Linux, use .TAR.GZ package (x64, x32)
  • You'd better not use DBeaver's built-in JRE, because it's a castrated version.
  • In actual use, AppNee found that although it had many functions, its performance was too poor. Especially, frequent network connection interruptions lead to operation failure. In contrast, MySQL-Front is still the first choice for AppNee to connect to MySQL.

Related Links

Download URLs

License Version Download Size
Community Edition (freeware) Latest n/a
for Windows
Ultimate Edition v24.3.0 419 MB
for Mac
Ultimate Edition v24.3.0 434 MB
for Linux
Ultimate Edition v24.3.0 436 MB
All Versions Universal License Agent
Enterprise Edition v1.0.0 1.02 MB
(Homepage 1 | Homepage 2 | GitHub)