SurrealDBInstall

Summary

Upsert multiple records in a specified SurrealDB table by processing an array of record objects in configurable batches. Supports batch size, parallel processing, transaction handling, and error management options.

Inputs

• Table (required) — Name of the target SurrealDB table (e.g., "person", "product", "order").
• Records Data (JSON) (required) — JSON array containing the record objects to upsert; each record is created or updated based on its identity.
• Batch Configuration — Settings to control batch processing behavior, including batch size (1-1000), whether to process batches in parallel, maximum parallel batches (1-10), error handling strategy (stop on error, continue on errors, partial success), transaction mode to execute all batches within a single transaction, and progress tracking to report batch execution status.
• Options — Additional optional parameters to specify SurrealDB namespace and database, overriding credential defaults.
• Connection Pooling — Configuration to optimize database connection pooling with parameters like max/min connections, acquire timeout, health check intervals, max idle time, retry attempts and delays, and connection validation settings.

Output shape

a structured JSON result indicating success or error per batch, including processed counts and detailed information per record upserted or error encountered.

Batch results reflect processing according to the batch configuration, including handling of partial successes, errors, and transaction boundaries. Progress tracking, if enabled, reports intermediate states during batch execution.

Links

• n8n community nodes installation guide