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

Download and Installation

DBeaver is a free, open‑source, Java‑based universal database management and development tool released under the ASL license. It can be downloaded from the official website or GitHub and runs on Windows, Linux, and macOS. The community edition provides installers or zip packages, optionally bundled with a JRE.

After installation, launching dbeaver.exe (on Windows) opens the main interface, where you can create a new database connection.

Connecting to a Database

To create a connection, select Database → New Connection and choose the desired database type, e.g., PostgreSQL. Provide host, port, database name, user, and password. Advanced settings allow configuring SSH, SSL, and proxy options.

Click Test Connection to verify the settings; DBeaver will automatically download the required JDBC driver if it is missing. After a successful test, confirm to add the connection to the navigation pane.

For databases like Oracle where drivers require manual download, open Database → Driver Manager , edit the Oracle driver, and add the downloaded ojdbc8.jar file. Subsequent connections will use this driver.

Generating ER Diagrams

In the left navigation pane, expand Database Navigator → Projects , right‑click the desired connection, and choose ER Diagrams → Create New ER Diagram . Provide a name, select the connection and objects to include, then click Finish to generate the diagram.

The ER diagram can be rearranged, customized, and exported as an image for documentation.