How do you have N8N store it's data in a remote DB instead of locally

Questions
1

I currently see the information being store in local sqllite. How do I force it to use a more persistent remote DB?

2

If you are talking about the database that n8n uses to store it’s data, then you need to provide ENV vars, which will point your n8n to another database.

See here for more info.

If, on the other hand, you are talking about the data that YOU store from within your workflows, you just … use the nodes. Select the node that corresponds to the database you wish to use, create credentials and start using it.

3

Hi there,

Out of the box, n8n uses SQLite. but we can enable support for PostgreSQL. Besides this, the support for mysql and mariaDB were deprecated after version 1.0,

Enable support for PostgreSQL like this , With regard to accessing data from other DB’s in your workflow, please refer to the excellent comment above.

Cheers!

4

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