like vector search ?

Yes. AWS has OpenSearch for cloud-first vector searches (disregarding cloud-hosted postgres with extensions etc). It's ridiculously expensive and not as fast.

DuckDB to the rescue.

Also embed the crap outta DuckDB locally in local agents running on VPS, etc