hi, I’m from Indonesia, I’m a vocational high school student, I’m still studying with Rasa, and I have the task of making a bot whose answers are taken from the database that has been provided. It’s just how can Rasabot retrieve answers in the mysql database, where there are many in the database? table and in the table there are many answers where each answer is used for a different question, for example there are 5 answers in one table namely apples, bananas, oranges, grapes and strawberries and I want to take one of these answers for one question as an example if the user asks about apples, the bot will answer apples or if the user asks about bananas, the bot will answer bananas and so on. and how to solve this problem, is there a solution to this problem or is there a script that can solve the problem. I beg for your help

It sounds like a Rasa NLG server might be a solution here. There is an example NLG server available at rasa/nlg_server.py at main · RasaHQ/rasa · GitHub .

thanks you very much for the reference, i hope this gonna help me for my task

Hello Aiyub150 has your issue been solved

Sorry, is not solved and i don’t know how to use nlg server so i try to use custom action

Thanks you very much for the reference :smiley:

First you need to create a connector in your actions.py file: You could use pymsql to do that.

How to make rasabot able to fetch answers in mysql database

Rasa Open Source

mindseye (Piyush Daiya) March 4, 2023, 3:46pm 6

@Aiyub150 , you can use custom actions to call your mysql database. Refer to this post on how to connect to database -Fetching data from an oracle database

Topic		Replies	Views
Answers from database Rasa Open Source	2	1068	March 2, 2020
Can we connect Rasa open source with MySql and fetch output to chat output Tutorials, Resources & Videos mysql	2	680	March 26, 2020
How to connect chatbot with Database (MySQL) Rasa Open Source	6	5860	May 9, 2022
Can i retrieve information from MYSQL database by writing natural language using rasa? Rasa Open Source	4	531	February 18, 2020
Fetching Data from MySQL db in custom actions Tutorials, Resources & Videos	1	1239	May 2, 2021

How to make rasabot able to fetch answers in mysql database

Related topics