mithrandie/csvq

Health v2 · maintenance only

Adoption not part of the score

1627 stars · 68 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

csvq is a command line tool written in Go that lets you query and manipulate CSV files using a SQL-like language, including select, insert, update, and delete operations. It supports transactions, variables, cursors, temporary tables, an interactive shell, and multiple file formats such as TSV, LTSV, fixed-length, JSON, and JSON Lines.

Use cases

• run SQL queries against CSV files from the command line
• update or delete records in a CSV file without a spreadsheet
• filter and join CSV data with SQL-like syntax
• process CSV files in batch scripts with transactions and variables
• query JSON Lines or TSV files with SQL
• interactively explore flat-file data in a shell
• share query scripts with coworkers across platforms

When to choose

• you want a single dependency-free binary for ad-hoc CSV querying
• your data fits in memory at spreadsheet scale
• you need to update, insert, or delete CSV records, not just read them
• you want transactions, cursors, or variables in flat-file processing
• you need to handle multiple encodings like UTF-16 or Shift_JIS

When to avoid

• you need to process very large datasets that exceed memory
• you need indexed or optimized query execution for speed
• you need a persistent database with concurrent access
• you need a library API rather than a CLI (though csvq-driver exists for Go)

Facets

cli-tool · maturity active

parser cli database csv json developer-tools files developer-tools cli cross-platform windows go sql-like-query csv-manipulation interactive-shell transactions tsv ltsv single-binary in-memory-processing command-line data-engineering csv linux macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="mithrandie/csvq")