mssql_import_table_data
Import JSON or CSV data into a target SQL Server table. Supports configurable batch sizes, delimiters, and optional truncation for efficient data loading.
Instructions
Import data from JSON or CSV file into a table
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"tableName": "<tableName>",
"inputPath": "<inputPath>"
},
"name": "mssql_import_table_data"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| format | No | json | |
| schema | No | Schema name (defaults to dbo) | |
| batchSize | No | ||
| delimiter | No | CSV delimiter | , |
| inputPath | Yes | Path to the .json (array of objects) or .csv file | |
| tableName | Yes | Target table | |
| truncateFirst | No | TRUNCATE the table inside the import transaction first | |
| connectionString | No | SQL Server connection string (optional; requires --allow-tool-connection-string) |