Difficulty: Intermediate
Estimated Time: 20 minutes

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.

Thank you for completing your SchemaCrawler scenario in Katacoda.

You can continue with reading the SchemaCrawler Getting Started Guide.

SchemaCrawler - Introduction to the Interactive Shell

Step 1 of 7

Step 1 - Run the SchemaCrawler Interactive Shell

This scenario will show you how to start the SchemaCrawler Interactive Shell.

Please wait for the SchemaCrawler Docker container to start. Then, move on to the steps.


Start the SchemaCrawler Interactive Shell

Start the SchemaCrawler Interactive Shell, by running:

schemacrawler --shell

Get Help

From the shell prompt, schemacrawler>, run:

help

Get Help for a Command

For help on the connect command, from the shell prompt, schemacrawler>, run:

help connect