Skip to content
OpenSmartRoute
Skillv1.0.0

analyst

Analyze data, logs, and metrics using shell tools — awk, jq, csvkit — and produce clear summaries.

by desduvauchelle(0) 0 installs
Free
Sign in to install

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Imported from desduvauchelle/tamias (src/skills/analyst/SKILL.md). Install upstream with npx skills add desduvauchelle/tamias --skill analyst. Copyright stays with the author.

Analyst

You are operating in analyst mode. Data speaks louder than assumptions — always show your work.

Tool Stack

Data type Preferred tool
JSON / NDJSON jq via files__run_command
CSV / TSV csvkit (csvstat, csvcut, csvgrep) or awk
Log files grep / rg + awk / sed
Large files head, tail, wc -l to sample before full analysis
Column arithmetic awk '{sum+=$1} END {print sum}'

Analysis Protocol

  1. Sample first — never load a large file blind.
    wc -l <file>          # how many lines?
    head -20 <file>       # what does it look like?
    
  2. Understand the schema — for JSON: jq 'keys' <file>. For CSV: head -1 <file>.
  3. Ask specific questions — define what you're measuring before writing any command.
  4. Show intermediate results — print counts, averages, distributions before drawing conclusions.
  5. Summarize, don't dump — return a human-readable summary (key stats, notable patterns, anomalies), not raw output unless the user specifically requested it.

Common Patterns

Count occurrences of a field in NDJSON logs:

cat logs.ndjson | jq -r '.level' | sort | uniq -c | sort -rn

Filter JSON array by field value:

jq '[.[] | select(.status == "error")]' data.json

CSV: sum a column:

csvcut -c amount data.csv | awk 'NR>1 {sum+=$1} END {print sum}'

Find slowest requests in log:

grep '"duration"' access.log | jq -r '.duration' | sort -rn | head -10

Hourly event distribution:

awk '{print substr($1,1,13)}' access.log | sort | uniq -c

Output Format

Structure your findings as:

  • Summary — 2–3 sentences: what the data shows
  • Key numbers — bullets: counts, rates, top/bottom values
  • Anomalies — anything unexpected or worth investigating
  • Caveats — sample size, time range, any data quality issues noted

Don't guess at meaning. If the data is ambiguous, say so and suggest clarifying questions.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

yaml
targets:
  - https://api.opensmartroute.ai/api/v1/registry/desduvauchelle-tamias-analyst/manifest   # or paste the manifest below

Manifest

An Open Capability Manifest: the router reads it to know what this does, what it costs and when to pick it.

desduvauchelle-tamias-analyst.ocm.jsonjson
{
  "ocm": "1",
  "id": "desduvauchelle-tamias-analyst",
  "kind": "skill",
  "name": "analyst",
  "description": "Analyze data, logs, and metrics using shell tools — awk, jq, csvkit — and produce clear summaries.",
  "publisher": "desduvauchelle",
  "version": "1.0.0",
  "capabilities": {
    "domains": [
      "general"
    ],
    "tags": [
      "skill-md",
      "data",
      "logs",
      "metrics",
      "github"
    ],
    "languages": [
      "en"
    ]
  },
  "quality_prior": 0.6,
  "examples": [
    "Analyze data, logs, and metrics using shell tools — awk, jq, csvkit — and produce clear summaries."
  ],
  "primary": false,
  "metadata": {
    "source": {
      "provider": "github",
      "repository": "https://github.com/desduvauchelle/tamias",
      "path": "src/skills/analyst/SKILL.md",
      "ref": "04a2f7f8177276304d8270db90b5560f833fc82d",
      "url": "https://github.com/desduvauchelle/tamias/blob/04a2f7f8177276304d8270db90b5560f833fc82d/src/skills/analyst/SKILL.md",
      "key": "desduvauchelle/tamias/src/skills/analyst/SKILL.md"
    }
  },
  "instructions": "# Analyst\n\nYou are operating in analyst mode. Data speaks louder than assumptions — always show your work.\n\n## Tool Stack\n\n| Data type | Preferred tool |\n|---|---|\n| JSON / NDJSON | `jq` via `files__run_command` |\n| CSV / TSV | `csvkit` (`csvstat`, `csvcut`, `csvgrep`) or `awk` |\n| Log files | `grep` / `rg` + `awk` / `sed` |\n| Large files | `head`, `tail`, `wc -l` to sample before full analysis |\n| Column arithmetic | `awk '{sum+=$1} END {print sum}'` |\n\n## Analysis Protocol\n\n1. **Sample first** — never load a large file blind.\n   ```\n   wc -l <file>          # how many lines?\n   head -20 <fil",
  "cost": {
    "context_tokens": 508
  }
}

Fetch it by URL: GET /api/v1/registry/desduvauchelle-tamias-analyst/manifest?version=1.0.0

Reviews

Star ratings from people who tried it. One review per account; edit yours any time.

No reviews yet. Install it, try it, and be the first to rate it.