# Analyze Sessions > Analyze Claude Code and Codex session history for cross-session trends, recurring patterns, and automation opportunities - Skill: `georgeqle/analyze-sessions-8` (Agent Skill) - Install (CLI): `npx skillmds@latest add georgeqle/analyze-sessions-8` - Raw SKILL.md: https://api.skillmd.com/api/skills/georgeqle/analyze-sessions-8/raw - Safety review: pending (external: skill-scanner PASS, skillspector PASS) - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Data & Analytics - Author: GeorgeQLe (https://skillmd.com/u/georgeqle) - Updated: 2026-09-09 - Page: https://skillmd.com/skills/georgeqle/analyze-sessions-8 --- # Analyze Sessions Use this skill when the user wants a data-driven breakdown of local Claude Code and Codex usage history across conversations, sessions, tools, projects, or time periods. This skill is for broad trend analysis, repeated prompt patterns, recurring frustrations, workflow evolution, automation opportunities, and skill performance over multiple sessions. If the user asks about one current session, one mistake, one correction, one repo incident, or one skill failure, route to `/session-triage` instead of handling the incident here. ## Inputs - Default Claude history file: `~/.claude/history.jsonl` - Default Codex prompt history file: `~/.codex/history.jsonl` - Default Codex rich session root: `~/.codex/sessions/**/*.jsonl` - Optional paths from the user. Accept history files, session directories, repository directories, or exported logs. - Optional filters such as repo path, project name, date range, command/skill name, exact phrase, or trend question. ## Process 1. Confirm the request is broad enough for cross-session analysis: - Continue when the user asks for overall history, usage breakdowns, repeated prompts, recurring workflow issues, cross-tool changes, automation opportunities, or performance trends across multiple sessions. - Route to `/session-triage` when the user asks to investigate one immediate issue, correction, failed run, session, repo incident, or skill mistake. - When a request contains both a single incident and recurrence questions, recommend `/session-triage` first for the incident and use this skill afterward for frequency or trend evidence. 2. Read the full available history for the selected scope, not a sample. 3. Use a scriptable approach for scale. Prefer streaming or line-by-line processing for large files. 4. Normalize records into one common shape: - `source`: `claude` or `codex` - `timestamp` - `session_id` - `project` or `cwd` - `text` - optional metadata such as git branch, repository URL, model, provider, and CLI version 5. Parse Claude history: - `~/.claude/history.jsonl` lines contain user messages with fields such as `display`, `timestamp` in milliseconds, `project`, `sessionId`, and `pastedContents`. 6. Parse Codex history: - `~/.codex/history.jsonl` lines contain compact user prompts with `text`, `ts` in seconds, and `session_id`. - `~/.codex/sessions/**/*.jsonl` lines contain richer rollout records. Use `session_meta.payload.id` to map session IDs to `cwd`, git metadata, CLI version, and model/provider. - Include user `response_item` records only when they represent user messages. Exclude developer/system/base instruction payloads from prompt-pattern counts. - Prefer compact Codex prompt history for user prompt counts, enriched with rollout metadata. Use rollout user records only for prompts missing from compact history or for metadata checks. 7. Extract and report: - Project breakdown: top projects by message volume with percentages. - Source breakdown: Claude vs. Codex message/session counts and date ranges. - Activity categories and recurring workflow themes. - Exact and fuzzy repeated prompt patterns. - Common multi-step workflow sequences. - Cross-tool differences, including workflows that moved from Claude to Codex or still require different commands. - Skill performance patterns across multiple invocations, including recurring corrections or repeated bad recommendations when supported by scoped history evidence. 8. For each major pattern, recommend the best automation shape: - Skill: repeatable workflow with a stable sequence. - Agent: complex exploratory or autonomous work. - Plugin/integration: external-service or persistent-connection workflow. - Standing instruction/project convention: behavior that should always apply. - `/session-triage`: one concrete incident needs verification before a durable fix is designed. ## Remediation-Ready Handoffs When a broad verified workflow gap routes to `/targeted-skill-builder` (skill-dev pack): - Emit one final next route using the current runner command convention only: `/targeted-skill-builder` (skill-dev pack) ``. - The command argument must name the workflow gap and likely owner surface, not just `analyze-sessions` or `targeted-skill-builder`; for example: `/targeted-skill-builder` (skill-dev pack) `run post-doc-edit validation and lessons capture gate`. - In the recommendation table or next-work sentence, name the likely owner surface and one validation expectation, such as a layer1 contract test, focused benchmark smoke, or skill-specific validation command. If ownership is uncertain, state which evidence would decide it instead of guessing. - Do not put both Claude slash and Codex dollar commands in the final handoff. It is fine to mention the counterpart route in cross-tool analysis, but the final `Recommended next command:` must be one Claude-native command. - Distinguish explicit evidence from inference when labeling source, runner, project, or owner. Use language such as "explicitly says", "implies", or "not stated" rather than assigning runner ownership to sparse logs. ## Output Produce a structured report with: - Overview stats: total messages, sessions, date range, and top projects. - Source comparison: Claude vs. Codex totals, top projects, command usage, and recent trend. - Categorized patterns with counts and real examples from history. - Skill performance trends when requested or visible in the scoped data. - Ranked recommendations table: pattern, frequency, recommendation type, suggested name/description. - Highest-impact section: top 5 automations by avoided manual prompts. - Recommended next skill: `/session-triage` for any concrete incident that needs verification, `/targeted-skill-builder` (skill-dev pack) `` for a broad verified workflow gap, or `none` when no follow-up is justified. When recommending `/targeted-skill-builder` (skill-dev pack), include the likely owner surface and validation expectation in the report. ## Constraints - Process the entire available history for broad usage analysis, not just a sample. - Use actual message examples from the history, not hypothetical ones. - Be specific about frequencies; show exact counts where possible. - Group near-identical prompts together. - Deduplicate Codex prompts that appear in both `~/.codex/history.jsonl` and rollout files by `(session_id, timestamp, normalized text)` where possible. - Do not include system, developer, base instruction, or tool output text in repeated-prompt counts. - Do not diagnose one immediate issue here; route it to `/session-triage`. - Do not create or modify GitHub Actions workflows. - If one source is missing or unreadable, report that clearly and continue with the other source instead of guessing. - When recommending a skill from another pack, verify the pack is installed via `.agents/project.json` `enabled_packs`. If not installed, prepend `/pack install ` to the recommendation. ## Alignment Page When this skill produces durable deliverables (research, specs, plans, reports, prototypes, or any document output), build a full-depth HTML alignment page following `ALIGNMENT-PAGE.md` in this skill's directory. Output: `alignment/analyze-sessions-{topic}.html`. ## Default Shipping Contract Follow the shared shipping contract convention in CLAUDE.md.