Time seriesPro tier

time_series_at_point

Aggregate any time-series column from a source table within a radius of (lat, lon), bucketed over time. Bring your own qualified table, time column, and value column — buckets: hour, day, week, month, year. Aggregations: avg, sum, min, max, count.

Use cases

Plot daily PM2.5 averages within 2 km of a property over the last 12 months.
Compute monthly real-estate quotation trends near a listing.
Aggregate hourly transit ridership counts within an isochrone.
Track seasonal tourism POI activity around a candidate retail site.

Arguments

Name	Type	Required	Description
qualified_table	string	required	Source time-series table.
time_column	string	required	Timestamp column name.
value_column	string	required	Numeric column to aggregate (ignored when `agg=count`).
lat	number	required	Latitude in WGS84.
lon	number	required	Longitude in WGS84.
radius_m	number	required	Radius (meters). Range 1 – 50,000. Tier-capped.
time_from	string	required	ISO-8601 timestamp (inclusive).
time_to	string	required	ISO-8601 timestamp (exclusive).
bucket	string	optional	`hour` \| `day` \| `week` \| `month` \| `year`. Default `day`.
agg	string	optional	`avg` \| `sum` \| `min` \| `max` \| `count`. Default `avg`.
limit	integer	optional	Max buckets returned. Range 1 – 5,000. Default 1,000.

Example request

curl

bash

curl -X POST https://mcp.qubitdata.it/mcp \
  -H "Authorization: Bearer $QUBITDATA_KEY" \
  -H "Content-Type: application/json" \
  -d '{
    "jsonrpc": "2.0",
    "id": 1,
    "method": "tools/call",
    "params": {
      "name": "time_series_at_point",
      "arguments": {
            "qualified_table": "environment.arpa_aria_pm25",
            "time_column": "ts",
            "value_column": "value_ugm3",
            "lat": 45.4642,
            "lon": 9.19,
            "radius_m": 2000,
            "time_from": "2025-01-01",
            "time_to": "2026-01-01",
            "bucket": "month",
            "agg": "avg"
      }
    }
  }'

Example response

JSON-RPC 2.0 result

json

{
  "jsonrpc": "2.0",
  "id": 1,
  "result": {
    "content": [
      {
        "type": "text",
        "text": "[\n  { \"bucket\": \"2025-01-01\", \"value\": 38.4, \"n\": 1234 },\n  { \"bucket\": \"2025-02-01\", \"value\": 31.7, \"n\": 1189 }\n]"
      }
    ]
  }
}

Prompts to try

Drop these into Claude Desktop, Cursor, or any MCP-aware client wired to https://mcp.qubitdata.it/mcp.

Claude Desktop

Plot monthly PM2.5 within 2km of (45.4642, 9.19) for 2025. Use environment.arpa_aria_pm25.
Cursor

Aggregate weekly average house price in realestate.ade_omi_quotazioni near my listing for the past 3 years.
Custom MCP client

Daily transit ridership within an isochrone, bucketed for last 90 days.

Get started

Last updated: 2026-05-04