Link parkin’: sqlite-utils.
CLI tool and Python utility functions for manipulating SQLite databases
This library and command-line utility helps create SQLite databases from an existing collection of data.
Can’t believe I haven’t stashed Simon Willison’s insanely useful toolkit on this here blog. Makes it insanely easy to do stuff with sqlite databases from the command line and from within Python. For example
If you have data as JSON, you can use
sqlite-utils insert tablenameto insert it into a database. The table will be created with the correct (automatically detected) columns if it does not already exist.