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 14 of 44clear filters
#001
Today's HN top 10, ranked by score
curl -s "https://hacker-news.firebaseio.com/v0/topstories.json" \ | jq -r '.[0:30][]' \ | …
curljqxargs
›#002
Full-text search HN by keyword
curl -s "https://hn.algolia.com/api/v1/search?query=claude+code&tags=story&hitsPerPage=20"…
curljq
›#003
Top posts of any subreddit, today
curl -s -A "oneliner101/1.0" \ "https://www.reddit.com/r/LocalLLaMA/top.json?limit=25&t=da…
curljq
›#004
Any GitHub user's stars → markdown list
curl -s "https://api.github.com/users/torvalds/starred?per_page=50" \ | jq -r '.[] | "- [\…
curljq
›#005
Wikipedia article summary in 1 line
curl -s "https://en.wikipedia.org/api/rest_v1/page/summary/Functional_programming" \ | jq …
curljq
›#010
CSV → instant stats with Miller
mlr --csv stats1 -a mean,p90,max -f price -g category sales.csv | column -t
mlr
›#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
›#014
What's my IP and where is it?
curl -s https://ipapi.co/json/ \ | jq -r '"\(.ip)\t\(.city), \(.country_name)\t\(.org)\t\(…
curljq
›#015
Live currency rates, no API key
curl -s "https://open.er-api.com/v6/latest/USD" \ | jq '{base: .base_code, time: .time_las…
curljq
›#016
Most-starred repos in any language
curl -s "https://api.github.com/search/repositories?q=language:rust&sort=stars&order=desc&…
curljq
›#020
PyPI download stats for any package
curl -s "https://pypistats.org/api/packages/pandas/recent" \ | jq '.data'
curljq
›#021
Wikipedia page views over time
curl -s "https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia/all-…
curljq
›