SQLite WASM icon

SQLite WASM

Query SQLite databases in read-only mode via sql.js (WASM)

Actions3

Describe Table

AI-generated

Summary

Reads a SQLite database and runs PRAGMA table_info for the specified table, returning its column metadata. Choose a binary input or an allowed file path, then set the table name.

Inputs

  • Input Mode (required) — Select Binary or File Path. The database is loaded for this input item.
  • Binary Property — In Binary mode, the input binary property containing the database file; defaults to data.
  • Database File Path — In File Path mode, the absolute path to the database file.
  • Allowed Path Prefixes — In File Path mode, newline-separated prefixes that permit access to the file. Defaults to /files/ and /home/node/.n8n-files/; if the field is empty, these defaults are used.
  • Table Name (required) — Name of the table to describe. Must not be empty; the node quotes it as a SQL identifier.
  • Return Mode (required) — Choose Items to emit one n8n item per metadata row, or Single Item to emit one item with rows and operation/input metadata.

Output shape

A list of n8n items containing the rows returned by PRAGMA table_info for the table.

Items mode emits one item per returned row, with each row as its JSON data; if no rows are returned, it emits no items for that input. Single Item mode emits one item containing source, operation, inputMode, file metadata where available, and query, rows, columns, and rowCount. The database is queried in read-only mode.

Links

Discussion