At my company, we use Archery for SQL audit and read-only queries against our databases.

Archery has a nice web UI, but our AI tools (Claude Code, Cursor, ChatGPT) cannot use a web UI. So I built archery-cli : a small psql -style command line client that wraps Archery's HTTP API. Both humans and AI agents can use it from the shell.

Why a CLI?

A CLI is the easiest way to bring AI tools into a workflow that already exists.

AI agents already know how to run shell commands.

A psql -style interface is familiar to engineers.

It does not bypass Archery — every query still goes through the same audit endpoint.

So we keep the audit flow, and the AI gets a tool it can actually use.

What it does

Run SELECT queries against any database that Archery exposes.

psql -style meta commands: \l , \dt , \d <table> , \dn .

Multiple output formats: aligned table (default), CSV, JSON, and expanded ( -x ) for wide rows.

DB name aliases, e.g.…