# Is it possible to show mysql query result in Data Table Visualization?

**URL:** https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001
**Category:** Kibana
**Created:** [November 9, 2017, 9:23am UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001 "2017-11-09T09:23:32Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![cjcenizal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cjcenizal/32/11216_2.png) [@cjcenizal](https://discuss.elastic.co/u/cjcenizal)
#### Post date: [November 9, 2017, 9:51pm UTC](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001/2 "2017-11-09T21:51:27Z")

</div>

Hi Saafia, before you can visualize your MySQL data in Kibana, you will need to migrate your data from MySQL into Elasticsearch.

- Here is [another Discuss thread](https://discuss.elastic.co/t/kibana-mysql-connection/17949/2) which outlines this process.
- In that thread, they refer to the [Jdbc Logstash plugin](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html) as the mechanism for migrating your data from MySQL to Logstash.
- I did some Googling and also found [this tutorial and video](http://datascience-enthusiast.com/Miscellaneous/MySQL_to_ELK.html) which dives into this process and may or may not provide you with some insight.

Once your data is in Elasticsearch, I can help you figure out how you want to display it in a Data Table and how to configure your visualization to reach your goal. I hope this helps!

Thanks,  
CJ

---

_[View the full topic](https://discuss.elastic.co/t/is-it-possible-to-show-mysql-query-result-in-data-table-visualization/107001)._