Templates / Build your own SQLite MCP server

Build your own SQLite MCP server

Ready for 3.0

by Jimleuk ✓ · 2,893 views · created 2025-04-21 · Engineering, AI RAG

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What this workflow does

This AI workflow has 11 nodes and runs when an MCP client calls one of its tools (plus 1 other trigger). It uses only n8n's built-in nodes.

How it runs

Trigger: When an MCP client calls one of its tools (plus 1 other trigger).

Operation (Switch): routes items into 3 branches
ReadRecords (Code): runs custom JavaScript code
CreateRecord (Code): runs custom JavaScript code
UpdateRecord (Code): runs custom JavaScript code

Before you upgrade to n8n 3.0

Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.

Nodes used (6)

Execute Workflow Triggern8n-nodes-base.executeWorkflowTrigger
Switchn8n-nodes-base.switch
MCP Server Trigger@n8n/n8n-nodes-langchain.mcpTrigger
Coden8n-nodes-base.code
Code Tool@n8n/n8n-nodes-langchain.toolCode
Call n8n Workflow Tool@n8n/n8n-nodes-langchain.toolWorkflow

From the author

This template is for Self-Hosted N8N Instances only. This n8n demonstrates how to build a simple SQLite MCP server to perform local database operations as well as use it for Business Intelligence. This MCP example is based off an official MCP reference…
Excerpt from Jimleuk's description on n8n.io.

View the original on n8n.io → Check your own copy