sqlite2png
tool generates .png image of database schema.
From checkout without installing (needs sqlalchemy
and pydot
).
./sqlite2png.py sqlite.db
The diagram is written into db.png
.
Install with pip and run as module.
pip install sqlite2png
sqlite2png /usr/share/ibus-libpinyin/db/english.db
sqlite:////usr/share/ibus-libpinyin/db/english.db
writing db.png
sqlite2png
is a CLI wrapper over
sqlalchemy_schemadisplay
lib by Florian Schulze, which uses SQLAlchemy
, pydot
and graphviz
under the hood. Graphviz-cairo
is also recommended to improve image quality.
See ./examples.
sqlalchemy_schemadisplay
after it is released {py} postgres://user:pwd@host/database
{py} sqlite:////usr/share/my.db
pip