A utility for rendering the XML output of Schemaspy into a PlantUML diagram.

In general, schema diagrams are low fidelity representations of the actual schema. The goal of this utility is to generate a diagram that provides the user with a general idea of what the actual schema is. Ultimately, the fine details are in that .sql file.

To generate the schema XML file, the Schemaspy jar is required. Version used here is 6.1.0 . It is available from GitHub

Since we are not interested in HTML output the -nohtml parameter should be used. An invocation may look like this:

java -jar schemaspy-6.1.0.jar -configFile ./schemaspy.config

where schemaspy.config for Postgres may be:

schemaspy.nohtml schemaspy.t=pgsql schemaspy.dp=<HOME_DIR>/.m2/repository/org/postgresql/postgresql/42.2.16/postgresql-42.2.16.jar schemaspy.host=localhost schemaspy.port=5432 schemaspy.db=<DB_NAME> schemaspy.u=<DB_USER> schemaspy.p=<DB_PASSWORD> schemaspy.o=<OUTPUT_DIR>/schemaspy_out schemaspy.schemas=public schemaspy.I=<STUFF_TO_IGNORE>

Checkout the project and execute ./gradlew clean build. The build/libs directory will contain the fat jar gesrep-<VERSION>-all.jar

java -jar build/libs/gesrep-<VERSION>.jar <PATH_TO_SCHEMA_XML_FILE> <PATH_TO_OUTPUT_FILE> Some sample schema XML files are in test/resources so you can try them out.

This is the output from test/resources/demo.bookings.xml :

Because the output is a PlantUML file, it is possible to customise the "look and feel". For example, try adding !theme materia-outline, removing skinparam defaultFontName Courier and so on.

at the top.

Copyright 2021 David Soroko.

Licensed under the Apache License, Version 2.0