Review summary with quotes: pros and cons backed by review IDs

Summarize user-supplied reviews (CSV, JSON or text) into pros, cons and themes, every point backed by verbatim quotes with review IDs, plus a rating distribution and a quote checker.

ClaudeHermes AgentCodexCursorMIT (modify, redistribute and use commercially)Python

What it does

Summarizes customer reviews with evidence instead of guesswork. It never invents reviews or quotes.

  • Reads CSV, TSV, JSON, JSONL or plain text (blank-line separated) and detects ID, rating, text and date columns (assigns R1, R2... when IDs are missing)
  • Rating distribution and mean, plus positive / mixed / negative counts
  • Counts 14 themes (price, quality, defects, size, ease of use, noise, delivery, instructions, support and more) with Japanese and English keyword lists, listing review IDs and verbatim sentence quotes per theme
  • Verifies that every "quote" [ID] in the finished summary really exists in the cited review and fails loudly on missing quotes or unknown IDs

How to use

python scripts/review_themes.py analyze reviews.csv --out themes.json --md themes.md
python scripts/review_themes.py verify summary.md --reviews reviews.csv

Copy references/themes.json, add product-specific keywords and pass it with --themes. Samples are in examples/.

Requirements

  • Python 3 (standard library only)
  • An agent such as Claude, Codex, Hermes Agent or Cursor

Caveats

  • Keyword counting misses paraphrases and can count negations ("not noisy"); the agent reads the quotes before concluding.
  • It does not scrape reviews; use data you are allowed to use.
  • Reviewer personal data is kept out of the summary. Follow each platform's rules when quoting publicly.

How to install

  1. Unzip the downloaded file (it contains a review-summary-with-quotes/ folder with SKILL.md).
  2. Copy the whole folder into your agent's skills folder.
    • Claude: ~/.claude/skills/ (per project: .claude/skills/)
    • Hermes Agent: ~/.hermes/skills/
    • Codex: ~/.agents/skills/ / Cursor: ~/.cursor/skills/
    • Claude app (claude.ai): upload the ZIP in Customize → Skills
  3. Restart the agent and check that the skill appears in its skill list.

Step-by-step install for Windows / Mac and each agent

Seller

AI Skill Market (official)

44 published skills

Seller profile and all skills