Implementing copilot-like feature: What technologies/APIs to use?

The scenario: My company creates and sells a software system that is used to store and analyze data from industrial processes. There are two kinds of data in the system: Time-series data and object model data. On top of the storage data model, customers and our consultants create calculated time series and object model attributes using an equation/expression language. A + B , TIME_SUM(A+B, 'Day->Mon'), YTD_SUM(A / B * C) + A etc. The equation language has a number of functions available to use. Issue/questions: We want to add a copilot-like feature to our product. Given the (common, standard) documentation for the storage model and equation language plus (customer specific) definition of the stored data (i.e. time-series/object model series/attribute names and other metadata), we would like a LLM integrated in our product's UI to act as an expert and let the users get answers to questions like: "Write an expression to calculate the average oil well production rate by month" "Write an expression that returns the dates where the oil well water injection rate is more than 50% above average" Please point me in the right direction on which APIs would be suitable for this. I assume using a third-party service is the way to go? Or are there self-hosted stuff we could use as well?

Apr 29, 2025 - 09:14

The scenario:

My company creates and sells a software system that is used to store and analyze data from industrial processes. There are two kinds of data in the system: Time-series data and object model data.
On top of the storage data model, customers and our consultants create calculated time series and object model attributes using an equation/expression language. A + B , TIME_SUM(A+B, 'Day->Mon'), YTD_SUM(A / B * C) + A etc.
The equation language has a number of functions available to use.

Issue/questions:

We want to add a copilot-like feature to our product.
Given the (common, standard) documentation for the storage model and equation language plus (customer specific) definition of the stored data (i.e. time-series/object model series/attribute names and other metadata), we would like a LLM integrated in our product's UI to act as an expert and let the users get answers to questions like:
- "Write an expression to calculate the average oil well production rate by month"
- "Write an expression that returns the dates where the oil well water injection rate is more than 50% above average"
Please point me in the right direction on which APIs would be suitable for this.
I assume using a third-party service is the way to go? Or are there self-hosted stuff we could use as well?