How to Visualize Your SQLite Database with One Command (and Nothing to Install)

Ever wondered what the tables in your SQLite database look like, and how they are related to each other? Generate a diagram of your SQLite database with one command. You can run this on any system that has Docker installed.

On a Linux system, run a command like:

docker run \
--mount type=bind,source="$(pwd)",target=/home/schcrwlr \
--rm -it \
schemacrawler/schemacrawler \
/opt/schemacrawler/bin/schemacrawler.sh \
--server=sqlite \
--database=chinook-database-2.0.1.sqlite \
--info-level=standard \
--command=schema \
--output-file=output.png

The command assumes that a SQLite database called "chinook-database-2.0.1.sqlite" is in your current directory. A file called "output.png" will be generated with the database schema, including columns, data-types, and foreign key relationships.

If you are using PowerShell on Windows, replace the trailing backslash on each line with a back-tick, and map the current directory differently. Run this command:

docker run `
--mount type=bind,source="${PWD}",target=/home/schcrwlr `
--rm -it `
schemacrawler/schemacrawler `
/opt/schemacrawler/bin/schemacrawler.sh `
--server=sqlite `
--database=chinook-database-2.0.1.sqlite `
--info-level=standard `
--command=schema `
--output-file=output.png

You can generate PDF files, and other types of output too. Go through the SchemaCrawler tutorials on Katacoda to learn more SchemaCrawler commands.

Comments

[Sualeh Fatehi]

@adriens - are you referring to this article?

[adriens]

Exactly what I needed !!!

[adriens]

Indeed ;-p

[adriens]

Go to killercoda.com/schemacrawler for up-to-date Schemacrawler course

[adriens]

I want the next episode 🤓

[adriens]

Could you also please add the html, pdf options to your post ?

[adriens]

here is some additional inspiration for your collection :

📝 Write DEV.to > How to Visualize Your DuckDb Database with One Command (and Nothing to Install) #1015

adriens posted on Feb 04, 2023

Description

In the same way you wrote How to Visualize Your SQLite Database with One Command (and Nothing to Install) , could you use DuckDb jdbc driver to write a dedicated DEV.to article called _How to Visualize Your DuckDb Database with One Command (and Nothing to Install) _ ?

• Java and DuckDB
• jdbc driver on Maven Central
• Jdbc Classname : org.duckdb.DuckDBDriver
• Get a connection:

ro_prop.setProperty("duckdb.read_only", "true");
Connection conn_ro = DriverManager.getConnection("jdbc:duckdb:/tmp/my_database", ro_prop);

How to Reproduce

No response

Relevant log output

No response

SchemaCrawler Version

latest

Java Version

current LTS

Operating System and Version

Docker

Relational Database System and Version

DuckDb

JDBC Driver and Version

current

View on GitHub

[adriens]

Hi @sualeh : could you please provide us the killercoda version ?

[adriens]

.... also should be migrate/updated to Kilelrcoda LOL

[adriens]

Adrien SALES

@rastadidi

💡 Some cool stuff coming to @SchemaCrawler around @duckdb ✨
🕸️ 🧑‍🤝‍🧑 🦆
github.com/schemacrawler/…
#Database #DuckDB #opensource #dataScientist #DataScience

02:30 AM - 04 Feb 2023