Back to Integrations
integrationHome Assistant node
integrationMySQL node

Home Assistant and MySQL integration

n8n lets you integrate Home Assistant with MySQL to build powerful workflows. Design automation that extracts, transforms and loads data between your apps and services. You can choose from thousands of ready-made apps or use our universal HTTP connector to sync apps not yet in our library.

Integrate Home Assistant and MySQL

Build your own Home Assistant and MySQL integration

Create custom Home Assistant and MySQL workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.

How to connect Home Assistant and MySQL

  • Step 1: Add the first step

  • Step 2: Add Home Assistant and MySQL nodes

  • Step 3: Connect Home Assistant and MySQL

  • Step 4: Run workflow

Over 3000 companies switch to n8n every single week

Home Assistant supported actions

Get Screenshot
Get the camera screenshot
Get
Get the configuration
Check Configuration
Check the configuration
Create
Create an event
Get Many
Get many events
Get Error Logs
Get a log for a specific entity
Get Logbook Entries
Get all logs
Call
Call a service within a specific domain
Get Many
Get many services
Create or Update
Create a new record, or update the current one if it already exists (upsert)
Get
Get a state for a specific entity
Get Many
Get many states
Create
Create a template

MySQL supported actions

Delete
Delete an entire table or rows in a table
Execute SQL
Execute an SQL query
Insert
Insert rows in a table
Insert or Update
Insert or update rows in a table
Select
Select rows from a table
Update
Update rows in a table

Looking to integrate Home Assistant and MySQL in your company?

Why use n8n to integrate Home Assistant with MySQL

Build complex workflows, really fast

Build complex workflows, really fast

Handle branching, merging and iteration easily.
Pause your workflow to wait for external events.

Code when you need it, UI when you don't

Simple debugging

Your data is displayed alongside your settings, making edge cases easy to track down.

Use templates to get started fast

Use 1000+ workflow templates available from our core team and our community.

Reuse your work

Copy and paste, easily import and export workflows.

Implement complex processes faster with n8n

red iconyellow iconred iconyellow icon