The 250 one-liners that built
data engineering in 2026.
Hand-curated shell pipelines combining apify · jq · claude · gemini · duckdb · groq · miller. Every entry runs as-is on a fresh laptop. Copy. Run. Learn.
apifyjqclaudegeminiduckdbgroqmillerparallel
44 of 250 · 206 to go · finish line July 31, 2026 🏁
last updated2026-05-11
Filter by tier
Filter by tool
showing 5 of 44clear filters
#011
DuckDB: SQL over a CSV in one shot
duckdb -c " SELECT category, AVG(price) AS avg_price, QUANTILE_CONT(price, 0.9…
duckdb
›#012
JSON from curl → DuckDB analysis via /dev/stdin
curl -s "https://hn.algolia.com/api/v1/search?query=duckdb&hitsPerPage=100" \ | jq '.hits'…
curljqduckdb
›#013
DuckDB: query a remote Parquet over HTTPS
duckdb -c " INSTALL httpfs; LOAD httpfs; SELECT l_returnflag, l_linestatus, SUM(l_quantity…
duckdb
›#017
DuckDB on NYC taxi public Parquet
duckdb -c " INSTALL httpfs; LOAD httpfs; SELECT passenger_count, ROUND(AVG(fare_amount), 2…
duckdb
›#018
DuckDB: peek at any CSV's schema
duckdb -c "DESCRIBE FROM 'data.csv'"
duckdb
›