[P2] Add Bulk Write Operations (upsert, update, delete)

[sajeetharan]

Feature Request

Priority: P2 (Medium)

Description

CosmosDB Shell supports array input for mkitem (batch create) but lacks bulk upsert, update, and delete operations. Bulk operations are critical for data migration and maintenance tasks.

Comparable Features in Other Shells

• mongosh: bulkWrite(), ordered/unordered bulk operations
• sqlcmd: Bulk insert via bcp

Proposed Behavior

Add a bulk command or extend existing commands:

• bulk upsert <file> — Bulk upsert from JSON array or file
• bulk delete <query> — Bulk delete matching documents
• bulk patch <file> — Bulk patch operations
• Support concurrency control (max parallelism)
• Report progress, success/failure counts, and total RU cost

Example Usage

bulk upsert ./updates.json --max-parallelism 10
bulk delete "SELECT c.id, c.pk FROM c WHERE c.expired = true"
bulk patch ./patches.json

[tnaum-ms]

Worth clarifying what mongosh's bulkWrite actually is: it is a thin wrapper over the driver's wire protocol command. You still construct each operation in code, one by one. No file input, no format parsing, no progress reporting, no retry logic. Useful for scripting, but not a migration or import tool.

For real bulk import/export scenarios, a dedicated tool in the spirit of mongoimport/mongorestore would be a much better fit: focused scope, self-contained, easier to improve independently, and easier to reason about from a security and error handling perspective.

Folding all of that into the shell risks turning it into a monolith that becomes progressively harder to maintain. A separate cosmosdbimport or similar tool, callable from the shell and from CI/CD pipelines, would serve those workflows better.