Master DBeaver: Free Open‑Source Tool for Managing 100+ Databases

DBeaver Overview

DBeaver is an open‑source database management tool with over 41K GitHub stars, supporting up to 100 relational and non‑relational databases.

Download & Installation

Download the zip package from the official site, unzip, and run

dbeaver.exe

. The first run offers to create a test SQLite database.

Using DBeaver with the mall Project

The tutorial demonstrates DBeaver using the mall SpringBoot3 + Vue e‑commerce system (GitHub ★60K) and its cloud version.

Boot project:

https://github.com/macrozheng/mall

Cloud project:

https://github.com/macrozheng/mall-swarm

Video tutorials:

https://www.macrozheng.com/video/

Theme Settings

DBeaver offers Classic, Light, and Dark themes. Switch to Dark via Window → Preferences → Appearance → Dark.

Create Data Source

Click the plus icon → MySQL to add a MySQL data source; enter connection details and download the JDBC driver if needed.

Table Management

Open a table and view column properties via the

Properties

tab.

View DDL with

Properties → DDL

.

Browse data with the

Data

tab.

Filter rows by typing a

WHERE

clause in the top filter box.

Hide columns by toggling the filter button.

Create new tables by right‑clicking, adding fields, and setting primary key auto‑increment.

SQL Operations

Open the SQL editor via the SQL button. DBeaver provides autocomplete for keywords, functions, tables, and columns. Use the “Generate SQL” feature to create INSERT statements for a selected record.

Other Database Support

Community edition supports many databases, but NoSQL engines like Redis and MongoDB require the PRO version, and Elasticsearch needs a Platinum license.

Conclusion

DBeaver is a powerful free tool with comprehensive features suitable for most relational databases.