Diagrams (PostgreSQL)

Index

Introduction

This page covers tools for generating database diagrams.

DBeaver

Home > https://dbeaver.io

It allows to generate an EntityRelationship Diagram (ERD) from an existing database.

Other features include an SQL Editor for executing queries, etc.

Installation

sudo snap install dbeaver-ce

Note: Run it from the dash looking for: DBeaver Community

DB connection

The 1st step is to configure a new connection to a database. The following example uses a local DBMS with a database named 'sampledb' using 'sampleuser'

Host: localhost Port: 5432

Database: sampledb

Authentication: Database Native

Username: sampleuser

Password: ****

ERD generation & export

Let's generate and export an EntityRelationship diagram in .png format.

Double-click in "Tables" (postgres > sampledb > Schemas > public > Tables) which will open 2 tabs: Properties & ER Diagram

Click tab "ER Diagram" and click button 'Save diagram in external format' (located in the botton-right).