MySQL + n8n: The Complete Integration Guide
Connect MySQL to n8n to run SQL and upsert rows. Setup, triggers, actions, and production patterns.
Key takeaways
- MySQL authenticates with n8n via OAuth or API key — pick OAuth for user-facing flows and API key for service accounts.
- Triggers (webhooks and polling) start workflows on MySQL events; actions call MySQL from any other workflow.
- Use the HTTP Request node to reach MySQL endpoints the built-in node doesn't cover yet — the auth is reused.
- Rate limits, retries, and idempotency are the three biggest MySQL production gotchas — handle them explicitly.
MySQL is one of the most-used relational database platforms — and n8n is the fastest way to wire it into the rest of your stack without writing glue code. In this guide you'll set up authentication, pick the right triggers, and learn how teams use the MySQL node in production to run SQL and upsert rows.
Connecting MySQL to n8n
Open Credentials in n8n and create a new MySQL credential. Choose OAuth when a human should authorize on their own account, or an API key / access token for background workflows owned by an operations account. Store the client ID and secret from the MySQL developer console; n8n handles the callback and refresh tokens automatically.
After the credential is saved, add a MySQL node to any workflow and select the credential. Test the connection with a read-only action (list, get, or search) before wiring writes — a green execution proves the scopes are right.
- Grant only the minimum MySQL scopes your workflow needs.
- Use one credential per environment (dev, stage, prod) and never share across projects.
- Rotate keys quarterly and immediately after any contractor offboards.
Triggers and actions
The MySQL Trigger node starts a workflow when something happens in MySQL — a new record, a status change, an inbound message, or a webhook event. Prefer webhooks over polling when MySQL supports them; polling burns credits and adds latency.
Actions run from any node position and let you run SQL and upsert rows. Chain them with Set, If, and Merge nodes to build the exact business rule you need without touching code.
Production patterns for MySQL
Wrap every MySQL write in retries with exponential backoff — the API will throw 429s during traffic spikes and you don't want to lose events. Add a dedupe step (Redis SETNX or a Postgres unique index) so a retried webhook doesn't create duplicate records.
For high-volume workflows, run n8n in queue mode with a Redis broker and separate workers. That way MySQL throughput stops fighting with your other automations for the same CPU.
- Verify webhook signatures — never trust the payload alone.
- Log the full {name} response on failure so you can replay it later.
- Alert on 5xx rates, not just outages — silent degradation is the real killer.
Frequently asked questions
- Is there an official MySQL node in n8n?
- Yes. n8n ships a first-party MySQL node with common triggers and actions; use the HTTP Request node for endpoints the built-in node doesn't cover yet.
- OAuth or API key for MySQL?
- OAuth for user-owned data, API key or service account for background workflows. Never share personal OAuth tokens across a team.
- How do I handle MySQL rate limits?
- Add a Wait node between calls, use Split In Batches to control concurrency, and enable retries with exponential backoff at the node level.
- Can I self-host n8n and still use MySQL?
- Yes — the same node works self-hosted. Make sure your n8n instance is reachable from the internet if you need inbound webhooks from {name}.