Read from a (encrypted) sqlite database file

Hi, I need to read/convert data from a sqlite file. Is there a nativ way to do so?

  • n8n Version: 1.18.2
  • Database: default
  • Running n8n via (Docker)
  • Operating system: unraid

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:

Hi @josema :wave: Sorry it’s been a while!

n8n wouldn’t have a way to interact with SQLiite database files - we don’t have a node for it at this time :bowing_man: Our AI nodes also won’t support encrypted sqlite if the file itself is encrypted.

Your best bet here would be using the Execute Command node, and interacting directly with the SQLite CLI that way :+1: