Automating Customer Inquiry Translation to PostgreSQL Queries Using LLMs

Closed
MESH Scheduling Inc.
Kingston, Ontario, Canada
Senior Executive Assistant
(5)
4
Project
Academic experience
120 hours per student
Student
Anywhere
Advanced level

Project scope

Categories
Information technology Software development Machine learning
Skills
customer inquiries postgresql data retrieval chatgpt large language modeling generative artificial intelligence automation
Details

The goal of this project is to develop a system that utilizes large language models (LLMs), such as ChatGPT, to accurately translate customer inquiries into PostgreSQL queries. This system aims to streamline data retrieval and analysis processes, reducing the time and effort required by staff to interpret and respond to customer requests.

Deliverables
  • Requirement Analysis: Understand the types of customer inquiries and the corresponding data requirements.
  • LLM Implementation: Determine the best way to find and add necessary context. Develop a set of at least 100 examples to train Fine Tuned model to interpret customer inquiries and generate accurate PostgreSQL queries.
  • Testing and Validation: Ensure the generated queries are accurate and efficient, with no need for manual correction.
Mentorship

We will be providing 1-1 access to both high level planers of the project and engineers that are working on the webapp and this project directly for direction and assistance.


Communication will be done through Workplace, the company's standard communication platform. We will provide paid access to ChatGPT API for use, as well as access to a sample database for testing and knowledge acquisition

Supported causes
Industry, innovation and infrastructure

About the company

Company
Kingston, Ontario, Canada
11 - 50 employees
Hospital, health, wellness & medical

MESH Scheduling Inc. is a healthcare software/SaaS company based out of Kingston, Canada and San Francisco, USA. Built on a foundation of more than twenty years of academic and industrial research and development, thousands of healthcare providers in Canada, the US, and as far away as Australia benefit from Mesh AI as a partner to improve upon the work-life conflicts of healthcare.