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

Use the upstream install or setup path that matches your environment:

• pip install sqlite-utils
• brew install sqlite-utils

Requirements and caveats from upstream:

• 
• Python CLI utility and library for manipulating SQLite databases.
• You can also import sqlite_utils and use it as a Python library like this:

Basic usage or getting-started notes:

• Run in-memory SQL queries, including joins, directly against data in CSV, TSV or JSON files and view the results

• Configure SQLite full-text search against your database tables and run search queries against them, ordered by relevance

• Run transformations against your tables to make schema changes that SQLite ALTER TABLE does not directly support, such as changing the type o...

• Source: https://github.com/simonw/sqlite-utils

• Extracted from upstream docs: https://raw.githubusercontent.com/simonw/sqlite-utils/HEAD/README.md

Source

• Agent Skill Exchange