Convert SQLAlchemy DB Model into entity relationship diagram using Python

Here is my requirements.txt for the project.

greenlet==1.1.2
psycopg2-binary==2.9.3
pydot==1.4.2
pyparsing==3.0.7
SQLAlchemy==1.4.31
sqlalchemy-schemadisplay==1.3

If the graphviz package was not installed, we have to install it globally. Installing the graphviz package as a project package does not work for me.

sudo apt install graphviz

Here is the Python script to generate diagrams.

from sqlalchemy_schemadisplay import create_schema_graph
from sqlalchemy import MetaData

graph = create_schema_graph(metadata=MetaData('postgresql://db_user_name:db_user_password@db_host_name/db_name'))
graph.write_png('image_name.png')

Recent Posts

1. Solve "ValueError invalid literal for int() with base 10" - Python
2. Handling dynamic subdomain with Flask - Python
3. A minimal example about WordPress object cache
4. Select random element from a list - Python
5. Write our first Selenium program with Python 3 & Firefox

This article was published on April 14, 2022

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.