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

{
  "server": "mcp-duckdb-server v1.27.2 (DuckDB v1.5.3)",
  "launch": "uvx mcp-server-duckdb --db-path /tmp/test_duck2.db",
  "transport": "stdio (NDJSON)",
  "tools": [
    {
      "name": "query",
      "params": {
        "query": "string (required)"
      }
    }
  ],
  "trace": {
    "initialize": {
      "send": {
        "method": "initialize",
        "params": {
          "protocolVersion": "2024-11-05",
          "clientInfo": {
            "name": "pathfinder",
            "version": "1.0"
          }
        }
      },
      "recv": {
        "serverInfo": {
          "name": "mcp-duckdb-server",
          "version": "1.27.2"
        },
        "protocolVersion": "2024-11-05"
      }
    },
    "tools_list": {
      "send": {
        "method": "tools/list"
      },
      "recv_tools": ["query"]
    },
    "query_1_aggregate_by_product": {
      "send": {
        "method": "tools/call",
        "params": {
          "name": "query",
          "arguments": {
            "query": "SELECT product, SUM(amount) as total_sales, COUNT(*) as num_orders FROM read_csv_auto('/tmp/test_sales.csv') GROUP BY product ORDER BY total_sales DESC"
          }
        }
      },
      "recv": {
        "content": [
          {
            "type": "text",
            "text": "[('Widget A', 4500, 3), ('Widget C', 3300, 2), ('Widget B', 2300, 3)]"
          }
        ],
        "isError": false
      }
    },
    "query_2_aggregate_by_region": {
      "send": {
        "method": "tools/call",
        "params": {
          "name": "query",
          "arguments": {
            "query": "SELECT region, SUM(amount) as revenue, ROUND(AVG(amount), 2) as avg_order FROM read_csv_auto('/tmp/test_sales.csv') GROUP BY region"
          }
        }
      },
      "recv": {
        "content": [
          {
            "type": "text",
            "text": "[('South', 4000, 1000.0), ('North', 6100, 1525.0)]"
          }
        ],
        "isError": false
      }
    },
    "query_3_version": {
      "send": {
        "method": "tools/call",
        "params": {
          "name": "query",
          "arguments": {
            "query": "SELECT version() as duckdb_version"
          }
        }
      },
      "recv": {
        "content": [
          {
            "type": "text",
            "text": "[('v1.5.3',)]"
          }
        ],
        "isError": false
      }
    }
  }
}