n8n_manage_datatable
Destructive
Manage n8n data tables and rows: create, list, update, delete tables; insert, update, upsert, delete, and query rows with filters, pagination, and sorting.
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 |
|---|---|---|---|
| action | Yes | Operation to perform | |
| tableId | No | Data table ID (required for all actions except createTable and listTables) | |
| name | No | For createTable: table name. For updateTable: new name (rename only — schema is immutable after creation) | |
| columns | No | For createTable (required, at least one): column definitions. Schema is immutable after creation via public API. | |
| data | No | For insertRows: array of row objects. For updateRows/upsertRows: object with column values. | |
| filter | No | For getRows/updateRows/upsertRows/deleteRows: {type?: "and"|"or", filters: [{columnName, condition, value}]} | |
| limit | No | For listTables/getRows: max results (1-100) | |
| cursor | No | For listTables/getRows: pagination cursor | |
| sortBy | No | For getRows: "columnName:asc" or "columnName:desc" | |
| search | No | For getRows: text search across string columns | |
| returnType | No | For insertRows: what to return (default: count) | |
| returnData | No | For updateRows/upsertRows/deleteRows: return affected rows (default: false) | |
| dryRun | No | For updateRows/upsertRows/deleteRows: preview without applying (default: false) | |
| projectId | No | For createTable: project ID to create the table in. If omitted, uses the default project. |