DBeaver is a SQL client software application and a database administration tool for relational databases. DBeaver Community is a free cross-platform database tool designed for developers, database administrators, analysts, and anyone working with data. It is free and open source. It supports popular SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, SQL Server, Oracle, and more. DBeaver was initially released in 2011.
With DBeaver you are able to manipulate your data, for example, in a regular spreadsheet, create analytical reports based on records from different data storages, and export information in an appropriate format. For advanced database users, DBeaver suggests a powerful SQL-editor, plenty of administration features, abilities of data and schema migration, monitoring database connection sessions, and a lot more.
ERD Diagrams
It can be very helpful to view your database as a diagram. Let’s look at a simple example. First, let’s create a very simple SQLite database that has Locations and Organizations.
-- Locations definition
CREATE TABLE Locations (
id INTEGER PRIMARY KEY,
city TEXT,
province TEXT,
country TEXT
);
-- Organizations definition
CREATE TABLE Organizations (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
description TEXT,
location_id INTEGER,
FOREIGN KEY (location_id) REFERENCES Locations(id)
);
INSERT INTO Locations
(id, city, province, country)
VALUES(1, 'Creemore', 'Ontario', 'Canada');
INSERT INTO Locations
(id, city, province, country)
VALUES(2, 'Toronto', 'Ontario', 'Canada');
INSERT INTO Locations
(id, city, province, country)
VALUES(3, 'Barrie', 'Ontario', 'Canada');
INSERT INTO Organizations
(id, name, description, location_id)
VALUES(1, 'Water First', 'Water First is dedicated to helping address water challenges in Indigenous communities in Canada through education, training and meaningful collaboration.', 1);
INSERT INTO Organizations
(id, name, description, location_id)
VALUES(2, 'Evergreen', 'Evergreen works to create cities that are livable, green and prosperous through connection to nature and sustainability programs.', 2);
INSERT INTO Organizations
(id, name, description, location_id)
VALUES(3, 'United Way Simcoe Muskoka', 'Focuses on tackling local poverty and building strong communities through support programs and advocacy.', 3);
To save the diagram, right click a white space of the diagram and Save Diagram As… graphml. You need to choose…
Learn with YouTube – a few selected videos
How to download and install DBeaver Windows & Linux & macOS.
How to create a database connection in DBeaver.
Hybrid Cloud with DBeaver PRO: AWS, Microsoft Azure & GCP.
Simple or Advanced: choose your navigation tree view in DBeaver.
How to customize your Navigation Tree in DBeaver.
How to organize your connections: Projects in DBeaver.
DBeaver Data Editor: a brief overview.
Default Data Grid colorization in DBeaver and how to change it.
Highlight your data in the Data Grid.
DBeaver Value panel. Today, databases do not store only strings and numbers, as it used to be. You can use your database for different data types, including images, spatial data, and even data structures such as JSON. If the text value is easy to edit right in the table cell, working with more complex data types can be difficult.
DBeaver Metadata panel & References panel. Louis, the hero from one of our previous videos, has a new hobby. As he is quite fond of going to the cinema, he has created his own website with information about movies. Louis stores movie titles and descriptions, cast lists, and other information in a database and updates it regularly. And with DBeaver, he can easily keep his site up-to-date.
Visualize data with DBeaver. DBeaver supports a large number of databases with different purposes. Relational databases remain the most common databases our users constantly work with, and our app offers a wide range of features for working with the data stored in them. For your convenience, we have added the ability to visualize data to our PRO versions as one more way to work with data.
Two ways to use ERD in DBeaver.
Forward Engineering with ERD in DBeaver PRO.
DBeaver SQL Editor overview. Today we want to tell you about the SQL Editor – a powerful tool for creating and executing various SQL scripts. .
How to use ChatGPT in DBeaver. DBeaver team continues to maintain and improve the AI assistant based on GPT-3. In this demo video we show you how to use ChatGPT in our app. We use the model gpt-3.5-turbo, most up-to-date one(???).
Two ways to use Visual Query Builder in DBeaver PRO. The main goal of our apps is to simplify SQL scripting for users in various professions who have different skill levels. That’s why we have the Visual Query Builder – the tool with which you can create queries you need in just a few clicks. Today, we want to talk about two ways you can use this feature in DBeaver PRO apps.
Working with tasks in DBeaver: how to get started. Many of our users complete repetitive tasks such as importing and exporting data, database dumping and restoring, comparing data, etc. on a regular basis while working on our app. DBeaver Enterprise and DBeaver Ultimate allow you to automate these routine processes to make them faster and more convenient.
Database Tasks View in DBeaver: all your tasks in one place. Database Tasks view provides many opportunities to work with existing tasks and create new ones. Let’s take a closer look at this tool and its use.
Composite tasks and how to create them in DBeaver. In many cases, routine processes that are repeated at regular intervals do not consist of a single task, but instead, it consists of a sequence of tasks. In this case, we suggest using composite tasks in DBeaver. For example, you can import data from one database and then load it to another database or create a dump of a production database and then restore it on stage.
How to use Scheduler for your tasks in DBeaver PRO. As you may have learned from the previous articles in this series, the tasks in DBeaver can significantly simplify your routine processes and save you time. But what if you want your tasks to run on specific days and times? In this case, you can use the Scheduler, another useful feature of DBeaver.