Using SchemaSpy - lmu-bioinformatics/xmlpipedb GitHub Wiki

To use SchemaSpy, you need:

  1. SchemaSpy

  2. Postgres JDBC Driver

  3. Graphviz

  4. The file path to the bin folder inside the Graphviz installation folder must be added to your system's PATH environment variable.

The command to run schemaspy is:

java -jar <Schemaspy Jar> -t <Table Type> -db <Database Name> -u <User Name> -p <Password> -o <Output Directory> -host <Host: likely localhost> -port <Port: Likely 5432> -dp <JDBC driver location> -s <Schema Name> -hq

  • SchemaSpy Jar: As of the time of this writing, the current jar by default is named schemaSpy_5.0.0.jar

  • Table Type: For GMBuilder, this will be "pgsql".

  • Database Name: The name of the database you want to analyze.

  • User Name: The username of the owner of the database

  • Password: The database password, if it has one.

  • Output Directory: The directory that the results of SchemaSpy will be generated in.

  • Host: The database host. This will likely be localhost.

  • Port: The port the database is hosted on. For Postgres, it is by default 5432.

  • JDBC Driver Location: The path to the JDBC driver.

  • Schema Name: The name of the schema to be analyzed. By default, this is public.

Putting it all together, the final command for me was:

java -jar schemaSpy_5.0.0.jar -t pgsql -db uniprotdb -u postgres -p postgres -o C:\Users\Me\Desktop\xmlpipedb\uniprotdb -host localhost -port 5432 -dp C:\Users\Me\Desktop\postgresql-9.4.1212.jre6.jar -s public -hq

This will generate all of the SchemaSpy files into the directory C:\Users\Me\Desktop\xmlpipedb\uniprotdb, where they can then be put on the xmlpipedb website.

⚠️ **GitHub.com Fallback** ⚠️