sqlite-utils

Agent-readyData & DBDatabase

SQLite automation, csv/json imports, and data transforms from the terminal.

SQLite automation, csv/json imports, and data transforms from the terminal. Built by Simon Willison. Supports structured output — good for scripts and agents.

Task fit

sqlite automation, csv/json imports, and data transforms from the terminal.

Lane

Inspect schemas, run safe queries, and understand your data fast.

Operator brief

Use sqlite-utils for sqlite automation, csv/json imports, and data transforms from the terminal.

Run `sqlite-utils insert data.db items items.json --pk id` and see what comes back.

Repository family

Simon Willison

First trust check

sqlite-utils responds and is ready for local database work.

Safe first loop

Install, verify, then run one real command.

Safe database loop

Install command

$ pipx install sqlite-utils

Operator pack

Copy or export the working notes for this CLI before handing it to an agent.

Verify

$ sqlite-utils --help

sqlite-utils responds and is ready for local database work.

First real command

$ sqlite-utils insert data.db items items.json --pk id

First steps

01Install sqlite-utils.
02Run `sqlite-utils --help` first.
03Start with `sqlite-utils insert data.db items items.json --pk id`.
04Install a CLI that matches your database engine.

When to use / hold off when

Best for

sqlite automation, csv/json imports, and data transforms from the terminal.

Use this when

You want databases you can script with structured output.

Hold off when

You don't work with databases.

Trust and constraints

automation-ready95/100

Install readyAutomation-ready

JSON outputYes

Non-interactiveYes

CI-friendlyYes

Why operators pick it

sqlite-utils fits data & db well, especially for sqlite automation, csv/json imports, and data transforms from the terminal.
145 homebrew installs (30d).
Good for scripts and agents.

Constraints