Describe the problem/error/question
I would like to upload or point to local SQLite database files that I have, so that I can query about the data structure and schemas, perform queries and general CRUD tasks. For example, a movie library app I have uses SQLite for its database, and I would like to understand how its tagging, library play counts and other things. I may be able to edit this data, perhaps adding new categories like “XMas”.
Previously, I think there was a SQL Agent node that covered some RDBMS platforms as well as SQLite, but has been deprecated earlier this year. There are no replacement guides, videos or tutorials covering SQLite specifically - most show how to use Postgres, MySQL or Supabase, which seem to have their own (new?) supporting nodes.
Information on your n8n setup
- n8n version: 1.123.4
- Database (default: SQLite): SQLite
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): Docker Desktop
- Operating system: macOS