Home

Awesome

<p align="center"> <a href="https://azimutt.app" target="_blank" rel="noopener"> <picture> <source media="(prefers-color-scheme: dark)" srcset="assets/azimutt-logo-light.png"> <source media="(prefers-color-scheme: light)" srcset="assets/azimutt-logo-dark.png"> <img alt="Azimutt logo" src="assets/azimutt-logo-dark.png" width="500"> </picture> </a> </p> <p align="center"> <b>Next-Gen ERD</b>: Design, Explore, Document and Analyze your database, schema and data </p> <p align="center"> <a href="https://azimutt.app" target="_blank" rel="noopener">azimutt.app</a> • <a href="https://github.com/orgs/azimuttapp/projects/5" target="_blank" rel="noopener noreferrer">roadmap</a> • <a href="https://twitter.com/azimuttapp" target="_blank" rel="noopener noreferrer">@azimuttapp</a> </p> <p align="center"> <a href="https://www.producthunt.com/posts/azimutt?utm_source=badge-featured&utm_medium=badge&utm_souce=badge-azimutt" target="_blank"><img src="https://api.producthunt.com/widgets/embed-image/v1/featured.svg?post_id=390699&theme=light" alt="Azimutt - Easily explore and analyze your database with your team | Product Hunt" style="width: 250px; height: 54px;" width="250" height="54" /></a> <a href="https://azimutt.app/slack" target="_blank"><img src="assets/slack-join.svg" alt="Join us on Slack" style="width: 216px; height: 54px;" width="216" height="54"></a> </p>

Azimutt is a full-stack database exploration tool.
From modern ERD made for real world databases (big & messy), to fast data navigation, but also documentation everywhere and whole database analysis.

Azimutt screenshot

Why building Azimutt?

Databases existed for more than 40 years and despite a lot of tool around them, we couldn't find any providing a great exploration experience.

So we decided to build the missing tool 💪

We started with schema exploration for databases with hundreds of tables, but now, it has grown a lot:

Azimutt goal is to be your ultimate tool to understand your database.

Azimutt badge

You can load any public SQL file in Azimutt with just an url parameter. So if you have a SQL file in your repo, like structure.sql, you can add a button allowing your visitors to quickly explore it:

[![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)

Here are some examples:

explore database with Azimutt explore database with Azimutt explore database with Azimutt

Or use our custom button image:

explore database with Azimutt

Self-hosted

You can use our Docker image to easily deploy it. Here is the full guide.

Deploy on Heroku

You can use our Heroku template which includes Azimutt web app, a Postgres database, Stackhero S3 storage and Mailgun.

Deploy

After succeed deployment, you will need to configure config vars

# Replace with your app-name
HEROKU_APP=<app-name>

# Set PHX_HOST with the URL of the app
heroku config:set PHX_HOST=$(heroku info -s | grep "web_url" | sed 's|web_url=https://||; s|/$||')

# Copy Stackhero access key to S3_KEY_ID
heroku config:set S3_KEY_ID=$(heroku config:get S3_ROOT_ACCESS_KEY)

# Copy Stackhero secret key to S3_KEY_SECRET
heroku config:set S3_KEY_SECRET=$(heroku config:get S3_ROOT_SECRET_KEY)

Finally, you will need to create the azimutt bucket on Stackhero:

Deploy on Kubernetes

Please read this guide

Local development

Azimutt is built with Elixir/Phoenix (backend & admin) and Elm/elm-spa (editor).

For local development you will need to set up the environment:

Other things:

command semantics

We have a lot of projects with a lot of commands, here is how they are structured:

Development commands

Setup Stripe

Config

Payments

When testing interactively, use a card number, such as 4242 4242 4242 4242. Enter the card number in the Dashboard or in any payment form. Use a valid future date, such as 12/34. Use any three-digit CVC like 123 (four digits for American Express cards). Use any value you like for other form fields.

See more in the stripe testing documentation

Stack

License

The tool is available as open source under the terms of the MIT License.