This Teams bot takes user queries in natural language form and generates & runs SQL queries on the database provided in the app setting "Sql_ConnectionString", returns the results in the chat. Expots the results to excel or Emails the excel optionally. This uses OpenAI GPT-4 and Semantic Kernel SDK.
To run this bot configure these parameters in the appsettings.json
- BOT_ID: Bot Id.
- BOT_PASSWORD: Bot password
- OpenAI_GPTModelName: Azure OpenAI GPT model name
- OpenAI_EndPoint: Azure OpenAI endpoint
- OpenAI_Key: Azure OpenAI key
- Sql_ConnectionString: Database connection string
- ApplicationInsights_ConnectionString: Azure Application Insights connection string for telemetry and logs
- Graph_EmailFrom: Sender Email id
- Graph_EmailTo: Recipient Email id
- Graph_ClientId: Azure app registration client id to use with Graph API
- Graph_ClientSecret: Azure app registration client sexret
- Graph_TenantId: Azure app registration tenenant id