查询会话记录并使用Claude Code构建演讲幻灯片
Query session records and build talk slides with Claude Code
一位计算机科学讲师使用Claude Code查询其记录的会话数据库中的提交统计和时序，并为教师演讲制作幻灯片.
做了什么
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.
效果如何
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.
值得注意
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.
试试这个 Prompt
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.