Agent skill · Databases

average_session_step_duration_analyzer

Computes the average duration of actions or steps from session logs using Python (pseudo-streaming) or SQL. Handles duplicate steps by retaining the first timestamp and calculates duration based on the time difference to the next step.

ECNU-ICALKgithub.com/ECNU-ICALKGitHub ↗
claude-code
Install
npx skills add ECNU-ICALK/AutoSkill --skill average_session_step_duration_analyzer --agent claude-code

Same command for any agent — swap --agent for codex, cursor, copilot.

Facts
Files in the skill folder: 1
SKILL.md size: 3 KB
Bundled scripts: none
Version: 0.1.1
Path: SkillBank/ConvSkill/english_gpt4_8/average_session_step_duration_analyzer/SKILL.md
Open the folder on GitHub →
Where it comes from
Stars: 539
Language: Python

Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.

From the SKILL.md

# average_session_step_duration_analyzer Computes the average duration of actions or steps from session logs using Python (pseudo-streaming) or SQL. Handles duplicate steps by retaining the first timestamp and calculates duration based on the time difference to the next step. ## Prompt # Role & Objective You are a Data Engineer. Your task is to calculate the average duration of actions (or steps) from a session log. # Operational Rules & Constraints 1. **Input Format**: The input is a log source (file or table) containing `session_id`, `action` (or `step`), and `timestamp` (or `start_time`). 2. **Deduplication Logic**: If there are duplicate actions/steps within the same session, use only the first timestamp (earliest occurrence). 3. **Duration Calculation**: The duration of an action is defined as the time difference between its `timestamp` and the `timestamp` of the next action in the same session. 4. **Aggregation**: Maintain running totals (sum of durations and count) for each unique `action` type across all sessions to compute the average. # Implementation Strategies ## Python (Pseudo-Streaming) - **Constraint**: Do not use pandas. Use standard libraries (e.g., `datetime`, `co

What's inside
Steps it walks through
  1. Prompt
  2. Python (Pseudo-Streaming)
  3. SQL
  4. Triggers
More from AutoSkill
All skills →
About this skill
What does the average_session_step_duration_analyzer skill do?

Computes the average duration of actions or steps from session logs using Python (pseudo-streaming) or SQL. Handles duplicate steps by retaining the first timestamp and calculates duration based on the time difference to the next step.

How do I install it?

Run `npx skills add ECNU-ICALK/AutoSkill --skill average_session_step_duration_analyzer --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.

Where does this skill come from?

From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.

Is a popular skill a good skill?

Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.

Keep going