Master DBeaver: Install, Connect, and Generate ER Diagrams for Any Database

DBeaver is a free, open‑source, Java‑based universal database management and development tool released under the ASL license. It runs on Windows, Linux, and macOS, and is built on the Eclipse framework with plugin support.

# Download and Installation

The community edition can be downloaded from the official website or GitHub. Installers or zip packages are provided for each OS, and an optional bundled JRE can be installed. After installation, launching dbeaver.exe (Windows) opens the main interface.

The initial screen prompts to create a sample database; cancelling leads to the main window.

# Connecting to a Database

Open DBeaver and choose Database → New Connection to start the connection wizard. As an example, select the PostgreSQL icon and click Next . Fill in host, port, database name, user, and password. Advanced settings allow SSH, SSL, and proxy configuration, as well as naming the connection.

Click Test Connection to verify settings. DBeaver will automatically download the required JDBC driver; simply click Download and confirm the connection.

After a successful test, the new connection appears in the left‑hand navigation pane.

# Managing Drivers Manually (e.g., Oracle)

For databases whose JDBC drivers require authentication (such as Oracle or Db2), use Database → Driver Manager . Select the Oracle driver, click Edit , and add the driver file manually (e.g., ojdbc8.jar) via the Add File button. Future connections will use this driver.

# Generating ER Diagrams

In the left navigation, open the Projects view and locate the ER Diagrams node. Right‑click and choose Create New ER Diagram . Provide a name, select the database connection and objects to include, then click Finish . The diagram can be arranged, customized, and exported as an image, though DBeaver does not support creating diagrams from scratch.

# Additional Resources

Official website: https://dbeaver.io/

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

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

These resources provide further documentation, plugin information, and community support.