Jq data processing

Skill cxcscmu/SkillLearnBench/skills/b1-one-shot-gemini-3-flash-preview/github-repo-analytics/jq-data-processing

Process JSON data from GitHub CLI using jq to calculate metrics like average merge times, counts, and top contributors.From its SKILL.md

Install

npx -y skills add cxcscmu/SkillLearnBench --skill jq-data-processing

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

SKILL.md

1.1 KB, 273 tokens by cl100k_base, as published. Nobody here has run it

JQ Data Processing for Repo Stats

This skill provides jq patterns for common repository metrics calculations.

Common Patterns

Counting and Filtering

Count total items:

jq 'length' data.json

Filter for merged PRs:

jq '[.[] | select(.mergedAt != null)]' prs.json

Calculating Average Merge Time

Compute average merge time in days (assuming createdAt and mergedAt are ISO8601 strings):

jq '[.[] | select(.mergedAt != null) | ((.mergedAt | fromdateiso8601) - (.createdAt | fromdateiso8601)) / 86400] | add / length | round * 10 / 10' prs.json

Note: Dividing by 86400 converts seconds to days.

Finding Top Contributor

Identify the author with the most entries:

jq -r '[.[] | .author.login] | group_by(.) | sort_by(-length) | .[0][0]' prs.json

Complex Label Search

Count items where any label contains "bug":

jq '[.[] | select(.labels[].name | contains("bug"))] | length' issues.json

What ships with it

Read from the repository

Just SKILL.md. No reference files, no scripts.