Azimutt can load any SQL file from the URL and display its entity-relationship diagram. Thanks to that, you can create a GitHub badge allowing your users to explore your database schema, IN ONE CLICK 🤯
To use it on your own repository, there are a few simple steps:
-
Navigate to your SQL schema file and get it's *raw* url
For Azimutt the file is backend/priv/repo/structure.sql, so the raw url is https://raw.githubusercontent.com/azimuttapp/azimutt/refs/heads/main/backend/priv/repo/structure.sql
-
Build the Azimutt create url
The structure is
https://azimutt.app/create?sql=$file_url&name=$project_name
, so Azimutt it's https://azimutt.app/create?sql=https://raw.githubusercontent.com/azimuttapp/azimutt/refs/heads/main/backend/priv/repo/structure.sql&name=Azimutt -
Create your badge with shields.io
You can build the ones you want. For PostgreSQL here is the suggested url: https://img.shields.io/badge/PostgreSQL-browse_online-gray?labelColor=4169E1&logo=postgresql&logoColor=fff&style=flat. See below for others.
-
Put everything together, displaying a link with image in your README
Here is how to do it in markdown:
[![Image alt](Image url)](Link url)
, so the final result for Azimutt is: [![Explore database with Azimutt](https://img.shields.io/badge/PostgreSQL-browse_online-gray?labelColor=4169E1&logo=postgresql&logoColor=fff&style=flat)](https://azimutt.app/create?sql=https://raw.githubusercontent.com/azimuttapp/azimutt/refs/heads/main/backend/priv/repo/structure.sql&name=Azimutt)
Depending on your database, you can use these examples:
Some repos have adopted it, add yours if you want: