sqlite2png 0.1.4

Command line tool to get a png diagram of SQLite DB

This is a command line interface for sqlalchemy_schemadisplay tool by Florian Schulze.

Usage

sqlite2png.py sqlite.db

Example

$ python sqlite2png.py /usr/share/ibus-libpinyin/db/english.db
sqlite:////usr/share/ibus-libpinyin/db/english.db
writing db.png

The script uses SQLAlchemy, pydot and graphviz under the hood. Graphviz-cairo is recommended upstream to improve image quality.

Roadmap

• install command line script with pip
  • de-vendorize sqlalchemy_schemadisplay after it is released
• output .png to stdout
• reproducuble
• option to show the image (needs PIL and image viewer)
• option to diff the image
• add example DB to the repo
• support full urls

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