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
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) |