SQLite node to query uploaded binary files

Questions
1

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
2

You’re right, the SQL Agent node has been deprecated. Since you’re using SQLite, you’ll need to use the `SQLite` node which is built into n8n. It allows you to directly query and manipulate SQLite databases within your workflow.

3

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