cd /news/ai-agents/show-hn-markdown-is-40x-more-token-e… · home › topics › ai-agents › article
[ARTICLE · art-158764] src=withnative.ai ↗ pub= topic=ai-agents verified=true sentiment=↑ positive

Show HN: Markdown is 40× more token-efficient with SQLite

Native founder Richard reported that AI agents used 40× fewer tokens per correct answer when querying a SQLite-backed Markdown vault than a plain Markdown vault, based on a 120-trial evaluation over 11,000 records. Richard said the benchmark dataset remains private because it draws on two months of his own work, though he is considering open-sourcing it, and that the core engine evaluated is open-source on GitHub under withnative/native. He also noted that over two-thirds of the token bill on long agent sessions came from cached input tokens.

read2 min views1 publishedOct 27, 2026

Hi HN, I'm Richard, founder of Native. I'm working on open-source context ownership, to stop AI centralisation: https://github.com/withnative/native

My first focus has been making Markdown vaults powerful enough so that teams can self-host all of their context (messaging, docs and projects), without it being externally fragmented or rate-limited.

I'm sharing some early results: Markdown vaults can be 40× more efficient with SQLite!

https://www.withnative.ai/research-and-posts/markdown-contex... Here's some of the main ideas:

  • SQLite or Markdown folders, you pick. You can project the same authoritative event log into either form; more projection formats will follow (e.g. maybe neo4j; we do use a graph structure).

  • Empirically: SQLite is better for agents! On a 120 trial evaluation for 11,000 records, agents use 40× fewer tokens with SQLite vs Markdown, per correct answer.

  • Everything is a file or SQLite row. Messages, documents and projects: all can be modelled in your vault. You get local-first collaboration with teammates, synced to a cloud of your choice.

  • You can render your vault with arbitrary UI. Your WhatsApp-like UI speaks to your teammate's Slack-like UI; both are just views over the same database.

A few things I've learned building this:

  • Agents do pretty well even without SQL if you give them strongly typed Markdown frontmatter. This was one arm of the trial I ran. I didn't have any clear expectations, but it was cool to watch: agents ended up writing Python scripts to do SQL-like queries.

  • Cumulatively, cached input tokens can get expensive. I feel silly in hindsight here. I'd gotten used to letting my sessions run long, "It's all cached so it's very cheap". But when I looked at my results here, over 2/3 of the token bill on long sessions was cached input...

  • "Markdown vaults don't scale as well as databases" isn't as self-evident as I think. This is why I decided to benchmark it... I've had some very blank stares when I try to explain how Markdown files might break at true agent-scale volume.

Unfortunately, the dataset is private, because it's two months of my own work. I am considering open-sourcing it even so, but there is definitely some embarrassing stuff in there. TBD... I know that independent result verification matters!

The core engine that I evaluated is open-source, with more to be released soon: [https://github.com/withnative/native](https://github.com/withnative/native)

If you're interested in trying connected context on an open engine, you can get updates from our website or email me directly: richard@withnative.ai

Comments URL: [https://news.ycombinator.com/item?id=50258875](https://news.ycombinator.com/item?id=50258875)

Points: 2

── more in #ai-agents 4 stories · sorted by recency
── more on @native 3 stories trending now
sponsored brought to you by zahid.host 4,200+ EU-deployed projects
reading about agents? ship yours in a single git push.

Run your AI side-project on zahid.host

EU-based hosting, git-push deploys, automatic HTTPS, no cold starts. Free tier with a custom domain — perfect for shipping the agent you just read about.

$git push zahid main
→ Live at https://your-agent.zahid.host ✓
Get free account → Pricing
from €0/mo · no card required
LIVE [news/show-hn-markdown-is-…] indexed:0 read:2min 2026-10-27 · —