openaq_dataframe_query

Active

Tool of io.github.cyanheads/openaq-mcp-server

declared in 0.1.3

Run a read-only SQL SELECT against the measurement tables openaq_get_measurements staged on a DataCanvas. Reference tables by the name the measurements call returned (measurements_<sensorId>). For aggregation (monthly means, exceedance counts) and cross-sensor comparison over series too large to inline. Only SELECT is allowed — writes, DDL, and file/network table functions are rejected.

Parameters schema

{
  "type": "object",
  "$schema": "http://json-schema.org/draft-07/schema#",
  "required": [
    "canvas_id",
    "sql"
  ],
  "properties": {
    "sql": {
      "type": "string",
      "description": "Read-only SELECT. Reference tables by the names openaq_get_measurements returned (e.g. measurements_1701). Use openaq_dataframe_describe first to see table and column names."
    },
    "canvas_id": {
      "type": "string",
      "description": "DataCanvas id returned by openaq_get_measurements when a series spilled."
    }
  }
}

What this tool wraps· 0 endpoints

min confidence0.70 0.50

No endpoints wrapped at confidence ≥ 0.70.

Parent server

io.github.cyanheads/openaq-mcp-server

https://github.com/cyanheads/openaq-mcp-server

1/7 registries

View full server →