Work
Each case study covers the problem, the architecture, the decisions and trade-offs, and what changed as a result.
-
Sleep Anchor: an AI and Python publishing pipeline
An AI and Python pipeline that turns one AI-generated track into a two-hour video, two podcast episodes and a streaming single. AI generates the music and artwork, I master each track, and Python scripts check, render and publish every release from one SQLite calendar and a local dashboard.
- Python
- Claude Code
- FFmpeg
- SQLite
- Next.js
- YouTube API
- RSS.com API
- Reaper
Running now
-
This site’s own data
A nightly pipeline that pulls this site’s Cloudflare analytics and GitHub activity, and Sleep Anchor’s website analytics, into DuckDB, models them with dbt, and publishes the results with their tests.
- Python
- dbt
- DuckDB
- GitHub Actions
- Cloudflare
Running now
-
An MCP server for this site
A read-only Model Context Protocol server, so AI agents like Claude can search and read my writing, case studies, projects and published numbers, with contract, schema and retrieval tests that check its answers.
- MCP
- Cloudflare Workers
- TypeScript
Running now