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. Automating Code Linting with GitHub Actions for WordPress Plugins
2. Comprehensive Guide to Linting PHP, JavaScript, and CSS in WordPress Plugins Using Composer
3. The Ultimate Guide to Indexing in Database Design
4. Understanding 'update_meta_cache' in WordPress - When to Use It, When Not to, and Its Impact on Database Queries
5. A Guide to Configuring JavaScript and SCSS Paths in WordPress Plugins with @wordpress/scripts

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.