AI & DataNew Features

Integration of generative artificial intelligence in the Platform

It could not be otherwise, in Onesait Platform we have also integrated generative artificial intelligence capabilities, for in this release 5.2.0-Topgun, we have incorporated a couple of functionalities that will surely be useful to you.

Queries about Entities in natural language

We have integrated the Query Tool with different generative AIs, including those from OpenAI such as ChatGPT 3.5, DaVinci and others, so that, in natural language (and in multiple tongues), you can ask the query you want.

In the previous image: “Give me the data of the restaurant id, the district and the type of cuisine, for Chinese cuisine restaurants”, in Spanish.

Once the natural language query is executed, an SQL query for that user’s data will be returned.

It is interesting to know that this AI knows the context of the Platform user’s entities, so it is capable of deducing queries regarding that context, making perfect approximations, or approximations that require very little human intervention.

Below we can see a video showing different queries using this integration and their resolution:

Translation of the Spanish texts: 0:12: “Give me the data on Chinese cuisine restaurants”. 0:36: “Give me the population data for helsinki for the year 1950” (Lowercase H in the original). 1:07: “Give me the data grouped by restaurant by district and its count for Chinese-type cuisine”. Notice how in 1:18 the “s” in the field “Restaurants” must be removed because the field is “Restaurant” (But the table is “Restaurants” with an S and no removal is needed).

When using OpenAI’s ChatGPT, it requires an access token and incurs small costs for each query, so that’s something to keep in mind. This token, as well as the algorithms and configurations, can be configured from the centralized configuration of the Platform.

This integration is also available as an API from the Control Panel to be invoked from other systems. Besides, it is possible to directly use an OpenAI token in the call, to be able to manage it externally to the Platform.

In future developments, we will integrate other generative artificial intelligences, such as Google’s Bard, to help the different processes of the Platform.

Integration to generate code from Git projects

We have also taken this chance to integrate this generative artificial intelligence into the Platform’s Git project viewers and editors.

As in the previous case, an icon will appear on the right side of the Git viewer where you can activate the text entry window:

When pressed, a modal window will open, and there you will have to enter a prompt so that the AI generates the code you need. The more detailed the prompt is (language, framework, libraries, etc.), the better the response you will get.

After entering the prompt, click on the Generate button and you will have to wait for the response, which can take up to 1 minute. Afterwards, another modal will appear with the result, which you can copy and paste into your code viewer.


If you are interested in learning more about this new generative artificial intelligence functionality, or in seeing a demo of how it works in real time, do not hesitate to leave us a comment or send us a notice on our Onesait Platform support channel.

Header image: Andrew Neel at Unsplash.

✍🏻 Author(s)

Leave a Reply

Your email address will not be published. Required fields are marked *