Homey Pro (Early 2023) is now available in Early Access

MySQL

Access your MySQL database from Homey
Access your MySQL database from Homey

Read more ›

Donate

Supported devices

Flow cards

Click on a device above to show related Flow cards only.

When...

Database
The SQL POST query (insert/update) was executed with id Query ID.
i
Triggers when the SQL POST query (insert/update) was executed and delivers the result as token. The execution can be filtered by Query ID.
Database
The SQL query was executed with id Query ID.
i
Triggers when the SQL query was executed and delivers the result as token. The execution can be filtered by Query ID.

And...

Database
The result (as number) of SQL query SQL query with ID ID is ...
i
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as number) of SQL query SQL query with ID ID is greater than ...
i
The result of the SQL query. Select a single numeric field to compare.
Database
The result (as text) of SQL query SQL query with ID ID is ...
i
The result of the SQL query. Select a single field to compare.
Database
The SQL query SQL query with ID ID was processed successfully
i
The flow continues when the SQL query is successfully executed.

Then...

Database
Executes the SQL query with ID ID: SQL query.
i
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.
Advanced
Database
Executes the SQL query with ID ID: SQL query.
i
Use this action for SQL querys. An ID must be specified to evaluate the result. In the flow event, the response can be read via the Query ID. Use '[date-1d]', '[date-1m]' oder '[date-1y]' for calculation of a date based on the current date using a positive/negative difference in days, moths or years.

Reviews

This app has no reviews yet.

You can leave a review once you're using this app.

Thank you for your review.

Submit review

Write a review

Support

Having an issue with this app? Contact the developer via the Homey Community Forum.

What's new

Version 0.0.16 — Added second flow action 'Execute SQL query' for standard flows. Fix for hints/descriptions.

View changelog

MySQL is not compatible with the selected Homey.

Install MySQL on

MySQL will install on Homey shortly.

Install App