Repolode
Submit
azimuttapp

azimuttapp/azimutt

Full-stack database exploration tool for designing, navigating, documenting and analyzing schemas, with ERD diagrams for large, messy databases.

Open-source alternative to:dbdiagram.ioLucidchart

View on GitHubWebsite
Stars
2,192
Forks
145
Open issues
85
Last commit
2 months ago

What is it?

Azimutt is a database exploration tool built for schemas with hundreds of tables. It offers an entity-relationship diagram view that stays usable as schemas grow, along with search across tables and columns, the ability to show only relevant tables and follow foreign-key relations, and a way to query data while navigating relationships.

Beyond browsing, Azimutt lets teams document tables and columns with notes and tags, save layouts and memos for specific use cases or teams, and design schemas using AML, its own text-based diagramming language. It also includes analysis features that look for inconsistencies and common best-practice issues in a schema.

The web app is built with Elixir and Phoenix on the backend and Elm for the editor. It can be self-hosted with a Docker image or deployed to Heroku or Kubernetes. The repository's topics list supported engines including PostgreSQL, MySQL, MariaDB, Oracle, SQL Server, MongoDB and others.

Key features

  • 01Interactive ERD diagrams designed for large, real-world schemas
  • 02Global search across tables and columns, with relation following
  • 03Table and column notes, tags, layouts and memos for documentation
  • 04Schema design with AML, a text-based diagramming language
  • 05Schema analysis to surface inconsistencies and best practices
  • 06Embeddable badge to let anyone explore a public SQL file online

Use cases

  • Getting oriented in a legacy database with hundreds of tables
  • Documenting a team's schema with notes, tags and shared layouts
  • Reviewing a schema for inconsistencies before or after changes
  • Sharing a browsable view of a SQL schema file in a project README

Quick start

  1. 1

    Install pnpm, Elm, elm-spa, Phoenix, Elixir and PostgreSQL

  2. 2

    Copy the example environment file

    copy .env.example to .env
  3. 3

    Install dependencies and set up the project

    source .env && npm run setup
  4. 4

    Start the Azimutt server, then open localhost:4000

    source .env && npm start

Things to know

  • Local development requires installing many tools, including Elixir, Phoenix, Elm and PostgreSQL.
  • Self-hosting is documented via Docker, Heroku and Kubernetes guides, which adds setup effort.

Topics

#database#erd#database-design#database-documentation#postgresql#mysql#sql#schema#couchbase#database-diagrams

FAQ

What is azimutt?
Full-stack database exploration tool for designing, navigating, documenting and analyzing schemas, with ERD diagrams for large, messy databases. Azimutt is a database exploration tool built for schemas with hundreds of tables. It offers an entity-relationship diagram view that stays usable as schemas grow, along with search across tables and columns, the ability to show only relevant tables and follow foreign-key relations, and a way to query data while navigating relationships.
Is azimutt free to use? What license does it have?
azimutt is open source under the MIT license. Check the license terms before using it in commercial products.
Is azimutt still maintained?
Updated within 6 months. The last commit to azimutt was on Aug 25, 2026.
What can I use azimutt for?
Getting oriented in a legacy database with hundreds of tables Documenting a team's schema with notes, tags and shared layouts Reviewing a schema for inconsistencies before or after changes Sharing a browsable view of a SQL schema file in a project README
How do I install azimutt?
Install pnpm, Elm, elm-spa, Phoenix, Elixir and PostgreSQL Copy the example environment file: copy .env.example to .env Install dependencies and set up the project: source .env && npm run setup Start the Azimutt server, then open localhost:4000: source .env && npm start
Where can I get azimutt?
The source code and installation instructions are on GitHub: https://github.com/azimuttapp/azimutt

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects