hywan/database-to-plantuml

Extract database table information into a PlantUML description.

1.1.0 2017-09-06 12:36 UTC

This package is not auto-updated.

Last update: 2024-11-24 04:32:07 UTC


README

This utility renders a graphical 2D visualisation of a database.

Currently, the only supported frontends are PostgreSQL and MySQL. There are 2 backends: commonmark and plantuml. The plantuml backend allows to generate visualisations into the following formats:

  • PNG,
  • SVG,
  • EPS,
  • PDF,
  • VDX,
  • XMI,
  • HTML,
  • TXT,
  • UTXT,
  • LaTeX.

Installation

With Composer, simply run the following command:

$ composer install

If you would like to use it as a dependency of your project, then:

$ composer require hywan/database-to-plantuml

To use the plantuml backend, you can use the JAR in resource/plantuml.jar.

Examples with…

… PostgreSQL

Taking as an example the famous employees use case:

# Import the schema.
$ psql -f resource/samples/pgsql-employees.sql postgres

# Generate the visualisation.
$ bin/database-to-plantuml -d 'pgsql:dbname=employees' -u hywan -s employees | \
      java -jar resource/plantuml.jar -verbose -pipe > output.png

Output with PostgreSQL

… MySQL

With the same employees use case:

# Import the schema.
$ mysql -u root < resource/samples/mysql-employees.sql

# Generate the visualisation.
$ bin/database-to-plantuml -d 'mysql:dbname=employees' -u root -s employees | \
      java -jar resource/plantuml.jar -verbose -pipe > output.png

Output with MySQL

Note: Outputs differ because the employees examples are not exactly the same. They are here to illustrate the tool only.

License

BSD-3-License, but seriously, do what ever you want!