List Tables
AI-generatedSummary
Returns a list of all tables and views in the specified SQLite database.
Inputs
- Input Mode (required) — Determines how the database is provided: 'Binary' expects a binary item property containing the database file, or 'File Path' expects an absolute path to the file on the server.
- Database File Path — The absolute file path to the SQLite database. Required when Input Mode is set to File Path.
- Allowed Path Prefixes — A list of absolute path prefixes allowed for the database file path (one per line). Defaults to /files/ and /home/node/.n8n-files/.
- Return Mode — Controls output shape: 'Items' creates one n8n item per table row (default), 'Single Item' returns a single item containing the list of tables and metadata.
Output shape
A list of items (or a single item), where each item represents a table or view with its name and type.
The operation returns columns 'name' and 'type' from sqlite_master. It is read-only; writing operations are blocked.
Examples
Example 1: List all tables in a database loaded as binary data.
Input Mode: Binary, Binary Property: data, Return Mode: Items
Example 2: Inspect a database file located in the n8n files directory.
Input Mode: File Path, Database File Path: /files/mydb.db, Return Mode: Single Item