Skip to main content

Package to create ER diagrams from SQLAlchemy schemas using Graphviz.

Project description


SQLAlchemyViz is a command line utility to create entity-relations diagrams from database schemas modeled with SQLAlchemy using Graphviz.


Requires Graphviz installed on your machine and the SQLAlchemy and pydot packages.


SQLAlchemyViz is distributed under the MIT License.


Create an ER diagram from a sqlalchemy schema object.

positional arguments:
pkg.module:metadata Import path for the metadata identifier.
optional arguments:
-h, --help show this help message and exit
-f FILE, --file FILE
 Write diagram to specified file {default: diagram.pdf}.
-p PROG, --prog PROG
 Name of the graphviz layout program to use {default: “dot”}. Other choices are: “dot”, “twopi”, “circo” or “fdp”.
 Where OPTION is e.g. “graph_bgcolor=red”. May be supplied multiple times.
 Path to folder containing the graphviz executables.
 Include the given comma separated list of tables or classes. If omitted, create diagram for all.
 Exclude the given comma separated list of tables or classes.
--sort-columns Sort columns by whether they are primary or foreign keys and (case-insensitive) alphabetically.
 Draw relations between tables only once (if multiple foreign keys reference the same table).
 Show table constraints.
--max-cols MAX_COLS
 Limit amount of columns shown per table.

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for SQLAlchemyViz, version 0.4
Filename, size File type Python version Upload date Hashes
Filename, size SQLAlchemyViz-0.4.tar.gz (7.4 kB) File type Source Python version None Upload date Hashes View

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring DigiCert DigiCert EV certificate Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page