Skills last30days-weekly

Name: last30days-weekly
Author: openclaw

Weekly OpenClaw Skills intelligence. Tracks trending ClawHub skills via API snapshots, researches community buzz on Reddit/X/Web, generates YouTube-ready briefings. Run daily for snapshot accumulation, weekly for full report.

install

source · Clone the upstream repo

git clone https://github.com/openclaw/skills

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/openclaw/skills "$T" && mkdir -p ~/.claude/skills && cp -r "$T/skills/ademczuk/skillmetricscraper/openclaw-skill/last30days-weekly" ~/.claude/skills/openclaw-skills-last30days-weekly && rm -rf "$T"

OpenClaw · Install into ~/.openclaw/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/openclaw/skills "$T" && mkdir -p ~/.openclaw/skills && cp -r "$T/skills/ademczuk/skillmetricscraper/openclaw-skill/last30days-weekly" ~/.openclaw/skills/openclaw-skills-last30days-weekly && rm -rf "$T"

manifest: skills/ademczuk/skillmetricscraper/openclaw-skill/last30days-weekly/SKILL.md

OpenClaw Skills Weekly — Community Intelligence Skill

Automated pipeline for tracking trending OpenClaw/ClawHub skills and community discussion.

What This Skill Does

ClawHub API Snapshots — Pulls all skills from
```
GET https://clawhub.ai/api/v1/skills
```
with cursor pagination. Stores daily snapshots in SQLite for 7-day velocity trending.
Community Signal Capture — Searches Reddit, X/Twitter, and web for OpenClaw skill discussions from the last 7 days. Structures findings into categorised signals.
Trending Analysis — Calculates install velocity (installs_current delta over trailing 7 days) to identify breakout skills.
YouTube Briefing — Generates punchy 15-second pitch scripts for the top trending skills.

Commands

Parse the user's request and route to the correct mode:

User says	Mode	Action
`snapshot` or `daily snapshot`	Snapshot	Record ClawHub metrics to DB
`report` or `weekly report`	Full Report	Snapshot + rank + community + scripts
`trending` or `what's trending`	Quick Trending	Show top 10 by velocity from DB
`community` or `community buzz`	Community Signals	Search Reddit/X/Web for discussions
`status` or `db status`	Status	Show DB health and snapshot history

Snapshot Mode (run daily)

python3 "${SKILL_ROOT}/scripts/clawhub_snapshot.py" snapshot

This fetches all skills from ClawHub API and records a timestamped snapshot to SQLite. Run this daily to build velocity history.

Expected output:

[SNAPSHOT] Fetching from https://clawhub.ai/api/v1/skills...
[SNAPSHOT] Page 1: 100 skills...
[SNAPSHOT] Done: 13,729 skills recorded at 2026-03-01T09:00:00
[SNAPSHOT] DB: 5 snapshot dates, 68,645 total rows

Tell the user how many skills were captured and how many snapshot dates exist.

Full Report Mode (run weekly)

python3 "${SKILL_ROOT}/scripts/clawhub_snapshot.py" report --top 10

Runs: snapshot → velocity ranking → outputs markdown report.

Present the top 10 skills in a formatted table:

# OpenClaw Skills Weekly — Week of Mar 01, 2026

| # | Skill | Installs | 7d Delta | Stars | Score |
|---|-------|----------|----------|-------|-------|
| 1 | Gog   | 1,304    | +127     | 593   | 0.42  |

Then tell the user the report is saved and suggest they run community capture too.

Community Signal Mode

Use the OpenClaw gateway's built-in WebSearch tool to search for recent community discussion:

Search:
```
"openclaw skills" site:reddit.com
```
(last 7 days)
Search:
```
"clawhub" trending skill
```
(last 7 days)

Search:

"openclaw skill" tutorial OR guide OR demo

(last 7 days)

For each notable result found:

Extract the title, URL, and a 1-sentence summary
Categorise as: tutorial, security, ecosystem, showcase, discussion, or market
Save to the signals JSON file

python3 "${SKILL_ROOT}/scripts/clawhub_snapshot.py" community --save

Status Mode

python3 "${SKILL_ROOT}/scripts/clawhub_snapshot.py" status

Shows: DB path, total rows, distinct snapshot dates, top 10 skills by current installs.

Setup

The script uses Python 3 stdlib only (sqlite3, urllib, json). No pip required.

DB location:

/home/node/.local/share/skills-weekly/metrics.db

Signals file:

/home/node/.local/share/skills-weekly/weekly_signals.json

Cron / Scheduling

For automated daily snapshots, add to the host's Task Scheduler or cron:

# Daily snapshot at 9am
docker exec -u node openclaw-gateway-secure python3 /home/node/.openclaw/workspace/skills/last30days-weekly/scripts/clawhub_snapshot.py snapshot

For the weekly full report:

# Weekly report on Mondays at 9am
docker exec -u node openclaw-gateway-secure python3 /home/node/.openclaw/workspace/skills/last30days-weekly/scripts/clawhub_snapshot.py report --top 10