sqliteviz summary:

Simple Go application that creates ERD diagrams in DOT, PNG and SVG from SQLite database files using a dot template for Graphviz. Find the sqliteviz source code on Github[1]. If you have the go tool chain installed, you can install and try gmifs with:

1: sqliteviz source code on Github

Simple relationships are shown with edges and composite indices and unique indices are added at the bottom of the attribute list. Color coding can be controlled via the template file:

- **Primary keys** are purple in the front column.

- **Foreign keys** and indices are green in the front column.

- **Nullable attributes** are blue in the rear column.

Chinook is a sample database available for SQLite and other databases. It's an alternative to the Northwind database and is meant for demos and testing ORM tools. It can be created by running a single SQL script. The following sample was generated against Chinook with:

Chinook database visualized with sqliteviz[1]

1: Chinook database visualized with sqliteviz

See the corresponding Graphviz dot file[1] that was generated.

1: Graphviz dot file