LlamaIndex VectorStoreIndex defaults to in-memory which allows you to get up and running very quickly - had pretty great experiences with their TS repo and even contributed a little to it.
fromDocuments -> VectorStoreIndex -> asQueryEngine it will be in-memory.
Easily add pgvector as other recommend here when/if you need to persist embedded data.