# Insight graphs

**URL:** <https://community.homey.app/t/insight-graphs/10939>\
**Category:** Ideas & Suggestions\
**Created:** [March 23, 2019, 7:53am UTC](https://community.homey.app/t/insight-graphs/10939 "2019-03-23T07:53:03Z")\
**Posts on this page:** 1\
**Showing post:** 22

<div class="post-metadata">

**Author:** ![RonnyW](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/ronnyw/32/10879_2.png) [@RonnyW](https://community.homey.app/u/RonnyW)\
**Post date:** [June 25, 2022, 7:25pm UTC](https://community.homey.app/t/insight-graphs/10939/22 "2022-06-25T19:25:49Z")

</div>

Or export the needed sensor values to a SQL database. Check the examples if it fits to your needs. This way you can react on a sensor change and export it with a INSERT Sql statement in the flow THEN part using current time and date as additional columns.

> [@\[APP\]\[PRO\] MySQL-Client](https://community.homey.app/t/app-pro-mysql-client/62459):
>
> [[small]](https://homey.app/de-de/app/de.ronnywinkler.mysql/MySQL/) A MySQL client for Homey Add this app to use SQL queries in Homey to read or write datasets from/to a local MySQL compatible database. The app provides a driver/device to connect to a database server and one of its databases. The following flow actions can be used from this device: SELECT a dataset with a SQL query (read periodical logged values to use in Homey). UPDATE/INSERT lines using global tokens (log device capabilities to your database). The following flow triggers can …

---

_[View the full topic](https://community.homey.app/t/insight-graphs/10939)._
