Accessing data from SQL Server

We have our application which stores data in SQL Server.
We are exploring ways where a user types in 'What is my sale as of today or What are my July 2024 sales ’ in a chatbot or any form of UI and a SQL query is fired with the required parameters and returns the result in the chat window.
Do you have any idea how to achieve this use case?

Thanks

1 Like

Welcome to the Community!

You should take a look at function calling.

Here’s the official guide and here are some worked examples including a SQL example from OpenAI’s cookbook collection.

1 Like