Create an AI Agent from Your Data

We've significantly improved upon our ability to interact with any database using our AI Agent technology. In addition to generating CRUD functions, we're now also able to create aggregate functions, group by functions, and functions that selects unique and distinct values. This implies we've got almost everything you could imagine required to query your data.

This allows us to deliver AI Agents allowing you to ask questions towards your data such as for instance.

"List all unique countries we've got customers in"
"Find the average invoice amount from the USA, Canada, Nigeria and Norway. Then create a bar chart for me."
Etc ...

These improvements implies we can almost do anything with natural language you would typically need SQL or Excel to accomplish.

CSV to Database

In addition, we can generate a database from an SQL file, which gives you the same features on your CSV file. Something we're demonstrating in the above video. This process will create a new database table, wrapping your CSV file into it, allowing you to query, aggregate, update, delete and create new records.

Aggregates and pivot tables

We've always had the ability to generate CRUD endpoints and functions. But what's new is the ability to also generate pivot table selects with group by, distinct selects and counts, aggregates such as sum, max, min, avg - Etc. The functions we've added that are now automatically generated with the backend generator are as follows.

Aggregate, allowing for calculating sum, min, max and average of columns based upon filtering criteria
List and count distinct values, allowing you to return or count all distinct values in your tables
Allowing you to group data together to have it return sum, avg, min, max or count of all records having some field in common

Wrapping up

You will find that this is not as powerful as SQL, since there are functions you can achieve with standard SQL that you cannot reproduce using our backend generator. But the use cases required to manually write SQL has rapidly become much smaller with these new additions. In addition, we can also prompt engineer the thing to respond to things such as for instance.

"Generate monthly sales report"
"Calculate this month's total expenses"
Etc ...

Which will leverage these newly added functions to return its result.

Have a Custom AI Solution

At AINIRO we specialise in delivering custom AI solutions and AI chatbots with AI agent features. If you want to talk to us about how we can help you implement your next custom AI solution, you can reach out to us below.