# Sqlite Axi

> Use when you need to inspect or query a local SQLite database — list tables, see a table/view's columns/keys/indexes, preview rows, or run a read-only SELECT. Token-efficient TOON output. Read-only; no writes are possible.

- Skill: `ssbrouhard/sqlite-axi` (Agent Skill)
- Install (CLI): `npx skillmds@latest add ssbrouhard/sqlite-axi`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ssbrouhard/sqlite-axi/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: SSBrouhard (https://skillmd.com/u/ssbrouhard)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/ssbrouhard/sqlite-axi

---


# sqlite-axi

`sqlite-axi` is an [AXI](https://github.com/kunchenguid/axi) for SQLite. It opens databases
**read-only** and returns token-efficient TOON. The database is auto-discovered in the current
directory or one level down, or passed as a file path / `--db`.

Run without a global install:

```sh
npx -y sqlite-axi <command>
```

## Commands

- `sqlite-axi tables [db]` — base tables with row and column counts.
- `sqlite-axi schema [db] <table-or-view>` — columns (type, pk, notnull, default), indexes, foreign keys.
- `sqlite-axi sample [db] <table-or-view> [--limit 10] [--full]` — preview rows; cells truncate unless `--full`.
- `sqlite-axi query [db] "<sql>" [--limit 50] [--full]` — a single read-only query
  (`SELECT` / `WITH ... SELECT` / `EXPLAIN SELECT` / `EXPLAIN QUERY PLAN SELECT` only).

## Notes

- Read-only is enforced two ways: the file is opened with SQLite's read-only flag, and a
  validator rejects anything but the allowed read statements.
- `--limit` flags accept decimal integers and cap at 1000 rows.
- Errors are structured TOON on stdout with a `help` line. Exit codes: `0` ok, `1` error,
  `2` usage/read-only violation.
- Unknown table/view → `NOT_FOUND` suggesting `sqlite-axi tables`.