DBeaver CE (Community Edition) is a free and open-source universal database tool for developers, SQL programmers, database administrators, and analysts. It supports various databases, including relational databases like MySQL, PostgreSQL, SQLite, Oracle, SQL Server, and non-relational databases like MongoDB and Cassandra, among others.

DBeaver provides a graphical user interface (GUI) that allows users to manage database connections, execute SQL queries, browse and edit table data, view database structures, import and export data, generate ER diagrams, and perform various database administration tasks.

To install DBeaver CE (Community Edition) on Linux follow these general steps.

Update Package Lists

First, update the package lists to ensure you’re getting the latest versions of the software.

sudo apt update

Install DBeaver CE (Community Edition)

sudo snap install dbeaver-ce

Configure DBeaver CE (Community Edition)

Upon launching DBeaver, you’ll be prompted to set up your database connections. Follow the wizard to connect to your databases by providing the necessary connection details.

To configure DBeaver CE with Maria DB Server follow these steps.

1. Open Dbeaver CE.
2. Click on Database and New database connection.
3. Select MariaDB.
4. Set MariadDB password.
5. Click on the Finish button.

Configuration details

URL: jdbc:mariadb://localhost:3306/

Port: 3306

Server Host: localhost

Local Client: /usr

Conclusion

Once you’ve configured your database connections, you’re ready to start using DBeaver for database management and development. By following these steps, you should be able to install DBeaver CE on your system and start using it to work with your databases.