cosmosdb_query_items_to_file
Run a SQL query on a Cosmos DB container and save results as a JSON array to a local file. Returns only the item count to manage large result sets.
Instructions
Run a SQL query against a Cosmos DB container and save results to a file.
Results are written to output_file as a JSON array. Only the item count is returned in context — use this variant when the result set may be large to avoid filling the context window. max_items is capped at 1000.
key_env_var: name of the environment variable holding the Cosmos DB account key. If the variable is set, key-based auth is used; otherwise DefaultAzureCredential is used.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| account | Yes | ||
| database | Yes | ||
| container | Yes | ||
| query | Yes | ||
| output_file | Yes | ||
| max_items | No | ||
| key_env_var | No | AZURE_COSMOS_KEY |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |