How to securely access a MySQL database hosted in a private subnet through n8n Cloud?

Questions
1

I’m working on developing a chat assistant, where the backend is built on n8n Cloud using a set of AI agents. One of these agents, the SQL agent, is responsible for converting natural language questions into SQL queries, fetching relevant data, and providing human-readable answers. Previously, we used a publicly accessible MySQL database, and everything worked well. However, the database has now been migrated to a private subnet, which is not accessible via the internet or n8n Cloud.

What is the best possible solution to access a MySQL database hosted in a private subnet through n8n Cloud? Are there any recommended approaches or workarounds to make this connection securely and efficiently?

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hmm, that’s really a network admin question and not about using n8n, is it?

4

SSH tunneling to a jump host that has access to subnet.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.