Basic database schema

This database schema is not the most innovative one. But still, it’s rich enough to experiment many powerful features of Azimutt that make it a very special Entity Relationship Diagram targeted at real world databases.

First, you see all the tables but with big database schema this is not convenient. Use right click (or even keyboard shortcut!) to hide tables and columns at will. This makes exploration of huge databases possible, and even pleasant.

Columns with relations to hidden tables have a colored icon. Click on it to follow the relation! That’s the best way to navigate in your schema.

If you are still lost and don’t know which path to take to join two tables, try the find path feature (table menu or top right lightning). It will do all the hard work for you, following every path to find the right relations.

Once you are happy with your diagram, save it as a layout. So you can come back to it later. Layouts are useful to keep diagrams for features, team scopes or even onboarding new developers.

While we are at it, let’s talk about documentation. It can be a good idea to put it on SQL comments as a single source of truth. Azimutt will show them with a small bubble on tables and columns. But sometimes it’s more convenient to update them directly in the diagram. That’s why Azimutt has notes that you can put on tables and columns as well (try right click on them).

Now you have the basics to use Azimutt. But keep exploring it as there is so much more to discover 😉

Azimutt is very active with new features every month. We prioritize a lot from users feedback. So if something bother you or if you see any possible improvement, please don’t hesitate to reach out! It can be a small typo or one UX tweak, but also big features like desktop app, live database access or CI integration. This will help you, us, and all the other Azimutt users!