菜单
Writes jq filters to query, reshape, aggregate, and pipeline JSON from APIs, CLIs, and logs. Use when parsing JSON, building jq one-liners, or explaining a jq expression. Not for in-memory DataFrames (pandas/polars), JSON Schema validation, or JavaScript Array.map as a jq substitute.
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
直接命令不会经过审查 Prompt；运行前请先检查来源。
npx skills add https://github.com/Kayforkind/skill-slice --skill jq命令会保持在同一行。复制前请横向滚动并检查完整内容。
想先保存到本地？可下载 SkillsMP 当前能够提供的文件。
Open a creative mind on the current context and invent a leap the user did not know to ask for — a feature, protocol, CLI, demo, architecture, product move, prose, experiment, or visual. Use when they run /awe-me or /inspire-me, say “awe me” or “inspire me”, want surprise, adjacent possible, make-strange, or are stuck recognizing instead of seeing. Not a brainstorm list. Not /better (quality pass). Not a feasibility grill.
Design, power, run, and analyze statistically valid A/B/N product experiments (sample size, duration, SRM, sequential monitoring, multiple comparisons). Use when pre-registering a test or reading out a controlled split. Not for event instrumentation, funnel diagnosis, wandb ML tracking (weights-and-biases), MVP smoke tests (mvp-scoping-and-risk-test), or RICE scoring (feature-prioritization-frameworks).
Runs Astropy BoxLeastSquares (BLS) on photometric time series: autopower/power grids, depth SNR, odd/even vetting. Use for periodic box-shaped transit dips or eclipsing binaries (Kovács 2002). Not for Transit Least Squares limb-darkened templates, Lomb-Scargle sinusoids, or non-photometric series. API: astropy.timeseries.BoxLeastSquares (Astropy 8).
正在显示 SKILL.md
| name | jq |
| description | Writes jq filters to query, reshape, aggregate, and pipeline JSON from APIs, CLIs, and logs. Use when parsing JSON, building jq one-liners, or explaining a jq expression. Not for in-memory DataFrames (pandas/polars), JSON Schema validation, or JavaScript Array.map as a jq substitute. |
| version | 1.0.1 |
| category | development |
| risk | safe |
| source | community |
| date_added | 2026-03-28 |
| tags | ["jq","json","shell","cli","data-transformation","bash"] |
| tools | ["claude","cursor","gemini"] |
jq is the standard CLI tool for querying and reshaping JSON. This skill covers practical, expert-level usage: filtering deeply nested data, transforming structures, aggregating values, and composing jq into shell pipelines. Every example is copy-paste ready for real workflows.
jq one-liners inside a bash script or PowerShell pipelinejq expression doesjq installed and on PATH. Verify with jq --version (requires ≥ 1.6 for walk, --stream stability).winget install jqlang.jq or scoop install jq. The binary is jq.exe; all filter syntax is identical across platforms.brew install jq or apt-get install jq.# Extract a field
echo '{"name":"alice","age":30}' | jq '.name'
# "alice"
# Nested access
echo '{"user":{"email":"a@b.com"}}' | jq '.user.email'
# Array index
echo '[10, 20, 30]' | jq '.[1]'
# 20
# Array slice
echo '[1,2,3,4,5]' | jq '.[2:4]'
# [3, 4]
# All array elements
| jq
PowerShell equivalent for the first example:
'{"name":"alice","age":30}' | jq '.name'
select# Keep only matching elements
echo '[{"role":"admin"},{"role":"user"},{"role":"admin"}]' \
| jq '[.[] | select(.role == "admin")]'
# Numeric comparison
curl -s https://api.github.com/repos/owner/repo/issues \
| jq '[.[] | select(.comments > 5)]'
# Test a field exists and is non-null
jq '[.[] | select(.email != null)]'
# Combine conditions
jq '[.[] | select(.active == true and .score >= 80)]'
# Extract a field from every array element
echo '[{"name":"alice","age":30},{"name":"bob","age":25}]' \
| jq '[.[] | .name]'
# ["alice", "bob"]
# Shorthand: map()
jq 'map(.name)'
# Build a new object per element
jq '[.[] | {user: .name, years: .age}]'
# Add a computed field
jq '[.[] | . + {senior: (.age > 28)}]'
# Rename keys
jq '[.[] | {username: .name, email_address: .email}]'
# Sum all values
echo '[1, 2, 3, 4, 5]' | jq 'add'
# 15
# Sum a field across objects
jq '[.[].price] | add'
# Count elements
jq 'length'
# Max / min
jq 'max_by(.score)'
jq 'min_by(.created_at)'
# reduce: custom accumulator
echo '[1,2,3,4,5]' | jq 'reduce .[] as $x (0; . + $x)'
# 15
# Group by field
jq 'group_by(.department)'
# Count per group
jq 'group_by(.status) | map({status: .[0].status, count: length})'
# String interpolation
jq -r '.[] | "\(.name) is \(.age) years old"'
# Format as CSV (no header)
jq -r '.[] | [.name, .age, .email] | @csv'
# Format as TSV
jq -r '.[] | [.name, .score] | @tsv'
# URL-encode a value
jq -r '.query | @uri'
# Base64 encode
jq -r '.data | @base64'
# List all top-level keys
jq 'keys'
# Check if key exists
jq 'has("email")'
# Delete a key
jq 'del(.password)'
# Delete nested keys from every element
jq '[.[] | del(.internal_id, .raw_payload)]'
# Recursive descent: find all values for a key anywhere in tree
jq '.. | .id? // empty'
# Get all leaf paths
jq '[paths(scalars)]'
# if-then-else
jq 'if .score >= 90 then "A" elif .score >= 80 then "B" else "C" end'
# Alternative operator: use fallback if null or false
jq '.nickname // .name'
# try-catch: skip errors instead of halting
jq '[.[] | try .nested.value catch null]'
# Suppress null output with // empty
jq '.[] | .optional_field // empty'
# Read from file
jq '.users' data.json
# Compact output (no whitespace) for further piping
jq -c '.[]' records.json | while IFS= read -r record; do
echo "Processing: $record"
done
# Pass a shell variable into jq
STATUS="active"
jq --arg s "$STATUS" '[.[] | select(.status == $s)]'
# Pass a number
jq --argjson threshold 42 '[.[] | select(.value > $threshold)]'
# Slurp multiple JSON lines into an array
jq -s '.' records.ndjson
# Multiple files: slurp all into one array
jq -s 'add' file1.json file2.json
# Null-safe pipeline from a command
kubectl get pods -o json | jq '.items[] | {name: .metadata.name, status: .status.phase}'
# GitHub CLI: extract PR numbers
gh pr list --json number,title | jq -r '.[] | "\(.number)\t\(.title)"'
# AWS CLI: list running instance IDs
aws ec2 describe-instances \
| jq -r '.Reservations[].Instances[] | select(.State.Name=="running") | .InstanceId'
# Docker: show container names and images
docker inspect $(docker ps -q) | jq -r '.[] | "\(.Name)\t\(.Config.Image)"'
PowerShell variable injection:
$STATUS = "active"
jq --arg s $STATUS '[.[] | select(.status == $s)]'
# Transpose an object of arrays to an array of objects
# Input: {"names":["a","b"],"scores":[10,20]}
jq '[.names, .scores] | transpose | map({name: .[0], score: .[1]})'
# Flatten one level
jq 'flatten(1)'
# Unique by field
jq 'unique_by(.email)'
# Sort, deduplicate and re-index
jq '[.[] | .name] | unique | sort'
# Walk: apply transformation to every node recursively
jq 'walk(if type == "string" then ascii_downcase else . end)'
# env: read environment variables inside jq
export API_KEY=secret
jq -n 'env.API_KEY'
-r (raw output) when passing jq results to shell variables or other commands to strip JSON string quotes.--arg / --argjson to inject shell variables safely — never interpolate shell variables directly into filter strings.map(f) over [.[] | f] for readability.-c (compact) for newline-delimited JSON pipelines; omit it for human-readable debugging.jq -n and literal input before embedding in scripts.empty to drop unwanted elements rather than filtering to null.jq is read-only by design — it cannot write files or execute commands.--arg.env or --arg to pass them indirectly.jq outputs null instead of the expected value. Check for typos in key names; use keys to inspect actual field names. JSON is case-sensitive.
Numbers are quoted as strings in the output. Use --argjson instead of --arg when injecting numeric values. --arg always creates a string.
Filter works in the terminal but fails in a script. Ensure the filter string uses single quotes in the shell to prevent variable expansion. Use jq '.field' not jq ".field". In PowerShell, use single quotes similarly: jq '.field'.
add returns null on an empty array. Use add // 0 or add // "" to provide a fallback default.
Streaming large files is slow. Use jq --stream or switch to jstream/gron for very large files (>100 MB).
PowerShell mangles single-quoted jq filters with $. PowerShell treats $ inside double quotes as variable expansion but respects single quotes literally. Always wrap jq filters in single quotes in PowerShell: jq '.[] | select(.price > $threshold)' works correctly because single quotes prevent expansion.
select(.field) with null field throws a type error. Guard with select(.field != null and .field > 5) or use ? to suppress: select(.field? > 5).
Verify jq is installed and working:
echo '{"test": true}' | jq '.test'
# Expected output: true
Verify version supports advanced functions:
jq --version
# Expected: jq-1.6 or jq-1.7+
Verify raw output mode strips quotes:
echo '{"name":"alice"}' | jq -r '.name'
# Expected output: alice (no quotes)
Verify variable injection works:
STATUS="active"
echo '[{"status":"active"},{"status":"inactive"}]' | jq --arg s "$STATUS" '[.[] | select(.status == $s)]'
# Expected output: [{"status": "active"}]
Verify --argjson for numeric injection:
echo '[{"value":10},{"value":50}]' | jq --argjson t 42 '[.[] | select(.value > $t)]'
# Expected output: [{"value": 50}]
bash-pro — Wrapping jq calls in robust shell scriptsbash-linux — General shell pipeline patternsgithub-automation — Using jq with GitHub CLI JSON output