DuneLink provides two simple tools with basic descriptions and minimal parameter documentation. Both tools are READ_ONLY query operations against Dune Analytics. Naming is adequate (verb_noun pattern with 'get_' and 'run_'), but parameter descriptions are minimal (only 1 sentence each), output schemas are completely undocumented, and error handling returns raw strings without recovery guidance. The implementation shows Flask/MCP integration but lacks the structured output, pagination support, and LLM-optimized descriptions expected in production tools.

• Document output schemas explicitly. Replace `return df.to_csv(index=False)` with structured JSON: `return {"rows": result_data, "row_count": len(result_data), "execution_time_ms": elapsed}`. Describe this in tool docstring.
• Expand parameter descriptions to 50-150 chars. Example: 'query_id (integer, required): The Dune Analytics query ID to retrieve. Must be a positive integer corresponding to a saved query you own or have access to.'
• Implement pagination. Add optional `limit` (default 20, range 1-1000) and `offset` (default 0) parameters. Return `{"rows": [...], "total_count": N, "limit": 20, "offset": 0}`. Cap results at 50 to prevent context window exhaustion.
• Improve error messages with recovery guidance. Replace 'HTTP error running query: ...' with 'Query execution failed: <specific reason>. Verify query_id is valid (try get_latest_result first), or retry in 30 seconds if the API is rate-limited.'
• Add tool annotations in FastMCP decorator. Use `@mcp.tool(readOnlyHint=True)` to signal that both tools are read-only to the client.
• Document API key security: add a note that DUNE_API_KEY is loaded from environment variables and never exposed in parameters (correct pattern already implemented, but should be documented).
• For run_query, add error classification: distinguish between retryable errors (timeout, rate limit), user-fixable errors (invalid query_id), and fatal errors (authentication failure). Return: `{"error": "...", "category": "retryable|user_fixable|fatal", "suggestion": "..."}`

Inferred effective spec: <=2025-11-25.

• Relies on Logging (deprecated) - log to stderr or use OpenTelemetry