csvkit

CLI

A suite of utilities for converting and working with CSV files.

Inspect, filter, join, and query CSV files from the command line

3 curated recipes · not yet executed by the harness#csv #data #sql #convert

Recipes

Curated from documentation and usage. Percentages are estimates, not measurements.

Get stats on a CSV file

~98% est.

csvstat data.csv

Cut specific columns

~99% est.

csvcut -c name,age data.csv

Query CSV with SQL

~95% est.

csvsql --query 'SELECT name FROM data WHERE age > 30' data.csv

pippip install csvkit

When to use: Working with CSV data without loading into a full database
Quick examples: csvstat data.csv
csvsql --query 'SELECT name FROM data WHERE age > 30' data.csv
csvcut -c name,age data.csv

curl -s https://clihub.com/api/tools/csvkit | jq '.agentHints.provenRecipes[] | {task, command, verified}'

Or call get_tool with slug csvkit on the MCP server at https://clihub.com/mcp.