Doteur

A simple tool to draw your mysql relations from exports.

Help us

If you use the tool, and like it, don't forget to add a star to the project on GitHub :star:, it helps us to keep motivation to improve it.

If you have any suggestion, or issue, please report it, it will help us to fix them.

General information

How to use through Docker

To download the tool

bash docker pull nag763/doteur:latest

Then to use it, simply pass a folder with your sql files, and be careful to write all your outputs in the shared folder to ensure the files are available on your host machine once the image is destroyed.

bash docker run --rm -v ${PATH_TO_YOUR_SQL_FOLDER}:/usr/src/doteur/shared -it nag763/doteur:latest bash

How to install it natively

  1. Optional but highly recommended

First install graphviz.

On Linux, use your default package manager.

Example on ubuntu :

usr@ubuntu:~$ sudo apt-get install graphviz

On Windows, use winget or the default graphviz installer.

You can still refer to the graphviz download page.

The tool uses graphviz libraries to render in other formats than .dot, if graphviz is not installed or you do not want to install it, you can still use this tool and pass it your output file.

  1. Download the tool

cargo install doteur

bash cargo install --git https://github.com/nag763/doteur

  1. Use the tool

bash doteur --help

  1. Add it to your path

If you need to use it regularly, it is recommended to add the bin folder to your path. For this, look on how to do it on your distro.

On linux :

bash ln -s path/to/doteur /usr/sbin

Cli usage

```bash usr@linux:~$ doteur --help doteur 0.3.2 LABEYE Loïc Convert .sql files to .dot files

USAGE: doteur [FLAGS] [OPTIONS] ...

FLAGS: --dark-mode Render in dark mode -h, --help Prints help information -V, --version Prints version information

OPTIONS: -x, --exclude ... Exclude the given tables -i, --include ... Include only the given tables -o, --output The output filename

ARGS: ... Name of the sql file, can also be a directory or several files ```

Example usage

Export a .sql file to a .dot

bash usr@pop-os:~$ doteur sample.sql

The output will be in the output.dot

Export a .sql file to a .png

bash usr@pop-os:~$ doteur sample.sql -o output.png

The output will be in a png file.

For the format supported, please refer to the graphviz documentation

Export a .sql file to a .png, render in dark mode

bash usr@pop-os:~$ doteur sample.sql -o output.png -x hello* --dark-mode

Export a .sql file to a .png, include only tables who have either the name hello or world

bash usr@pop-os:~$ doteur sample.sql -o output.png -i hello world

Export a .sql file to a .png, include only tables who starts with the name hello

bash usr@pop-os:~$ doteur sample.sql -o output.png -i hello*

Export a .sql file to a .png, exclude all tables who starts with the name hello

bash usr@pop-os:~$ doteur sample.sql -o output.png -x hello*