mcp-azure-tablestorage
by dkmaker
query_table
⚠️ 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 |