sqlite-utils

scriptabledatabasepipx

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

$ pipx install sqlite-utils

One-liner to try

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

Agent pack

Copy into an agent

A markdown-ready setup brief with install, verify, safe starting commands, and guardrails for AI agents.

Open .md

Readiness

Great for agents · 75/100

Verify

sqlite-utils --version

Agent URL

/cli/sqlite-utils/agent.md

Quick reference

Installpipx install sqlite-utils

Verifysqlite-utils --version

First commandsqlite-utils insert data.db items items.json --pk id

About

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

Example workflow

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

Alternatives worth considering

prisma

Schema design, migrations, and type-safe db workflows from the terminal.

drizzle-kit

Migrations, schema diffs, and typescript db tooling from the terminal.

usql

Universal SQL shell, multiple databases, and db scripts from the terminal.