SchemaCrawler - Introduction
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.
Please wait for the SchemaCrawler Docker container to start. Then, move on to the next step.
SchemaCrawler - Generating Output Files
Step 1 - Run the SchemaCrawler Interactive Shell
This scenario shows you how to start the SchemaCrawler Interactive Shell.
Please wait for the SchemaCrawler Docker container to start. Then, move on to the steps.
Open File Browser for SchemaCrawler Output Files
Open the "File Browser" to see the list of input and generated output files. Hit refresh on the index each time you generate a new file.
Start the SchemaCrawler Interactive Shell
We assume that you are familiar with the SchemaCrawler Interactive Shell.
Start the SchemaCrawler Interactive Shell, by running:
Load database metadata for a SQLite database, run:
connect --server=sqlite --database=sc.db load --info-level=standard