DEV Community

Cover image for Wrap your SQL Database inside an AI Chatbot
Thomas Hansen
Thomas Hansen

Posted on • Originally published at ainiro.io

Wrap your SQL Database inside an AI Chatbot

We've always had the ability to connect your AI chatbot to your database. However, recently we've taken this to a completely new level, by connecting our CRUD generator to our machine learning features.

To understand what I mean, please watch the following video, where I create a password protected AI Chatbot using our AI Expert System, allowing you to access your database from within something that basically resembles a custom GPT.

How it works?

In the above video I am downloading an SQLite plugin that creates the Chinook database for you. However, you can at this point use the database component to connect to any existing database you have. The process would be as follows.

  1. Connect Magic to your existing database
  2. Generate CRUD endpoints using the "Backend Generator"
  3. Create a Machine Learning type if you don't want to use an existing
  4. Click the "flash" icon on the module that was automatically created for you and chose your model
  5. Vectorise your model from the Machine Learning component

If you want to allow others to access your chatbot, you can create new user(s) in your cloudlet as I illustrate in the above video. At the end of the process, you've got an AI chatbot you can use to create, read, update and delete items from your database, using nothing but natural language.

Additional features

If you want to, you can of course at this point add any amount of business logic you wish to the AI chatbot, such as I am demonstrating in this article, and even have the AI chatbot generate images if you wish. If you're interested in creating AI chatbots such as I demonstrate in the above video, you can contact us below to get the conversation started.

Top comments (0)