Run analytical SQL on local CSV/Parquet/JSON files via mcp-server-duckdb (uvx)

{
  "init": {
    "request": {
      "jsonrpc": "2.0",
      "id": 1,
      "method": "initialize",
      "params": {
        "protocolVersion": "2024-11-05",
        "capabilities": {},
        "clientInfo": {
          "name": "pathfinder",
          "version": "1.0"
        }
      }
    },
    "response": {
      "jsonrpc": "2.0",
      "id": 1,
      "result": {
        "protocolVersion": "2024-11-05",
        "capabilities": {
          "experimental": {},
          "prompts": {
            "listChanged": false
          },
          "resources": {
            "subscribe": false,
            "listChanged": false
          },
          "tools": {
            "listChanged": false
          }
        },
        "serverInfo": {
          "name": "mcp-duckdb-server",
          "version": "1.27.2"
        }
      }
    }
  },
  "tools_list": {
    "response": {
      "jsonrpc": "2.0",
      "id": 2,
      "result": {
        "tools": [
          {
            "name": "query",
            "description": "Execute a query on the DuckDB database",
            "inputSchema": {
              "type": "object",
              "properties": {
                "query": {
                  "type": "string",
                  "description": "SQL query to execute"
                }
              },
              "required": ["query"]
            }
          }
        ]
      }
    }
  },
  "query_group_by": {
    "request": {
      "jsonrpc": "2.0",
      "id": 3,
      "method": "tools/call",
      "params": {
        "name": "query",
        "arguments": {
          "query": "SELECT product, SUM(units) as total_units, SUM(revenue) as total_revenue FROM read_csv_auto('./sales.csv') GROUP BY product ORDER BY total_revenue DESC"
        }
      }
    },
    "response": {
      "jsonrpc": "2.0",
      "id": 3,
      "result": {
        "content": [
          {
            "type": "text",
            "text": "[('Widget A', 410, 8200.0), ('Widget B', 370, 7400.0), ('Widget C', 110, 5500.0)]"
          }
        ],
        "isError": false
      }
    }
  },
  "query_aggregation": {
    "request": {
      "jsonrpc": "2.0",
      "id": 4,
      "method": "tools/call",
      "params": {
        "name": "query",
        "arguments": {
          "query": "SELECT region, COUNT(*) as transactions, AVG(revenue) as avg_revenue, MAX(revenue) as max_revenue FROM read_csv_auto('./sales.csv') GROUP BY region ORDER BY avg_revenue DESC"
        }
      }
    },
    "response": {
      "jsonrpc": "2.0",
      "id": 4,
      "result": {
        "content": [
          {
            "type": "text",
            "text": "[('South', 3, 2900.0, 4000.0), ('North', 3, 2800.0, 3500.0), ('East', 2, 2000.0, 2200.0)]"
          }
        ],
        "isError": false
      }
    }
  }
}