openmeteo_dataframe_query

Active

Tool of io.github.cyanheads/open-meteo-mcp-server

declared in 0.2.0

Run a read-only SQL SELECT against tables staged on a DataCanvas by openmeteo_get_historical, openmeteo_get_ensemble, or openmeteo_get_climate. Pass the canvas_id returned when any of those tools spills (truncated: true). Tables are named by the spillover helper (e.g. spilled_<id>); use openmeteo_dataframe_describe to list available tables and their columns before querying.

Parameters schema

{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "canvas_id",
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "Read-only SELECT statement. Reference table names from openmeteo_dataframe_describe. Example: SELECT AVG(temperature_2m) AS avg_temp, strftime(time, '%Y-%m') AS month FROM spilled_abc123 GROUP BY month ORDER BY month"
    },
    "canvas_id": {
      "type": "string",
      "description": "Canvas ID returned by openmeteo_get_historical, openmeteo_get_ensemble, or openmeteo_get_climate when truncated: true."
    }
  }
}

What this tool wraps· 1 endpoint

min confidence0.70 0.50

Data resourceOpen-Meteo API
Open-Meteo · weather
name mention0.85

Parent server

io.github.cyanheads/open-meteo-mcp-server

https://github.com/cyanheads/open-meteo-mcp-server

1/7 registries

View full server →