For those of you that are new, Dolt is a database that supports Git-style versioning. DoltHub is a place on the internet to share and collaborate on Dolt databases. Recently, we released the ability to generate Entity Relation (ER) diagrams for your databases on DoltHub. It's a great tool to visualize the entities in your database as well as the relationship between tables. It helps you understand and analyze the structure of the database.

Visual representation of the database

By clicking the ER Diagram button in the left nav, the diagram will show up as an overview of the database. This gives you insight into the information that is contained in the database, such as primary keys, foreign key relations, columns, and column types.

It's interactive!

On the canvas, you can zoom in and out using the mouse scroll or the control buttons in the top right corner of the canvas.

You can also move tables around by dragging so you can generate a perfect diagram.

Potential future features

Our goal is to build this into a visual schema editor that would enable you to redesign your database structure, you would be able to remove columns, change columns' types, add foreign keys in the diagram and then apply those changes to your database. These changes would happen on a branch so you could then create a Pull Request for human review of your changes. Database development in multiplayer mode! DoltHub is trying to be the Figma of databases.

If you have feedback or ideas for additional features you’d like to see, reach out to us on Discord, or file a feature request on GitHub.