Sqlite — Safe Parameterized Query

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "SQLite \u2014 Safe Parameterized Query",
  "nodes": [
    {
      "parameters": {},
      "id": "trg-03",
      "name": "When clicking Execute",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ]
    },
    {
      "parameters": {
        "content": "## SQLite \u2014 Safe Parameterized Query\n\nShows the **safe** way to run raw SQL: use `$1, $2 \u2026` placeholders in the query and put the values in **Replacements** (a JSON array). Values are bound, never string-concatenated \u2014 no SQL injection.\n\nNote: each Execute Query node runs **one** SQL statement, so Create and Seed are separate nodes.\n\n**Before running:** set your **SQLite API** credential on each SQLite node.",
        "height": 280,
        "width": 380
      },
      "id": "note-03",
      "name": "How to use",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -40,
        -320
      ]
    },
    {
      "parameters": {
        "resource": "database",
        "operation": "executeQuery",
        "query": "CREATE TABLE IF NOT EXISTS products (id INTEGER PRIMARY KEY, name TEXT, price REAL, in_stock INTEGER)"
      },
      "id": "sql-create-03",
      "name": "Create Table",
      "type": "n8n-nodes-sqlite3-wasm.sqlite",
      "typeVersion": 1,
      "position": [
        220,
        0
      ],
      "credentials": {
        "sqliteApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "resource": "database",
        "operation": "executeQuery",
        "query": "INSERT OR IGNORE INTO products (id,name,price,in_stock) VALUES (1,'Keyboard',49.9,1),(2,'Mouse',19.5,1),(3,'Monitor',199.0,0)"
      },
      "id": "sql-seed-03",
      "name": "Seed Rows",
      "type": "n8n-nodes-sqlite3-wasm.sqlite",
      "typeVersion": 1,
      "position": [
        440,
        0
      ],
      "credentials": {
        "sqliteApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "resource": "database",
        "operation": "executeQuery",
        "query": "SELECT id, name, price FROM products WHERE price >= $1 AND in_stock = $2 ORDER BY price DESC",
        "replacementsJson": "[20, 1]"
      },
      "id": "sql-query-03",
      "name": "Query (price >= 20, in stock)",
      "type": "n8n-nodes-sqlite3-wasm.sqlite",
      "typeVersion": 1,
      "position": [
        660,
        0
      ],
      "credentials": {
        "sqliteApi": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When clicking Execute": {
      "main": [
        [
          {
            "node": "Create Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Table": {
      "main": [
        [
          {
            "node": "Seed Rows",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Seed Rows": {
      "main": [
        [
          {
            "node": "Query (price >= 20, in stock)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {}
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• sqliteApi

About this workflow

SQLite — Safe Parameterized Query. Uses n8n-nodes-sqlite3-wasm. Event-driven trigger; 5 nodes.

Source: https://github.com/MauricioPerera/n8n-nodes-sqlite3-wasm/blob/0b0e0aa3a957b07e735b1ccf2ced32b34ed07f76/examples/03-safe-parameterized-query.json — original creator credit. Request a take-down →

More General workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.