DBeaver

• DBeaver
  • Install
  • Create DB Connection
• Table
  • DBeaver can show
• Execute SQL script

an open-source multi-platform universal database management tool that allows developers to connect to databases view and edit data, create and modify database.

Install

• Download DBeaver and install.

Create DB Connection

• click New Database Connection to create a new connection.

  

• Then, select the database that you need to connect.

  

• After that, Setup db connection and click Finish.

Example connection:

Host	localhost
Port	5432
UserName	testuser
Password	postgres

docker-compose

version: '3.8'
services:
  db:
    image: postgres:14.1-alpine
    restart: always
    environment:
      - POSTGRES_USER=testuser
      - POSTGRES_PASSWORD=postgres
    ports:
      - '5432:5432'

• DBconnection will show up on your Database Navigator Bar. If the connection was not success, it shows ❌. Otherwise, the connection was success.
• if connection is fail. Please, making sure that you database is up and you connection is correct.
• click Edit connection to correct it.

Table

• Select table to view table information.

DBeaver can show

• Properties
• Data - You can change the value by double clicking on the call that you want to edit.
• ER Diagram

Execute SQL script

• open Sql script by right click on DB or click on SQL Editor.
• select an operation that you like to do.
• write your SQL script. Then execute.