/sqlite-schema-viz

Generate graph visualization of a SQLite database schema

Primary LanguageGoGNU Affero General Public License v3.0AGPL-3.0

SQLite schema visualizer

Go

Usage

$ sqlite-schema-viz /path/to/sqlite.db

Example

CREATE TABLE users ( id integer, name text );
CREATE TABLE posts ( id integer, user_id integer, title text, body text, foreign key (user_id) references users(id) );
CREATE TABLE comments ( id integer, post_id integer, body text, foreign key (post_id) references posts(id) );

example render

Credits

Credit to @Screwtapello on Gitlab for sqlite-schema-diagram which provides the SQL query that generates the Graphviz DOT output this tool is based on.