Awesome

CSV Query - Use SQL to query CSV data

CSV Query is a command line tool that allows you to run SQL queries on data stored in CSV files.

For example:

$ csvq --select "count(*)" --where "name='Jakob'" sample.csv
count(*)
--------
       1

Assumptions

The first row of data is assumed to be headers.

All fields are created as VARCHAR(255), which hopefully works for most cases.

Behind the scenes

CSV Query loads the CSV data into an in-memory SQLite database. Thus, the SQL queries need to be SQLite-flavored where applicable.

Alternative/related projects

• csvq.py - Python variant that does almost the same thing
• CSVql - A query language for CSV files

License

Licensed under the MIT License. See LICENSE for details.