Not Monitored
Tag not monitored by Microsoft.
42,838 questions
How to provide MS SQL table data and Stored procedures as input to Semantic Kernal
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 93%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
P, Pioline (Cognizant)
215
Reputation points
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.
{count} votes
-
Oury Ba-MSFT 20,611 Reputation points Microsoft Employee2024-03-20T15:46:27.74+00:00 Thank you for reaching out.
Could you please provide more clarification on what you are trying to accomplish.
What do you want the Chabot to do? Please explain the flow so we can understand better.
Regards,
Oury
-
P, Pioline (Cognizant) 215 Reputation points
2024-03-20T17:53:09.9866667+00:00 Hi
I am trying to feed Semantic Kernal with my custom data from MS SQL database.
I am expecting this: Whenever i query for any data from this database, the model should not immediately write a query to fetch the data but instead it should check for any stored procedures in this database to fetch the data. If query based stored procedure is not found, the the model can form a SQL query based on user input and fetch data from DB and provide response. -
Oury Ba-MSFT 20,611 Reputation points Microsoft Employee
2024-03-21T15:46:53.41+00:00 Thank you for clarifying this.
Could you please post this issue here https://github.com/microsoft/semantic-kernel/issues
Regards,
Oury
Sign in to comment
Sign in to answer