# Storing energy data

**URL:** <https://community.homey.app/t/storing-energy-data/127635>\
**Category:** Energy\
**Created:** [January 13, 2025, 7:55pm UTC](https://community.homey.app/t/storing-energy-data/127635 "2025-01-13T19:55:07Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [January 14, 2025, 4:13pm UTC](https://community.homey.app/t/storing-energy-data/127635/4 "2025-01-14T16:13:09Z")

</div>

Here is an example for writing values via flow into a database. If mySQL makes sende depends on the way you want to visualize the data.  
As small version you could use MS Excel with a mySQL ODBC addon. Then you can create Pivot tables and charts.

> [@\[APP\]\[PRO\] MySQL-Client](https://community.homey.app/t/app-pro-mysql-client/62459/2):
>
> Examples: SELECT Select one value from your database in the THEN part of your flow: [grafik] Use the flow trigger in the IF part of your flow to receive the first value of the result. You can use the Query-ID used in the SELECT above to filter your flow (react only on this kind of query). [grafik] Use the value in your flow. Take a look at the local flow tags you can use: [grafik] Use the first valus as number or text, write the complete JSON result to the timeline or what ever you ne…

---

_[View the full topic](https://community.homey.app/t/storing-energy-data/127635)._