# sqliteviz

**Repository Path**: mirrors_rubiojr/sqliteviz

## Basic Information

- **Project Name**: sqliteviz
- **Description**: Creates simple diagrams in DOT, PNG and SVG from SQLite database files.
- **Primary Language**: Unknown
- **License**: ISC
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2025-02-16
- **Last Updated**: 2026-04-04

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# SQLiteViz

Go application that creates simple diagrams in .dot, .png or .svg from your
SQLite database schemas using Graphviz. 

Installation:

    go install github.com/n0x1m/sqliteviz@latest

Usage, provided graphviz is installed:

```sh
Usage of ./sqliteviz:
  -db string
        sqlite database path
  -ignore value
        tables to ignore
  -out string
        output file to write to write to
  -template string
        template file to use (default "diagram.tpl.dot")
```

Examples

```sh
# to dotfile
sqliteviz db.sqlite3 > output.dot
# to png
sqliteviz db.sqlite3 | dot -Tpng > output.png
# to svg
sqliteviz db.sqlite3 | dot -Tsvg > output.svg
# using flags and with ignore list
sqliteviz -db db.sqlite3 -ignore schema_migrations,sqlite_stat1 > output.dot
```

## Example

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:

```sh
sqliteviz -db chinook.db -ignore schema_migrations,sqlite_stat1 > example/chinook.dot
sqliteviz -db chinook.db -ignore schema_migrations,sqlite_stat1 | dot -Tsvg > example/chinook.svg
```

![sqlite visualization of the chinook database](./example/chinook.svg)

See the corresponding [Graphviz dot file](./example/chinook.dot) that was
generated.