n8n_manage_datatable
Destructive
Create, read, update, and delete data tables and rows in n8n workflows. Perform operations like inserting, updating, upserting, and deleting rows with filtering and pagination.
Instructions
Manage n8n data tables and rows. Actions: createTable, listTables, getTable, updateTable, deleteTable, getRows, insertRows, updateRows, upsertRows, deleteRows.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | For insertRows: array of row objects. For updateRows/upsertRows: object with column values. | |
| name | No | For createTable: table name. For updateTable: new name (rename only — schema is immutable after creation) | |
| limit | No | For listTables/getRows: max results (1-100) | |
| action | Yes | Operation to perform | |
| cursor | No | For listTables/getRows: pagination cursor | |
| dryRun | No | For updateRows/upsertRows/deleteRows: preview without applying (default: false) | |
| filter | No | For getRows/updateRows/upsertRows/deleteRows: {type?: "and"|"or", filters: [{columnName, condition, value}]} | |
| search | No | For getRows: text search across string columns | |
| sortBy | No | For getRows: "columnName:asc" or "columnName:desc" | |
| columns | No | For createTable (required, at least one): column definitions. Schema is immutable after creation via public API. | |
| tableId | No | Data table ID (required for all actions except createTable and listTables) | |
| projectId | No | For createTable: project ID to create the table in. If omitted, uses the default project. | |
| returnData | No | For updateRows/upsertRows/deleteRows: return affected rows (default: false) | |
| returnType | No | For insertRows: what to return (default: count) |