How to provide MS SQL table data and Stored procedures as input to Semantic Kernal

P, Pioline (Cognizant) 195 Reputation points
2024-03-20T05:25:31.0666667+00:00

Hi

I am using Sematic Kernal (C# implementation). I wish to configure a backend MS SQL database to Semantic Kernal. So, whenever a user query's, he will get data from the SQL database (basically trying to ground the model). Not only the table data, but we also like to provide the stored procedures as inputs to Semantic kernal.
So whenever a user query's for some table info, it should first check if data can be retrieved through stored procedures available, only if not available it should go to Model, writing its own query to fetch data.

Can you please suggest efficient way to do this. Is this possible.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,882 questions
{count} votes