bulk-upsert
Insert or update multiple records from CSV or JSON files using a unique key to manage database changes efficiently.
Instructions
Bulk insert or update data from CSV or JSON file. Supports upsert operations with a unique key.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| apiKey | No | API key for authentication (optional if provided via --api_key) | |
| filePath | Yes | Path to CSV or JSON file containing data to import | |
| table | Yes | ||
| upsertKey | No |
Input Schema (JSON Schema)
{
"properties": {
"apiKey": {
"description": "API key for authentication (optional if provided via --api_key)",
"type": "string"
},
"filePath": {
"description": "Path to CSV or JSON file containing data to import",
"type": "string"
},
"table": {
"minLength": 1,
"type": "string"
},
"upsertKey": {
"type": "string"
}
},
"required": [
"table",
"filePath"
],
"type": "object"
}