Database Administration

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.