Getting Started with DBeaver: Installation, Database Connections, and ER Diagram Creation

DBeaver is a free, open‑source, universal database management and development tool built on Java and released under the Apache Software License; it can be downloaded from the official website or GitHub.

Because it runs on the Java platform, DBeaver works on Windows, Linux, and macOS, uses the Eclipse framework, supports plug‑ins, and provides features such as ER diagram generation, data import/export, database comparison, and mock data creation.

It connects to databases via JDBC and supports almost every relational product—including MySQL, PostgreSQL, MariaDB, SQLite, Oracle, Db2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby—and, in the commercial edition, also supports NoSQL and big‑data platforms like MongoDB, InfluxDB, Apache Cassandra, Redis, and Apache Hive.

Download and Installation

The DBeaver Community Edition can be obtained from the official site or GitHub, offering installers or zip packages for each OS and an optional bundled JRE; an Eclipse plug‑in is also available for integration.

The installer is straightforward, requires a JRE, and after installation launching dbeaver.exe on Windows displays the main interface.

On first launch DBeaver prompts to create a sample database; accepting creates a default SQLite example and shows the main window.

Connecting to a Database

To create a connection, use the menu Database → New Connection ; for example, selecting PostgreSQL opens a wizard where you specify host, port, database name, user, and password, with advanced options for SSH, SSL, and proxy settings.

Clicking “Test Connection” verifies the settings; if a JDBC driver is missing, DBeaver automatically downloads it.

For drivers that require manual download (e.g., Oracle, Db2), open Database → Driver Manager , edit the driver, add the downloaded JAR (such as ojdbc8.jar ), and reuse it for future connections.

Once a connection is established, you can browse and edit objects, execute SQL statements, and perform development tasks.

Generating ER Diagrams

In the Project view, locate the “ER Diagrams” node, right‑click and choose “Create New ER Diagram”, provide a name, select the connection and objects to include, and DBeaver will generate the diagram, which can be arranged, displayed, or printed as an image.

Additional Resources

Official website: https://dbeaver.io/

GitHub repository: https://github.com/dbeaver/dbeaver/

User guide: https://github.com/dbeaver/dbeaver/wiki