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

Browse the list ↓🎲 Pick one at random

44 of 250 · 206 to go · finish line July 31, 2026 🏁

last updated2026-05-11

Filter by tier

all self-contained llm-cli duckdb apify aws

Filter by tool

apify awk aws claude curl duckdb gemini jq llm mlr parallel xargs

showing 5 of 44clear filters

DuckDB: SQL over a CSV in one shot

duckdb -c " SELECT category, AVG(price) AS avg_price, QUANTILE_CONT(price, 0.9…

JSON from curl → DuckDB analysis via /dev/stdin

curl -s "https://hn.algolia.com/api/v1/search?query=duckdb&hitsPerPage=100" \ | jq '.hits'…

DuckDB: query a remote Parquet over HTTPS

duckdb -c " INSTALL httpfs; LOAD httpfs; SELECT l_returnflag, l_linestatus, SUM(l_quantity…

DuckDB on NYC taxi public Parquet

duckdb -c " INSTALL httpfs; LOAD httpfs; SELECT passenger_count, ROUND(AVG(fare_amount), 2…

DuckDB: peek at any CSV's schema

duckdb -c "DESCRIBE FROM 'data.csv'"