Datasette is a nice way to connect to SQLIte and get summary information for a database with visuals.

Note down how to install, add the vega plugin and create some graphs.