sqlite2png 1.1.4

Command line tool to get a png diagram of SQLite DB

sqlite2png tool generates .png image of database schema.

Usage

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

About and examples

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.

Roadmap / Changelog

• de-vendorize sqlalchemy_schemadisplay after it is released
• output .png to stdout
• option to show the image (needs PIL and image viewer)
• option to diff the image
• support full urls

    {py} postgres://user:pwd@host/database
    {py} sqlite:////usr/share/my.db

• (1.1.4) install command line script with pip
• (1.1.4) add example DB to the repo (uses some public DBs)
• reproducuble .png (seems like it already is)