I've built a couple for myself so far; the most recent is in zig (sqlite extension that treats markdown files / frontmatter as virtual tables) and it's lasted me. I plan to rewrite it soon to adapt to how I've been using it :)
The readme at https://github.com/kunalb/termdex/tree/main/markdown_files is probably the best bit.