An intuitive and user-friendly interface Once you launch the application for the first time, it will automatically scan the entire computer and display the existing connections (if they are available). In case you want to create a new connection, simply access the proper option, choose the database you are interested it, then set the login credentials (optionally, specify the ODBC drivers if they are required).

After that, DBeaver displays all of the identified databases and users for the current connection. A new tab, entitled Projects, will become available in the left panel of the program from where you can easily access the database object you want and view its data.

For instance, if you double click on a specific table, the right panel will display all the necessary information such as available columns, pre-defined constraints and foreign keys, references, triggers, indexes and the proper CREATE DDL statement (also known as Data definition language).

Practical SQL editor and query execution commands
Considering the main purpose for which it was designed for, DBeaver comes with a reliable SQL editor that allows you to quickly edit and execute queries and scripts. Additionally, you are able to load an existing SQL script, as well as validate or simply analyze the selected query.

As far as the query execution command is concerned, you can run the selected SQL query using the proper options available in the toolbar or pressing the ‘CTRL+Enter’ key combination.

A straightforward database solution
All in all, DBeaver comes packed with useful and easy to handle tools and editors that come in handy for users who need to manage multiple database connections, triggers, procedures and views, as well as execute SQL scripts, from simple to complex.

Features:
Connection manager
Metadata browser
SQL Editor
Scripts
Execute queries
Working with SQL
Miscellaneous
Data viewer/editor
Data/metadata search
Database structure compare
Data transfer (export/import)
ER Diagrams
Query Manager
Projects
Extra views
Driver manager
More…

Java notes:
DBeaver requires Java 11 or higher. Since version 7.3.1 all distributions include OpenJDK 11 bundle.
If you want to use you own locally installed Java you may delete folder “jre” in the DBeaver installation folder.

Home Page - https://dbeaver.com/