AI Services Market › Use cases › Research & Knowledge
Research & KnowledgeDone with Claude Code Jan 15, 2026
Query session records and build talk slides with Claude Code
A CS instructor used Claude Code to query his recorded session database for commit stats and timelines and to build slides for a faculty talk.
- What They Did
- Geoffrey Challen had built Claude Recorder, a tool that logs his Claude Code sessions to a local SQLite database with timestamps, tool use and token counts. For his faculty retreat talk, he had Claude Code query that database for stats and commit timelines. It then designed the reveal.js slides, including an interactive timeline, as one standalone HTML file. It also transcribed his practice recordings with WhisperX and drafted the written summary.
- How It Went
- The stats covered one 17-hour day: 903 prompts, 63 commits, and about 16,000 lines added. Claude produced the slides and the write-up. The source doesn't describe any failures in the slide-building itself.
- Worth Knowing
- The session data comes from a custom recorder he built beforehand. The day's API usage would have cost about $1,000, but he's on the $200 per month Max plan.
Try it yourself with Claude Code
I have a database of recorded work sessions at [path to database]. Explore its structure, then answer these questions: [e.g. commit counts per week, a timeline of the project, the biggest changes]. Then build a slide deck for a [length]-minute talk to [audience] on [topic] using those findings. You're done when I have the numbers with a note on how you computed them, plus a slide file I can open. Don't modify the database.
Do this with a skill.
These AI Services Market playbooks do this exact job.