mcp_execute_query
Execute SQL queries on Azure CosmosDB containers, specifying parameters, max items, and cross-partition querying for precise data retrieval.
Instructions
Execute a SQL query against a CosmosDB container
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| container_id | Yes | The ID of the container to query | |
| enable_cross_partition | No | Whether to enable cross-partition queries | |
| max_items | No | Maximum number of items to return | |
| parameters | No | Optional parameters for the query as key-value pairs | |
| query | Yes | The SQL query to execute |
Input Schema (JSON Schema)
{
"properties": {
"container_id": {
"description": "The ID of the container to query",
"type": "string"
},
"enable_cross_partition": {
"default": true,
"description": "Whether to enable cross-partition queries",
"type": "boolean"
},
"max_items": {
"default": 100,
"description": "Maximum number of items to return",
"type": "number"
},
"parameters": {
"description": "Optional parameters for the query as key-value pairs",
"type": "object"
},
"query": {
"description": "The SQL query to execute",
"type": "string"
}
},
"required": [
"container_id",
"query"
],
"type": "object"
}