query_table
Query data from Azure Storage Tables using OData filters to retrieve specific table records. Supports equality, compound conditions, numeric, and date comparisons. Returns limited results by default to manage context window constraints.
Instructions
⚠️ WARNING: This tool returns a limited subset of results (default: 5 items) to protect the LLM's context window. DO NOT increase this limit unless explicitly confirmed by the user.
Query data from an Azure Storage Table with optional filters.
Supported OData Filter Examples:
- Simple equality: filter: "PartitionKey eq 'COURSE'" filter: "email eq 'user@example.com'"
- Compound conditions: filter: "PartitionKey eq 'USER' and email eq 'user@example.com'" filter: "PartitionKey eq 'COURSE' and title eq 'GDPR Training'"
- Numeric comparisons: filter: "age gt 25" filter: "costPrice le 100"
- Date comparisons (ISO 8601 format): filter: "createdDate gt datetime'2023-01-01T00:00:00Z'" filter: "timestamp lt datetime'2024-12-31T23:59:59Z'"
Supported Operators:
- eq: Equal
- ne: Not equal
- gt: Greater than
- ge: Greater than or equal
- lt: Less than
- le: Less than or equal
- and: Logical and
- or: Logical or
- not: Logical not
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| filter | No | OData filter string. See description for examples. | |
| limit | No | Maximum number of items to return in response (default: 5). Note: Full query is still executed to get total count. | |
| select | No | Array of property names to select. Example: ["email", "username", "createdDate"] | |
| tableName | Yes | Name of the table to query |