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.