n8n_manage_datatable
Destructive
Perform CRUD operations on n8n data tables and rows, including creation, listing, updating, deletion, and row management 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 |
|---|---|---|---|
| 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. |