Database record creation from text-based interactions

Non-transitory computer readable media having instructions stored thereon for performing a method, the method comprising:

• receiving a text interaction record at a database system, the text interaction record including interaction text from one or more messages between a client machine and a service provider;
• determining an input database record creation prompt that includes natural language instructions to generate database record field text based on the text interaction record, the input database record creation prompt including some or all of the interaction text;
• transmitting the input database record creation prompt to a large language model for completion;
• receiving a completed database record creation prompt from the large language model, the completed database record creation prompt including a text element created by the large language model based on the input database record creation prompt;
• generating a database record in the database system, the database record including a database field storing the text element;
• determining a text interaction topic based on the interaction text;
• determining a text embedding representing the interaction text in a multi-dimensional vector space;
• determining a database query including an index based on the text interaction topic and the text embedding;
• and
• executing the database query to obtain a result.

A database system comprising:

• a communication interface configured to receive a text interaction record including interaction text from one or more messages between a client machine and a service provider;
• a processor configured to determine an input database record creation prompt that includes natural language instructions to generate database record field text based on the text interaction record, the input database record creation prompt including some or all of the interaction text;
• a large language model interface configured to transmit the input database record creation prompt to a large language model for completion and to receive a completed database record creation prompt from the large language model, the completed database record creation prompt including a text element created by the large language model based on the input database record creation prompt;
• and
• a database query engine configured to;
• generate a database record including a database field storing the text element, determine a text interaction topic based on the interaction text, determine a text embedding representing the interaction text in a multi-dimensional vector space, determine a database query including an index based on the text interaction topic and the text embedding, and execute the database query to obtain a result.