I want to explore if it is possible to create AI context vectors via API or dynamically (self hosted or cloud). specific example:
If we want to create a vector for each user based don't their specific role.
Example: we want to create a vector context that helps each user work with their own db by putting a list of tables into a vector.
So, an app would get the list of users and their db names from a table in postgres. For each user it needs to get a list of tables from their personal db and send that list to retool to create a vector.
Is that doable?
Hi, @k2m. This is absolutely possible via Retool Workflows. You can use Retool Workflows to query your Postgres DB and then upload that data into Retool Vectors using a Retool Vectors block. To trigger this workflow, you can expose it as a webhook. Let me know if you have any questions.
Hm, but then I would need to submit the DB credentials to the app dynamically, via an API and I also need to trigger vector creation with a specific name to match the user for whom this vector is for. Can Vectors be created via API? Another use case would be to submit to Vector text data stored in documents for each users repo.
Hi @k2m, this is all still possible through Workflows through triggering the worklows webhook with a set of arguments such as your user's name and DB credentials.