pg_diagram

A tool for creating Entity-relationship diagrams for PostgreSQL

Installation

• install Graphviz

• pip install pg-diagram

Usage

pg_diagram --format svg -o diagram.svg schema.sql

# or feed output of pg_dump
pg_dump --schema-only mydb | pg_diagram -o mydb.png -

Sample output