agentskillexchange 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...
Extracted from upstream docs: https://raw.githubusercontent.com/simonw/sqlite-utils/HEAD/README.md