# Data extraction from database

**URL:** <https://forum.rasa.com/t/data-extraction-from-database/40606>\
**Category:** Rasa Open Source\
**Created:** [February 25, 2021, 6:25am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606 "2021-02-25T06:25:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anisha](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@Anisha](https://forum.rasa.com/u/Anisha)\
**Post date:** [February 25, 2021, 6:25am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606/1 "2021-02-25T06:25:00Z")

</div>

How can we extract data from a database to be used in a chatbot?

---

<div class="post-metadata">

**Author:** ![ChrisRahme](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/chrisrahme/32/15572_2.png) [@ChrisRahme](https://forum.rasa.com/u/ChrisRahme)\
**Post date:** [February 25, 2021, 6:46am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606/2 "2021-02-25T06:46:07Z")

</div>

Do you want to query the database or use it to train the chatbot?

---

<div class="post-metadata">

**Author:** ![Anisha](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@Anisha](https://forum.rasa.com/u/Anisha)\
**Post date:** [February 25, 2021, 6:50am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606/3 "2021-02-25T06:50:12Z")

</div>

i am making a chatbot which helps in finding a university according to input given by the user, so i am a bit confuse on this part but i want by bot to take the data from the database which is the information about the universities and show the data to the user.

---

<div class="post-metadata">

**Author:** ![ChrisRahme](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/chrisrahme/32/15572_2.png) [@ChrisRahme](https://forum.rasa.com/u/ChrisRahme)\
**Post date:** [February 25, 2021, 6:54am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606/4 "2021-02-25T06:54:18Z")

</div>

You can use [custom actions](https://rasa.com/docs/action-server/sdk-actions).

In your custom action, you can connect to a database like in any other Python code. If you want to connect to a MySQL database, you can use the [mysql-connector-python](https://pypi.org/project/mysql-connector-python/) module. [Here](https://dev.mysql.com/doc/connector-python/en/connector-python-examples.html) are its docs.

---

<div class="post-metadata">

**Author:** ![daisie678](https://avatars.discourse-cdn.com/v4/letter/d/c5a1d2/32.png) [@daisie678](https://forum.rasa.com/u/daisie678)\
**Post date:** [March 3, 2021, 9:03am UTC](https://forum.rasa.com/t/data-extraction-from-database/40606/5 "2021-03-03T09:03:00Z")

</div>

Hey everyone! I hope you all are fine and doing great, Is there anyone who about .htaccess how can I apply redirects by using .htaccess command?