Menu

archery-cli: Connect AI Tools to Your SQL Audit Platform
📰
0

archery-cli: Connect AI Tools to Your SQL Audit Platform

DEV Community·Roger Chien·about 1 month ago
#tByPHgdI
#ai#cli#showdev#sql#archery#select
Reading 0:00
15s threshold

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. prod=db_orders_prod , so you can type archery prod instead of the full name.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More