Changes and migrations · stop 6 of 10
import_data
Inserts many rows from a list.
Needs write modeTool sets: full
You might ask
“Add these 30 products to the catalog.”
Your assistant may call import_data to answer.
How it works
- Needs write mode. Takes a JSON array of rows and inserts them in batches. Column order comes from
columnsor from the first row's keys.
Parameters
rowsarrayrequired- Array of row objects, each mapping column name to value.
tablestringrequired- Target table as "schema.name".
columnsarray- Explicit column order to insert with. Defaults to the keys of the first row.
What your assistant reads
The description nexql-mcp sends with the tool. It's how the assistant decides when to use it.
Batch INSERT rows from a JSON array of objects into a table. Optional columns array fixes column order; otherwise keys from the first row are used.