vhs-digest

name	vhs-digest
description	Generate awareness summaries and digests of VHS Berlin courses. Create weekly summaries of new courses, courses starting soon, status changes, or custom digest views. Use when the user wants a periodic overview or 'what's new this week' summary.
argument-hint	[period: daily|weekly|monthly] [optional: custom filters]
allowed-tools	["Bash","Read","Write"]

VHS Digest: Awareness Summaries

Generate periodic summaries of VHS Berlin course activity based on your watches and interests. All data comes from the local SQLite database populated by watch checks and searches.

Configuration

Read DB path from .claude/vhs-berlin-agent.local.md (frontmatter db_path), else default ~/.local/share/vhs-berlin/vhs.db.

Resolve bun

BUN=$(command -v bun 2>/dev/null || echo "$HOME/.bun/bin/bun")

Workflow

Digest Type: Weekly (default)

User request: "What's new this week?" or "Weekly VHS digest"

Step 1: Define time window

period = weekly → 7 days
period = monthly → 30 days
period = daily → 1 day

Step 2: Query the database

Run these queries using sqlite3:

New courses this period:

sqlite3 "<db_path>" "SELECT DISTINCT c.source_course_id, c.title, c.district, c.location, c.schedule_text, c.price_text, c.booking_status, c.source_url FROM courses c WHERE c.extracted_at >= datetime('now', '-7 days') ORDER BY c.extracted_at DESC LIMIT 50"

Recent course events (changes):

sqlite3 "<db_path>" "SELECT e.event_type, e.course_id, e.detected_at, w.label FROM course_events e LEFT JOIN watched_searches w ON e.watch_id = w.watch_id WHERE e.detected_at >= datetime('now', '-7 days') ORDER BY e.detected_at DESC"

Active watches:

sqlite3 "<db_path>" "SELECT watch_id, label, last_checked_at FROM watched_searches WHERE enabled=1 ORDER BY label"

Step 3: Run check if no recent data

If no courses extracted in the past period, offer to run a watch check first:

$BUN run ${CLAUDE_PLUGIN_ROOT}/scripts/watch.ts check --db-path "<db_path>"

Step 4: Present the digest

# VHS Berlin Weekly Digest
**Week of <date range>**

## New Courses This Week (N)

### <title> — <district>
- **Where**: <location>
- **When**: <schedule_text>
- **Price**: <price_text>
- **Status**: <booking_status>
- **Link**: <source_url>

## Course Changes (N)
- <title> → new_course / disappeared (watch: <label>)

## Your Active Watches
- <label> (last checked: <date>)

**Summary**: N new courses, N changes detected.
Want to search for something specific or adjust your watches?

If no data:

No VHS course activity recorded yet.
Run a watch check first, or search for courses to populate the database.

---

Digest Type: Custom

User request: "Show pottery classes under €100 this month"

Parse custom filters (category, price limit, time window) and translate to appropriate sqlite3 queries using the courses table columns: category, price_text, district, start_date, booking_status, extracted_at.

Note: price_text is a raw string (e.g., "€95,00") — use CAST(REPLACE(REPLACE(price_text,'€',''),',','.') AS REAL) to compare numerically.

---

Tips

• Group by watch: Show which watch label triggered each result
• Highlight urgency: Surface courses starting in the next 7 days
• Include stats: "N new, N changes, N watches active"
• Offer actions: "Want to watch one of these?" or link directly to VHS site
• If DB is empty: Direct user to run /vhs-berlin-agent:init and then a search

See Also

• vhs-watch skill — run check and manage watchlists
• vhs-search skill — find courses on demand
• data/schema.sql — full database schema