reporting-pipelines — Claude Code skill: CSV/JSON/Markdown reports
A skill that fixes one pattern for report exports: collect data, normalize it, write CSV/JSON/Markdown with timestamped names into reports/.
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a claude-codeWhat reporting-pipelines does
The skill lays out a repeatable reporting flow. A CLI or script produces structured data, then the output goes to CSV, JSON or Markdown with a date suffix in the filename and lands in reports/ or tests/results/. Five steps cover it: collect base data, normalize into rows and records, export with timestamps, print key metrics to stdout, store the files.
Two worked examples come with it. gitflow-analytics runs with a config and a week count, emitting CSV plus a Markdown narrative report with a date suffix. The script edgar/scripts/create_csv_reports.py reads a JSON results file and writes three outputs: executive_compensation_<timestamp>.csv, top_25_executives_<timestamp>.csv and company_summary_<timestamp>.csv; it uses pandas for sorting and percentile calculations.
Naming rules are plain: YYYYMMDD or YYYYMMDD_HHMMSS suffixes, one output directory per repo, an explicit prefix such as narrative_report_. When a file never shows up, check whether the output directory exists and is writable — that is the usual culprit. For large CSVs the skill advises filtering or aggregating before export and keeping a summary CSV around for a quick read.
What it helps with
- export a timestamped CSV report from script output
- standardize export paths and filenames across repos
- sort rows and compute percentiles before writing the file
- print key metrics to stdout without opening the report
- split one JSON results file into several themed CSVs
Example prompts for the agent
- build the report for the last 8 weeks and drop a timestamped CSV into reports/
- export results to CSV and Markdown with YYYYMMDD_HHMMSS suffixes
- read the JSON results file and write three summary CSVs into tests/results/
How to install reporting-pipelines
1Skills CLI (Vercel)
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a claude-code2Manually: put the files in place
~/.claude/skills/reporting-pipelines/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/reporting-pipelines/
1Skills CLI (Vercel)
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a codex2Manually: put the files in place
.agents/skills/reporting-pipelines/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a cursor2Manually: put the files in place
.cursor/skills/reporting-pipelines/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install bobmatnyc/claude-mpm-skills reporting-pipelines2Manually: put the files in place
.github/skills/reporting-pipelines/SKILL.md1Skills CLI (Vercel)
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a gemini-cli2Platform CLI
gemini skills install https://github.com/bobmatnyc/claude-mpm-skills --path universal/data/reporting-pipelinesManually: put the files in place
.devin/skills/reporting-pipelines/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about reporting-pipelines
How do I install reporting-pipelines in Claude?
Run npx skills add bobmatnyc/claude-mpm-skills --skill reporting-pipelines -a claude-code. The skill lands at ~/.claude/skills/reporting-pipelines/SKILL.md.
What does reporting-pipelines do?
It defines a reporting flow: collect data, normalize it, export CSV/JSON/Markdown with timestamped filenames, summarize metrics, and store outputs in reports/ or tests/results/.
What does create_csv_reports.py need to run?
It reads a JSON results file and uses pandas for sorting and percentile calculations. It writes three CSVs: executive compensation, top 25 executives, and a company summary.
Source text
SKILL.md · MIT
---
name: reporting-pipelines
description: Reporting pipelines for CSV/JSON/Markdown exports with timestamped outputs, summaries, and post-processing.
user-invocable: false
disable-model-invocation: true
version: 1.0.0
category: universal
author: Claude MPM Team
license: MIT
progressive_disclosure:
entry_point:
summary: "Generate CSV/JSON/markdown reports with timestamped filenames and summary outputs."
when_to_use: "Building reporting flows, exporting analytics results, or standardizing CSV/JSON/markdown outputs across projects."
quick_start: "1. Run the CLI that produces base data 2. Export CSV/JSON/markdown with timestamps 3. Save to reports/"
tags:
- reporting
- csv
- json
- markdown
- analytics
---
# Reporting Pipelines
## Overview
Your reporting pattern is consistent across repos: run a CLI or script that emits structured data, then export CSV/JSON/markdown reports with timestamped filenames into `reports/` or `tests/results/`.
## GitFlow Analytics Pattern
```bash
# Basic run
gitflow-analytics -c config.yaml --weeks 8 --output ./reports
# Explicit analyze + CSV
gitflow-analytics analyze -c config.yaml --weeks 12 --output ./reports --generate-csv
```
Outputs include CSV + markdown narrative reports with date suffixes.
## EDGAR CSV Export Pattern
`edgar/scripts/create_csv_reports.py` reads a JSON results file and emits:
- `executive_compensation_<timestamp>.csv`
- `top_25_executives_<timestamp>.csv`
- `company_summary_<timestamp>.csv`
This script uses pandas for sorting and percentile calculations.
## Standard Pipeline Steps
1. **Collect base data** (CLI or JSON artifacts)
2. **Normalize** into rows/records
3. **Export** CSV/JSON/markdown with timestamp suffixes
4. **Summarize** key metrics in stdout
5. **Store** outputs in `reports/` or `tests/results/`
## Naming Conventions
- Use `YYYYMMDD` or `YYYYMMDD_HHMMSS` suffixes
- Keep one output directory per repo (`reports/` or `tests/results/`)
- Prefer explicit prefixes (e.g., `narrative_report_`, `comprehensive_export_`)
## Troubleshooting
- **Missing output**: ensure output directory exists and is writable.
- **Large CSVs**: filter or aggregate before export; keep summary CSVs for quick review.
## Related Skills
- `universal/data/sec-edgar-pipeline`
- `toolchains/universal/infrastructure/github-actions`
© Claude MPM Team · MIT · bobmatnyc/claude-mpm-skills