# OpenCLI Agent Pack: sqlite-utils

Use this when an AI agent needs to work with `sqlite-utils`.

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

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

## Agent readiness
Great for agents (75/100)
- Structured output is available for parsing.
- Supports non-interactive/scripted use.
- Works well in CI or repeatable automation.

## Install
```sh
pipx install sqlite-utils
```

## Verify before real work
```sh
sqlite-utils --version
```
Expected signal: sqlite-utils responds locally and is ready for the first real command.

## Safe starting commands
```sh
sqlite-utils --version
```

```sh
sqlite-utils insert data.db items items.json --pk id
```

## Guardrails for agents
- Start read-only, then ask before mutations.

## Suggested agent instruction
You may use sqlite-utils (`sqlite-utils`) for sqlite automation, csv/json imports, and data transforms from the terminal.. First install it if missing, then run the verify command. Start with read-only or inspection commands. Summarize what you found before changing anything. Ask for confirmation before commands that mutate remote state, spend money, deploy, delete data, merge code, or expose secrets.

Source: OpenCLI