Visualizes your SQLite database schema.
$ npm install -g sqletonYou need to install graphviz separately:
$ [pacman -Sy | apt-get install | brew install] graphviz$ sqleton -o db.svg db.sqliteThe format will be inferred from the name of the output file; you
can use any format supported by graphviz (png, pdf, svg, and many more).
Usage: sqleton [options] <database>
Options:
-L, --layout The layout command
[choices: "neato", "dot", "circo", "fdp", "osage", "sfdp", "twopi"]
[default: "fdp"]
-e, --edge-labels Label foreign key edges [boolean]
-t, --title Optional title string
-f, --font The font to use [default: "Helvetica"]
-d, --direction Graph direction [choices: "TB", "LR"] [default: "LR"]
-o, --out Output file (determines output format) [required]
The fine tune your graph, the best option is to use .dot as your output
format and adjust the parameters in the file.
const sqleton = require('sqleton')
// Open your database and writable stream
// ....
sqleton(db, stream, options)
.then(() => { db.close() })
.then(() => { stream.end() })sqleton was written to visualize SQLite schemata. Having said that,
you can try to dump your schema and create a new SQLite database for
visualisation from it.
GPL-3.0