Database as a knowledge base

[norfolkpine]

Hi,
We have all our data stored in a Postgres database.
This data includes news articles, user blogs, company profiles and id maps for calling API's that we use to retrieve some of the mentioned data.
Some data is parsed from json responses and some from user input.

How do we use existing db tables as a knowledge base?
We have enabled pgvector.

Any guidance much appreciated.

Thanks