dbviz is a tool to visualize relations in a database. Point it at your DB, and it will produce a graph on STDOUT in a format suitable for processing or rendering with graphviz.

gem install dbviz

dbviz needs to know which database to visualize. Unless told otherwise, it looks for a configuration file at ~/.config/dbviz.yaml. To tell it otherwise, either define DBVIZ_CONFIG in the environment, or provide it as the first argument to dbviz.

Environment is recommended, but using arguments is supported for convenience when working with multiple configurations.

---
adapter: postgres
database: my-awesome-database
host: localhost
password: MyVerySecurePasswordStoredUnencryptedOnDisk
port: 5432
user: me

The following command will produce a visualization saved at db.png.

dbviz | dot -Tpng -o db.png

dbviz is available under the MIT License. See LICENSE.txt for the full text.

• Chris Olstrom | e-mail | Twitter