sqlite-utils Python CLI for SQLite Database Manipulation
sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line.
Installation
Install or set up from the source-backed instructions:
pip install sqlite-utils