To copy the n8n SQLite database from the cloud to your local environment, start by configuring the Kubernetes cluster access.
Next, run the following commands in your terminal:
This command will copy the SQLite database locally to ~/database.sqlite.
For the n8n application, the Postgres database runs in a separate container.
To connect with the database locally, you first need to identify the pod running the Postgres database using the following command:
Next, establish a proxy to the n8n pod running the Postgres database by executing the following command in the terminal:
Now, you can conveniently access the database using your preferred client on localhost:5432.