Sarathlal N

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')

Looking for a skilled developer? I'm currently available for freelance, contract, or full-time remote opportunities! Let's create something amazing together. Send me a quick message, and I'll respond within 24 hours!

Recent Posts

  1. SQL From Basics to Mastery — A Complete, Hands-On Guide
  2. WordPress Beginner Interview Questions
  3. Mastering Traits in PHP - The Complete Guide for Code Reuse and Modularity
  4. Understanding the Singleton Pattern and Using Traits to Achieve Singleton in WordPress Plugin Development
  5. REST API Methods Explained with Best Practices for Building Clean and Secure APIs

This article was published on

Your Questions / Comments

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