Dev.to
7/12/2026
Commit Chronicles: Using SQL and Snowflake Cortex to Narrate GitHub Repo Histories
Original: Commit Chronicles—Your Obsession Leaves a Trail. Mine Gives It a Plot.
Short summary
Commit Chronicles analyzes a public GitHub repo's commit history using six SQL-based storyline detectors (nocturne, relapse, binge, collapse, fight, resurrection) and asks Snowflake Cortex to narrate the arc without inventing facts. The tool generates a shareable PNG card with real timestamps and commit quotes. Sparse repos get an honest 'no story here' grey card instead of fabricated narratives.
- •Six SQL detectors classify commit patterns (late-night, relapse, binge, collapse, fight, resurrection) with zero AI calls
- •Snowflake Cortex narrates the detected arc using only real commit data—no fabricated motivation or facts
- •Outputs a 1200x630 PNG card for README/social embedding; sparse repos honestly return 'no story'
Generated with AI, which can make mistakes.
Is this a good recommendation for you?
