Automating Customer Inquiry Translation to PostgreSQL Queries Using LLMs
Project scope
Categories
Information technology Software development Machine learningSkills
customer inquiries postgresql data retrieval chatgpt large language modeling generative artificial intelligence automationThe 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.
- 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.
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 infrastructureAbout the company
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.