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

56 of 250 · 194 to go · finish line July 31, 2026 🏁

last updated2026-05-25

Filter by tier

all self-contained llm-cli duckdb apify aws

Filter by tool

apify awk aws claude curl duckdb gemini head jq kubectl llm mlr parallel sort tail uniq xargs

showing 7 of 56clear 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'"

Aggregate K8s Pod Counts by Namespace and Phase

kubectl get pods -A -o json | \ jq -c '.items[]' | \ duckdb -c "SELECT metadata.namespace,…

kubectljqduckdb

Analyze Top Kubernetes Warning Events with DuckDB

kubectl get events -A --field-selector type=Warning -o json | jq -c '.items[]' | duckdb -c…

kubectljqduckdb