I had a Claude Project write a number of CLI tools that interact, eg

  search_documents "search term" --bm25 --table-prefix some_project | fulltext -hl -v | less

  search_documents "search term" --bm25 --table-prefix some_project | metadata

It inserts documents by piping paths into another script, eg,

  find /some/path/*.pdf | insert_documents --table-prefix some_project

The documents end up in a Postgres database with pg_search bm25, tsvector, and semantic embeddings (from a local model).

I would estimate that I only wrote 5% of the code in the project with the rest coming from the LLM.

Sure, it's just a few hundred lines of code but it's been stable and helpful to get through some very large tranches of discovery material.