How to Export Database Diagrams (ERD) from Django?

In this tutorial, we will learn to Export Database diagrams (ERD) from Django. It’s an easy process to export ERD with Django Extensions.

Here, I have tested this service on my Windows laptop so you can follow a similar process if you are using Linux or Mac.

TL;DR

1. Install Graphviz software in your laptop
2. pip install graphviz
3. pip install django-extensions
4. Go to settings.py > add 'django_extensions', to INSTALLED_APPS
5. Add the following code 
GRAPH_MODELS ={
    'all_applications': True,
    'graph_models': True,
     }
 to settings.py
6. pip install pyparsing pydot
7. py manage.py graph_models -a > erd.dot
8. py manage.py graph_models -a
9. py manage.py graph_models -a > erd.dot && py manage.py graph_models --pydot -a -g -o erd.png

Steps to Export Database Diagrams (ERD)

When working with a relational database, you’ll need to create some Entity Relationship Diagram (ERD) at some point. ERDs help visualize the relationships between database tables and can be a helpful tool for designing or reverse-engineering databases.

1. Install Graphviz software

One of the easiest is to use the open-source Graphviz tool. Graphviz is a set of tools for visualizing graph data, and it’s easy to use with databases.

Since you need to visualize the structural information, install Graphviz software first. Visit the official website and install it according to your operating system.

2. Install graphviz package

Now go to your IDE > Project and Install the graphviz package. Here is the command to install Graphviz:

pip install graphviz

3. Install Django Extensions

There are a few reasons to install django-extensions and they are to add functionality to your project, to improve project performance, or to make your project more user-friendly.

pip install django-extensions

4. Add Django Extensions to settings.py

Now, it’s time to add ‘django_extensions’.

Go to settings.py > add ‘django_extensions’, to INSTALLED_APPS

Also, add the following code in the settings.py at the end.

GRAPH_MODELS ={
'all_applications': True,
'graph_models': True,
}

5. Install pyparsing pydot

pyparsing and pydot are both required by the Graphviz library. pyparsing is a library for parsing text strings. pydot is a library for creating, manipulating, and visualizing graphs in DOT format.

Now use the following code.

pip install pyparsing pydot

py manage.py graph_models -a > erd.dot

py manage.py graph_models -a

8. Export Database Diagrams (ERD)

Now, it’s time to Export Database Diagrams (ERD) using the following code. This will output a file called “erd.dot” which can be opened with the graphviz program to generate a visual representation of your app’s models and their relationships. This will also generate a file called “erd.png” which is a visual representation of your app’s models and their relationships.

py manage.py graph_models -a > erd.dot && py manage.py graph_models --pydot -a -g -o erd.png

Also Read: How to Install Tailwind CSS in Django?

Conclusion

Now, open your project folder locate the erd.png file, and see the exported Entity-Relationship diagram.
I hope after reading the above guide you can export Export Database Diagrams (ERD) in Django Framework.