execute_jsonata_query
Execute JSONata queries to analyze and transform bird data from the AviBase dataset for advanced data processing.
Instructions
Execute a raw JSONata query for advanced data analysis and transformation. JSONata is a powerful query language for JSON data.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | JSONata query expression (e.g., "$count($[Taxon_rank = \"species\"])" to count species) | |
| limit | No | Maximum number of results to return for array results (default: 50) |
Implementation Reference
- mcp-server.js:653-686 (handler)The handler function that destructures query and optional limit from args, sends POST to /query endpoint with JSON body, processes response into formatted markdown text distinguishing array or single result, and returns structured content.
async handleExecuteJsonataQuery(args) { const { query, limit = 50 } = args; const endpoint = `/query`; const response = await this.makeAPIRequest(endpoint, { method: 'POST', body: JSON.stringify({ query, limit }), }); let resultText; if (Array.isArray(response.data)) { resultText = `**Query:** \`${query}\` **Result Type:** Array with ${response.pagination?.totalItems || response.data.length} items **Results:** ${response.data.map((item, i) => `${i + 1}. ${typeof item === 'object' ? JSON.stringify(item, null, 2) : item}`).join('\n\n')}`; } else { resultText = `**Query:** \`${query}\` **Result Type:** ${typeof response.data} **Result:** ${typeof response.data === 'object' ? JSON.stringify(response.data, null, 2) : response.data}`; } return { content: [ { type: 'text', text: `# JSONata Query Execution ${resultText} ${response.pagination?.hasNext ? `\n*Note: Showing first ${response.data.length} of ${response.pagination.totalItems} total results.*` : ''}`, }, ], }; } - mcp-server.js:262-276 (schema)Input schema defining required 'query' string and optional 'limit' number for the tool.
inputSchema: { type: 'object', properties: { query: { type: 'string', description: 'JSONata query expression (e.g., "$count($[Taxon_rank = \\"species\\"])" to count species)', }, limit: { type: 'number', description: 'Maximum number of results to return for array results (default: 50)', default: 50, }, }, required: ['query'], }, - mcp-server.js:318-319 (registration)Switch case dispatching tool calls to the specific handler method.
case 'execute_jsonata_query': return await this.handleExecuteJsonataQuery(args); - mcp-server.js:259-277 (registration)Tool definition object added to the tools list for ListToolsRequestHandler, including name, description, and inputSchema.
{ name: 'execute_jsonata_query', description: 'Execute a raw JSONata query for advanced data analysis and transformation. JSONata is a powerful query language for JSON data.', inputSchema: { type: 'object', properties: { query: { type: 'string', description: 'JSONata query expression (e.g., "$count($[Taxon_rank = \\"species\\"])" to count species)', }, limit: { type: 'number', description: 'Maximum number of results to return for array results (default: 50)', default: 50, }, }, required: ['query'], }, },