Skip to content

Querying files not working in mcp #47

@XU-Nuo

Description

@XU-Nuo

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.

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingenhancementNew feature or request

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions