csvq

SQL-like query language for csv

Runs as csvq|macOS, Linux|mithrandie.github.io

Command form

ai-draft · 2 tasks · 9 fields

Run one SQL-like query (or a script file) against CSV and other delimited files. Encoding, locale, subcommands and interactive mode are left out.

Opens the form; the finished command lands at your prompt, unrun

Run in Otty

otty gui csvq

Run a query on CSV filesExample values, fixed in this page — nothing here reaches a terminal

Basic

Query*

string

Output format

10 choicesenum

Directory of data files

directory

Advanced

Files have no header row

--no-header

TasksEach one presets the form for one job

Query CSV files

queryformatrepositoryno_header

Run a script file

sourceformatoutrepository

ParametersOnly these flags are editable in the form

Query

A SQL-like statement, quoted. Leave empty when loading statements from a source file.
string · positional 0

Source file

Load the query or statements from a file.
path

--source-s

Output format

enum

--format-fCSVTSVFIXEDJSONJSONLLTSVGFMORGBOXTEXT

Output file

Export select results to a file instead of standard output.
path

--out-o

Directory of data files

path

--repository-r

Input delimiter

string

--delimiter-d,\t;

Output delimiter

string

--write-delimiter-D

Files have no header row

boolean

--no-header-n

Quiet

boolean

--quiet-q

SourcesEvery flag above is checked against these

manual

csvq [options] [subcommand] ["query"|argument] --delimiter value, -d value --format value, -f value --no-header, -n --out FILE, -o FILE --quiet, -q --repository PATH, -r PATH --source FILE, -s FILE --write-delimiter value, -D value (The manual page typesets the double dash as an en dash.) value(case ignored): CSV, TSV, FIXED, JSON, JSONL, LTSV, GFM, ORG, BOX…

manual2026-10-27

mithrandie.github.io

Before it fills your prompt, Otty checks the installed csvq against its version. A form that does not match your version is not offered.