Docs Navigation

Blocks

SQLite Database

Query and manipulate SQLite databases

Connect to SQLite databases to run queries, insert, update, or delete data with full SQL support.

Back to Catalog

Toolssqlite

Block Preview

SQLite Database

Query and manipulate SQLite databases

Usage

Add the block to your workflow and connect it to the upstream step.
Configure any required credentials or tokens in the inputs.
Fill in required inputs and optional parameters for the run.
Run a test execution, inspect outputs, and iterate before deploying.
Deploy the sqlite block with monitoring enabled in production.

Inputs (UI)

Operation

dropdown

Layout: full

Options: Execute Query, Create Table, Insert Data, Update Data

Database Path

short-input

Placeholder: Enter path to SQLite database file or :memory: for in-memory database

Layout: full

SQL Query

code

Placeholder: SELECT * FROM table_name WHERE condition;

Layout: full

Condition: operation = "query"

Create Table Query

code

Placeholder: CREATE TABLE table_name (column1 datatype, column2 datatype, ...);

Layout: full

Condition: operation = "create_table"

Table Name

short-input

Placeholder: Enter table name

Layout: half

Condition: operation = ["insert","update","delete"]

Data (JSON)

code

Placeholder: { "column1": "value1", "column2": "value2" }

Layout: full

Condition: operation = ["insert","update"]

WHERE Condition

short-input

Placeholder: column1 = "value1" AND column2 > 100

Layout: full

Condition: operation = ["update","delete"]

Inputs (API)

operation

string

Required

databasePath

string

Required

query

string

Optional

createTableQuery

string

Optional

tableName

string

Optional

data

json

Optional

whereCondition

string

Optional

Outputs

Primary response type:

{
  "result": "json",
  "query": "string",
  "affectedRows": "number",
  "error": "string"
}

Tool Access

sqlite_database