$ man sqlite-content-index

SQLite Content Index

A derived SQLite database that makes your entire content repo queryable — multi-platform content parsing, cross-reference detection, asset inventory, and dead page detection, built with zero external dependencies.

by Shawn Tenam

Once the repo passed 100 content files across 6 platforms, the file system became opaque. I could not answer basic questions: how many LinkedIn posts went final this week? Which content has cross-platform siblings? What is the total word count for February? A SQLite index sitting alongside the repo gives you SQL queries over your content. The index is derived data — rebuilt from git-tracked files on every run. Delete the database, run the script, same result. It revealed its own gap: three major systems had shipped with zero blog coverage. The tool that finds content gaps found content gaps about the tool.

python3 scripts/build_index.py walks the repo and loads 9 tables into data/index.db. python3 scripts/query_index.py provides 8 subcommands for filtering by platform, stage, date, pillar, series, and more. Output modes include table, JSON, and count. Cross-platform link detection finds sibling content automatically by matching date and slug across platforms. Run it weekly to audit content coverage and find gaps.