Hello everyone, i am a noob and newbie to rasa, i ll get to the main point: so is it possible to connect rasa to a database and then store the conversations, domain, stories and nlu ? So everytime i use the command rasa train , it will update the stories, nlu and domain in the database also… If anyone knows how to do that, can you guide me a bit? In detail the Reason and what am i implementing rasa for: I am working on rasa as for my final year project, which contains 3 main entities thats user , admin, and the university staff… User chats with the bot through rasa webchat, (everytime user chats with bot, the conversations are storied in database… Admin controls everything by rasa x and alos has access to database, everytime trains bot, nlu, stories,domain is stored in databse… University Staff logins and a page can be seen, in which they can only see(ready only) conversations, domain, stories and nlu but not be able to edit the data, and make requests to admin for editing the data… mentioned reason to give you a clear idea of what am i going to do ! Apologies for my broken english!

Hi, for storing the domain and conversations it sounds like what you’re looking for is a tracker store , depending on the database you’d like to use perhaps the SQL tracker store ? For storing the stories and nlu data you’ll have to come up with your own way of pushing these to a database. This means you’ll have to come up with tables to store these. You can write a SQL connector in python, this will connect to your database and update the tables accordingly. Does that make sense?

hello hamza yes you can connect the rasa to database such as MySQL as I use in my graduation project as your situation. for my case I use the DB for storing a lot of intent like colleges and majors and the details for each one. finally I guess and think that the rasa x has a conversation saved by default search about how to reuse it not make a new one. and for DB i use Xampp for MYSQL and here can find how to connect python (action.py) file to MYSQL [image] mysql/mysql-connector-python MySQL Connector/Python is implementing the MySQL Client/Server protocol completely in Python. No MySQL libraries are needed, and no compilation is necessary to run this Python DB API v2.0 compliant... hope this help you.

Thanks alot but thats not what i am looking for… Just as rasa x shows you the conversations, intents and domains in the web page… i want to develop a simialr web page which will show the same contents but it will be in read only format and it will be limited to conversations, nlu , domain and stories ! for admin side i ll be using rasa x, for user side i have developed the web page and added the script so that will be used for user interaction with chatbot… The staff side is remaining only…

Rasa database connectivity

Rasa Open Source

htayyab63 (Hamza) April 5, 2021, 9:49pm 4

can you tell me in detail and provide an example code that how you stored the intents online in a db ?

Topic		Replies	Views
Connect rasa to external database Rasa Open Source	1	784	April 20, 2021
Rasa X and RASA Database connectivity + retriving data Tutorials, Resources & Videos community , rasa	0	421	April 6, 2021
How can let my bot save all conversation has been with and how to initialize the conversations Rasa Open Source	3	1754	July 18, 2019
Rasa and database Rasa Open Source	1	283	March 1, 2024
CONNECT RASA WITH A DATABASE Rasa Open Source	6	6337	October 1, 2020

Rasa database connectivity

Related topics