Using Azure OpenAI / Copilot Application Outside of Portal to Answer Natural Language Questions with SQL Queries

hampton123 1,165 Reputation points
2024-07-19T19:10:49.97+00:00

I have been experimenting with Copilot on my Azure SQL databases, and I love the functionality of querying a database through plaintext and getting the results. I'm interested in making this available to non-technical users outside of the Azure portal. Is it possible to do this with Copilot or Azure OpenAI? My idea is to create an Azure Function with Javascript and an HTML interface. Thank you!

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,846 questions
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
2,857 questions
Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
235 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. AshokPeddakotla-MSFT 32,541 Reputation points
    2024-07-22T06:41:35.77+00:00

    hampton123 Greetings & Thank you for posting your query here!

    Incase if you haven't checked earlier, please check the Revolutionizing SQL Queries with Azure Open AI and Semantic Kernel for more details and let me know if that helps.

    To answer your query, it is possible to create an Azure Function with a Javascript and HTML interface to allow non-technical users to query your Azure SQL databases. You can use Azure Functions to create a REST API that can be called from your HTML interface to execute SQL queries against your database. see Connect Azure Functions to Azure SQL Database using Visual Studio Code and Tutorial: Add an Azure SQL database connection in Azure Static Web Apps (preview) for more information.

    Do let me know if you have any further queries.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.