anyquery icon indicating copy to clipboard operation
anyquery copied to clipboard

Querying files not working in mcp

Open XU-Nuo opened this issue 5 months ago • 1 comments

I am trying to query files using mcp, but it seems reading from files can only be used in cli. mcp calls:

{
  "method": "tools/call",
  "params": {
    "name": "executeQuery",
    "arguments": {
      "query": "SELECT count(*)  FROM read_csv('./table.csv');"
    }
  }
}

result:

{
    "content": [
        {
            "type": "text",
            "text": "Failed to execute the query: failed to run the query: no such table: read_csv"
        }
    ],
    "isError": true
}

Thank you in advance.

XU-Nuo avatar May 23 '25 08:05 XU-Nuo