Query session records and build talk slides with Claude Code
SummarySummary. Task: The author built a 'Claude Recorder' tool to log Claude Code sessions (timestamps, tokens, commits) into a local SQLite database. Using this data, they queried session metrics to generate statistics for a faculty presentation. The workflow involved using Claude Code to extract commit timelines and design reveal.js slides based on the recorded usage patterns.; tools: Claude Code. Human role: The original post does not say how a person stayed involved.; limitations: Requires a custom logging tool (Claude Recorder) to capture session data in SQLite. High API costs were noted (~$1,000 for one day of heavy usage). The author admits to not reading the generated code, relying on tests and high-level review, which introduces potential quality risks. Source is a personal talk transcript..
Tools
Published on Agent Work Atlas:
Overview
SummarySummary
Workflow
The author built a 'Claude Recorder' tool to log Claude Code sessions (timestamps, tokens, commits) into a local SQLite database. Using this data, they queried session metrics to generate statistics for a faculty presentation. The workflow involved using Claude Code to extract commit timelines and design reveal.js slides based on the recorded usage patterns.
Reported result
The presentation successfully demonstrated 17 hours of work, 63 commits, and ~16,000 lines of code added across two projects. The author reported writing zero lines of code by hand during the recorded day. The slides were generated as a standalone HTML file with embedded CSS/JS, created entirely by Claude Code.
Human role
The original post does not say how a person stayed involved.
Limitations
Requires a custom logging tool (Claude Recorder) to capture session data in SQLite. High API costs were noted (~$1,000 for one day of heavy usage). The author admits to not reading the generated code, relying on tests and high-level review, which introduces potential quality risks. Source is a personal talk transcript.
Try it
I need to create a presentation about my recent coding agent usage. First, ensure my [Claude Recorder] or equivalent logging tool is active and has captured at least [1 day] of sessions to [SQLite database]. Query the database to extract: total prompts, hours worked, commits shipped, lines added/deleted, and a timeline of major tasks. Use [Claude Code] to generate a [reveal.js] HTML slide deck. The slides must include: 1) A summary table of the metrics, 2) An interactive timeline visualization of the commits, and 3) A narrative section explaining the workflow. Output the result as a single standalone HTML file with embedded CSS/JS. Before finalizing, verify the data matches the database query results. If the database is empty, stop and ask me to run a sample session first.
Source reports are not independently verified. Publication date is the catalog publication date, not the original article date.