# How to do analysis on rasa.db file?

**URL:** <https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807>\
**Category:** Rasa Open Source\
**Created:** [July 11, 2019, 11:54am UTC](https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807 "2019-07-11T11:54:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![galandeshridhar](https://avatars.discourse-cdn.com/v4/letter/g/f17d59/32.png) [@galandeshridhar](https://forum.rasa.com/u/galandeshridhar)\
**Post date:** [July 11, 2019, 11:54am UTC](https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807/1 "2019-07-11T11:54:41Z")

</div>

I have build a chatbot with log tracer rasa.db. Any one can help me, How to do analysis on rasa.db file. Analysis in terms of which intent accessed largely and so…

---

<div class="post-metadata">

**Author:** ![amn41](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/amn41/32/20_2.png) [@amn41](https://forum.rasa.com/u/amn41)\
**Post date:** [July 11, 2019, 4:36pm UTC](https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807/2 "2019-07-11T16:36:08Z")

</div>

Hi @galandeshridhar ! The best way to get this data is to hook up an [event broker](https://rasa.com/docs/rasa/api/event-brokers/) - you can use that to dump events to a db and run your queries there.

Alternatively we have built-in analytics in the enterprise version of Rasa X

---

<div class="post-metadata">

**Author:** ![gaushh](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/gaushh/32/11154_2.png) [@gaushh](https://forum.rasa.com/u/gaushh)\
**Post date:** [September 19, 2020, 4:00pm UTC](https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807/3 "2020-09-19T16:00:54Z")

</div>

@amn41 Isn’t the Rasa [tracker store](https://rasa.com/docs/rasa/tracker-stores) used for this purpose? For my application, I want to store some extra data like intent confidence etc. to my MySQL server for further analysis. What is your recommendation on how I should go forward with it?

---

<div class="post-metadata">

**Author:** ![gaushh](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/gaushh/32/11154_2.png) [@gaushh](https://forum.rasa.com/u/gaushh)\
**Post date:** [September 19, 2020, 4:13pm UTC](https://forum.rasa.com/t/how-to-do-analysis-on-rasa-db-file/12807/4 "2020-09-19T16:13:33Z")

</div>

@amn41 Also, when I run Rasa X locally, all the conversation related data gets stored in rasa.db (that is pretty much all the data I need to store in my MySQL database for further analysis).

Is it coming from [InMemoryTrackerStore](https://legacy-docs-v1.rasa.com/api/tracker-stores/#id4)?

Where is it stored when Rasa X is deployed on a server via [One Line Deploy Script](https://legacy-docs-v1.rasa.com/user-guide/how-to-deploy/#server-quick-install)?

And can i store it directly in my MySQL Database?