MySQL Query Service

Looking for continuous sensors instead of actions you trigger on demand? See HA MySQL, a sibling integration built for that — full comparison at the bottom of this README.

A Home Assistant custom component that talks to a MySQL or MariaDB database through two actions: mysql_query.query reads with a SELECT and hands you the rows, and mysql_query.execute writes with an INSERT, UPDATE, DELETE or DDL statement and hands you what it changed. Both can return their result as response data you can use straight from a template.

• UI configuration: add a connection, change it later from the menu of the connection, and sign in again from a prompt when the database refuses the credentials.
• Reading and writing are separate: query runs only statements that read, execute only statements that change something. The wrong one gives an error naming the right one.
• Parameterized queries: pass values separately with values and %s placeholders, so the database escapes them for you.
• Guard rails: a row limit, a query timeout, one statement per call, optional read-only connections, writes for administrators only, and optional TLS.
• Multiple databases: configure several connections and pick one per call, or use db4query for another database on the same server.
• Robust: pooled connections, calls on one connection queue instead of interleaving, and a connection that cannot be reached at startup is retried by itself.
• JSON-safe results: MySQL types such as DECIMAL, DATE and TIME are converted automatically.