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
56 of 250 · 194 to go · finish line July 31, 2026 🏁
last updated2026-05-25
Filter by tier
Filter by tool
showing 20 of 56clear 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 -fsSL -A 'Mozilla/5.0 oneliner101' https://ifconfig.co/json \ | jq -r '"\(.ip)\t\(.ci…
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
›#045
Analyze yesterday's S&P 500 performance with Claude
curl -fsSL -A 'Mozilla/5.0' "https://query1.finance.yahoo.com/v8/finance/chart/SPY?range=5…
curljqclaude
›#046
Summarize Top Anthropic Reddit News with Claude
curl -s -A "cli-bot/1.0" "https://www.reddit.com/r/Anthropic/top.json?limit=20&t=month" \ …
curljqclaude
›#051
Find Pods Missing Resource Limits
kubectl get pods -A -o json | jq -r '.items[] | select(any(.spec.containers[]; .resources.…
kubectljqsort
›#052
List and Sort Running Container Images by Frequency
kubectl get pods -A -o json | jq -r '.items[].spec.containers[].image' | sort | uniq -c | …
kubectljqsortuniq
›#054
Find Top 10 Restarting Kubernetes Containers
kubectl get pods -A -o json | jq -r '.items[] | select(.status.containerStatuses != null) …
kubectljqsorthead
›#056
Find all OOMKilled pods across a Kubernetes cluster
kubectl get pods -A -o json | jq -r '.items[] | select(.status.containerStatuses[]?.lastSt…
kubectljq
›