us-drought-monitor-mcp-server
An open-source MCP server that allows AI agents to query U.S. Drought Monitor data, including current severity, historical timeseries, DSCI metrics, population counts, and drought duration across various geographic levels like states, counties, and HUC watersheds.
Endpoint and access
No sign-in to connect and list tools. Individual tools may still need a vendor account, credentials, or permissions; check the documented prerequisites.
MCP endpoint (Streamable HTTP)
https://us-drought-monitor.caseyjhand.com/mcpWhat you can do with it
- Retrieve current drought severity and area percentages for a specific state or county
- Query historical drought metrics and DSCI changes over time
- Look up reference data for drought categories and geographic identifiers
- Rank states or counties by drought coverage or severity changes
Source and maintenance
Community listingRegistry 0.2.0
- Maintenance checked
Protocol and capabilities
- Server
- us-drought-monitor-mcp-server 0.2.0
- MCP protocol
- 2025-06-18
- Tools
- 7 advertised
- Resources
- 1 advertised
- Resource templates
- 1 advertised
- Prompts
- 0 advertised
Server-advertised capabilities
{
"tools": {
"listChanged": true
},
"logging": {},
"prompts": {
"listChanged": true
},
"resources": {
"subscribe": true,
"listChanged": true
},
"extensions": {
"io.modelcontextprotocol/skills": {
"directoryRead": true
}
}
}Server-provided instructions
Untrusted server output shown for inspection. It is not Koskamo guidance and is excluded from knowledge search.
Tools
7 advertised
drought_list_reference — Look up drought reference data
Advertised read-only
Look up drought categories, DSCI formulas, metric support, publication coverage and exact geography identifiers. Filter complete families by nameContains before paging. Use state for counties or climate_divisions; huc requires hucLevel 2, 4, 6 or 8 and accepts a shorter parentHuc. Follow nextCursor with the same filters to browse every match.
drought_list_reference input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"topic"
],
"properties": {
"limit": {
"type": "integer",
"default": 25,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 25 records per page; values above 200 are clamped with disclosure."
},
"state": {
"type": "string",
"maxLength": 200,
"description": "County or climate-division filter: exact state postal code, two-digit FIPS or full name."
},
"topic": {
"enum": [
"categories",
"dsci",
"area_types",
"coverage",
"states",
"counties",
"tribal",
"climate_divisions",
"river_forecast_centers",
"huc"
],
"type": "string",
"description": "Reference family to browse; river_forecast_centers provides official RFC codes and names."
},
"cursor": {
"type": "string",
"maxLength": 2048,
"description": "Continuation cursor from the previous page with the same filters."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "Required for huc; exact identifier width."
},
"parentHuc": {
"type": "string",
"maxLength": 6,
"description": "Existing parent HUC at level 2, 4 or 6, shorter than hucLevel; blank is omitted."
},
"nameContains": {
"type": "string",
"maxLength": 200,
"description": "All normalized tokens must appear in the reference name."
}
},
"additionalProperties": false
}drought_list_reference output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"topic",
"records",
"totalCount",
"nextCursor",
"hasMore",
"bundleVersion",
"sourceMetadata",
"provenance"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"ambiguous_area",
"unknown_area",
"invalid_cursor",
"invalid_reference_filter"
],
"description": "Machine-readable failure mode. Declared by this tool: `ambiguous_area`: Multiple exact normalized names match. `unknown_area`: The county state filter cannot resolve. `invalid_cursor`: The cursor is malformed or filters changed. `invalid_reference_filter`: Filters do not belong to the selected topic. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"topic": {
"enum": [
"categories",
"dsci",
"area_types",
"coverage",
"states",
"counties",
"tribal",
"climate_divisions",
"river_forecast_centers",
"huc"
],
"type": "string",
"description": "Selected reference family."
},
"notice": {
"type": "string",
"description": "Guidance when no names match."
},
"hasMore": {
"type": "boolean",
"description": "Whether another page remains."
},
"records": {
"type": "array",
"items": {
"anyOf": [
{
"type": "object",
"required": [
"areaType",
"id",
"name",
"sourceVintage"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
},
"currentUsdm": {
"type": "boolean",
"description": "Whether the county appears in the acquisition-week USDM response."
},
"sourceVintage": {
"type": "string",
"description": "Source dataset vintage."
}
},
"description": "Canonical geography with source vintage.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"id",
"name",
"description"
],
"properties": {
"id": {
"type": "string",
"description": "Reference record identifier."
},
"name": {
"type": "string",
"description": "Reference label."
},
"metrics": {
"type": "array",
"items": {
"type": "string"
},
"description": "Supported public metrics."
},
"spiSpei": {
"type": "string",
"description": "Official SPI/SPEI range."
},
"percentile": {
"type": "string",
"description": "Official example percentile range."
},
"description": {
"type": "string",
"description": "Definition or interpretation."
},
"identifierFormat": {
"type": "string",
"description": "Accepted identifier syntax."
},
"cumulativeFormula": {
"type": "string",
"description": "DSCI formula using cumulative area percentages."
},
"categoricalFormula": {
"type": "string",
"description": "DSCI formula using categorical area percentages."
}
},
"description": "Named drought definition, coverage note or selector guidance.",
"additionalProperties": false
}
],
"description": "A canonical geography or drought reference definition."
},
"description": "Complete records on this page."
},
"nextCursor": {
"type": [
"string",
"null"
],
"description": "Continuation with identical filters, or null."
},
"provenance": {
"type": "object",
"required": [
"sourceUrls",
"retrievedAt",
"credit",
"dsciCitation",
"dsciExperimental"
],
"properties": {
"credit": {
"type": "string",
"description": "USDM attribution."
},
"sourceUrls": {
"type": "array",
"items": {
"type": "string"
},
"description": "Public source URLs actually used."
},
"retrievedAt": {
"type": "string",
"description": "UTC retrieval timestamp."
},
"dsciCitation": {
"type": "string",
"description": "DSCI citation."
},
"dsciExperimental": {
"type": "boolean",
"const": true,
"description": "DSCI is an experimental index."
},
"populationInterpretation": {
"type": "object",
"required": [
"methodologyUrl",
"caveat"
],
"properties": {
"caveat": {
"type": "string",
"description": "Population assumptions and precision limitations."
},
"methodologyUrl": {
"type": "string",
"description": "Official population estimation methodology."
}
},
"description": "Present when the workflow includes a supported population metric.",
"additionalProperties": false
}
},
"description": "Source attribution and acquisition time.",
"additionalProperties": false
},
"totalCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Count after filtering, before pagination."
},
"limitNotice": {
"type": "string",
"description": "Disclosure when the requested limit was clamped."
},
"bundleVersion": {
"type": "string",
"description": "Generated reference bundle version."
},
"effectiveLimit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Effective page ceiling after clamping to 200."
},
"sourceMetadata": {
"type": "array",
"items": {
"type": "object",
"required": [
"url",
"fetchedAt",
"sha256",
"recordCount",
"vintage"
],
"properties": {
"url": {
"type": "string",
"description": "Official public source URL."
},
"sha256": {
"type": "string",
"pattern": "^[a-f0-9]{64}$",
"description": "SHA-256 of exact source bytes."
},
"vintage": {
"type": "string",
"description": "Dataset vintage or map date."
},
"fetchedAt": {
"type": "string",
"description": "UTC acquisition timestamp."
},
"recordCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": 0,
"description": "Extracted source record count."
}
},
"description": "Acquisition evidence for an official reference source.",
"additionalProperties": false
},
"description": "Source vintages and SHA-256 evidence."
}
},
"additionalProperties": false
}drought_list_reference annotations
{
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}drought_get_current_severity — Get a drought severity snapshot
Advertised read-onlyOpen-world
Get current or dated drought severity, cumulative and categorical area percentages, area square miles, supported population counts and experimental upstream DSCI. Resolve identifiers with drought_list_reference. DSCI changes use exactly 4 and 52 weeks earlier; missing observations remain null. US selects both CONUS and Total.
drought_get_current_severity input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"area"
],
"properties": {
"area": {
"oneOf": [
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "us",
"description": "National geography."
}
},
"description": "National coverage selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "state",
"description": "State geography."
}
},
"description": "Exact state selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "county",
"description": "County geography."
}
},
"description": "Exact county selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "tribal",
"description": "Tribal geography."
}
},
"description": "Exact tribal selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "climate_division",
"description": "Climate division geography."
}
},
"description": "Exact climate division selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "river_forecast_center",
"description": "River Forecast Center geography."
}
},
"description": "Bundled RFC code or exact name.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi",
"hucLevel"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "huc",
"description": "Watershed geography."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "Exact HUC identifier width."
}
},
"description": "Exact watershed selector with matching HUC width.",
"additionalProperties": false
}
],
"description": "One exact geography selector."
},
"date": {
"type": "string",
"pattern": "^(?:|\\d{4}-\\d{2}-\\d{2})$",
"maxLength": 10,
"description": "Calendar date YYYY-MM-DD; defaults to latest published map."
}
},
"additionalProperties": false
}drought_get_current_severity output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"found",
"requestedArea",
"resolvedAreas",
"requestedDate",
"effectiveMapDate",
"latestMapDate",
"availableFrom",
"snapshots",
"guidance",
"provenance"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"upstream_request_rejected",
"ambiguous_area",
"unknown_area",
"invalid_area",
"invalid_date_range",
"publication_unavailable",
"upstream_shape_invalid",
"dataset_too_large"
],
"description": "Machine-readable failure mode. Declared by this tool: `upstream_request_rejected`: USDM rejects a selector or date request. `ambiguous_area`: Several exact names match. `unknown_area`: A geography name cannot resolve. `invalid_area`: Identifier shape is invalid. `invalid_date_range`: The date is not a real calendar date. `publication_unavailable`: No latest publication is available. `upstream_shape_invalid`: Upstream data is malformed, duplicate or outside scope. `dataset_too_large`: The complete snapshot exceeds acquisition or normalized-data quotas. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"found": {
"type": "boolean",
"description": "At least one complete severity snapshot exists."
},
"notice": {
"type": "string",
"description": "Missing observation guidance."
},
"guidance": {
"type": [
"string",
"null"
],
"description": "Missing-data or coverage guidance."
},
"snapshots": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name",
"mapDate",
"validStart",
"validEnd",
"areaPercentCumulative",
"areaPercentCategorical",
"areaSqMilesCumulative",
"populationCountCumulative",
"populationStatus",
"dsci",
"dsciStatus",
"dsciChange4Weeks",
"dsciChange52Weeks"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"dsci": {
"type": [
"number",
"null"
],
"description": "Experimental upstream index, 0–500."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"mapDate": {
"type": "string",
"description": "Exact map date."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
},
"validEnd": {
"type": "string",
"description": "Full Monday validity end."
},
"dsciStatus": {
"enum": [
"available",
"missing"
],
"type": "string",
"description": "Index availability."
},
"validStart": {
"type": "string",
"description": "Full Tuesday validity start."
},
"dsciChange4Weeks": {
"type": "object",
"required": [
"baselineMapDate",
"baselineDsci",
"delta",
"status"
],
"properties": {
"delta": {
"type": [
"number",
"null"
],
"description": "Current minus baseline DSCI index."
},
"status": {
"enum": [
"available",
"before_coverage",
"missing"
],
"type": "string",
"description": "Availability of exact delta."
},
"baselineDsci": {
"type": [
"number",
"null"
],
"description": "Upstream baseline index or null."
},
"baselineMapDate": {
"type": "string",
"description": "Exact baseline Tuesday."
}
},
"description": "Exact 28-day baseline change.",
"additionalProperties": false
},
"populationStatus": {
"enum": [
"available",
"unsupported",
"missing"
],
"type": "string",
"description": "Population support and observation status."
},
"dsciChange52Weeks": {
"type": "object",
"required": [
"baselineMapDate",
"baselineDsci",
"delta",
"status"
],
"properties": {
"delta": {
"type": [
"number",
"null"
],
"description": "Current minus baseline DSCI index."
},
"status": {
"enum": [
"available",
"before_coverage",
"missing"
],
"type": "string",
"description": "Availability of exact delta."
},
"baselineDsci": {
"type": [
"number",
"null"
],
"description": "Upstream baseline index or null."
},
"baselineMapDate": {
"type": "string",
"description": "Exact baseline Tuesday."
}
},
"description": "Exact 364-day baseline change.",
"additionalProperties": false
},
"areaPercentCumulative": {
"type": "object",
"required": [
"none",
"d0_d4",
"d1_d4",
"d2_d4",
"d3_d4",
"d4"
],
"properties": {
"d4": {
"type": [
"number",
"null"
],
"description": "D4."
},
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_d4": {
"type": [
"number",
"null"
],
"description": "D0 through D4."
},
"d1_d4": {
"type": [
"number",
"null"
],
"description": "D1 through D4."
},
"d2_d4": {
"type": [
"number",
"null"
],
"description": "D2 through D4."
},
"d3_d4": {
"type": [
"number",
"null"
],
"description": "D3 through D4."
}
},
"description": "Cumulative area percent.",
"additionalProperties": false
},
"areaSqMilesCumulative": {
"type": "object",
"required": [
"none",
"d0_d4",
"d1_d4",
"d2_d4",
"d3_d4",
"d4"
],
"properties": {
"d4": {
"type": [
"number",
"null"
],
"description": "D4."
},
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_d4": {
"type": [
"number",
"null"
],
"description": "D0 through D4."
},
"d1_d4": {
"type": [
"number",
"null"
],
"description": "D1 through D4."
},
"d2_d4": {
"type": [
"number",
"null"
],
"description": "D2 through D4."
},
"d3_d4": {
"type": [
"number",
"null"
],
"description": "D3 through D4."
}
},
"description": "Cumulative area square miles.",
"additionalProperties": false
},
"areaPercentCategorical": {
"type": "object",
"required": [
"none",
"d0_only",
"d1_only",
"d2_only",
"d3_only",
"d4_only"
],
"properties": {
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_only": {
"type": [
"number",
"null"
],
"description": "D0 only."
},
"d1_only": {
"type": [
"number",
"null"
],
"description": "D1 only."
},
"d2_only": {
"type": [
"number",
"null"
],
"description": "D2 only."
},
"d3_only": {
"type": [
"number",
"null"
],
"description": "D3 only."
},
"d4_only": {
"type": [
"number",
"null"
],
"description": "D4 only."
}
},
"description": "Exclusive area percent.",
"additionalProperties": false
},
"populationCountCumulative": {
"anyOf": [
{
"type": "object",
"required": [
"none",
"d0_d4",
"d1_d4",
"d2_d4",
"d3_d4",
"d4"
],
"properties": {
"d4": {
"type": [
"number",
"null"
],
"description": "D4."
},
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_d4": {
"type": [
"number",
"null"
],
"description": "D0 through D4."
},
"d1_d4": {
"type": [
"number",
"null"
],
"description": "D1 through D4."
},
"d2_d4": {
"type": [
"number",
"null"
],
"description": "D2 through D4."
},
"d3_d4": {
"type": [
"number",
"null"
],
"description": "D3 through D4."
}
},
"description": "Overlapping cumulative drought severity buckets.",
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Cumulative population estimates in people, or null; see provenance.populationInterpretation."
}
},
"description": "Exact-week severity components and authoritative index changes.",
"additionalProperties": false
},
"description": "Complete required severity components for each area."
},
"provenance": {
"type": "object",
"required": [
"sourceUrls",
"retrievedAt",
"credit",
"dsciCitation",
"dsciExperimental"
],
"properties": {
"credit": {
"type": "string",
"description": "USDM attribution."
},
"sourceUrls": {
"type": "array",
"items": {
"type": "string"
},
"description": "Public source URLs actually used."
},
"retrievedAt": {
"type": "string",
"description": "UTC retrieval timestamp."
},
"dsciCitation": {
"type": "string",
"description": "DSCI citation."
},
"dsciExperimental": {
"type": "boolean",
"const": true,
"description": "DSCI is an experimental index."
},
"populationInterpretation": {
"type": "object",
"required": [
"methodologyUrl",
"caveat"
],
"properties": {
"caveat": {
"type": "string",
"description": "Population assumptions and precision limitations."
},
"methodologyUrl": {
"type": "string",
"description": "Official population estimation methodology."
}
},
"description": "Present when the workflow includes a supported population metric.",
"additionalProperties": false
}
},
"description": "Actual sources and attribution.",
"additionalProperties": false
},
"availableFrom": {
"type": "string",
"description": "First published map."
},
"latestMapDate": {
"type": "string",
"description": "Latest actually published map."
},
"requestedArea": {
"oneOf": [
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "us",
"description": "National geography."
}
},
"description": "National coverage selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "state",
"description": "State geography."
}
},
"description": "Exact state selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "county",
"description": "County geography."
}
},
"description": "Exact county selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "tribal",
"description": "Tribal geography."
}
},
"description": "Exact tribal selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "climate_division",
"description": "Climate division geography."
}
},
"description": "Exact climate division selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "river_forecast_center",
"description": "River Forecast Center geography."
}
},
"description": "Bundled RFC code or exact name.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi",
"hucLevel"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "huc",
"description": "Watershed geography."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "Exact HUC identifier width."
}
},
"description": "Exact watershed selector with matching HUC width.",
"additionalProperties": false
}
],
"description": "Original selector."
},
"requestedDate": {
"type": [
"string",
"null"
],
"description": "Requested date, or null for latest."
},
"resolvedAreas": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Canonical geography identity and known state or watershed attributes.",
"additionalProperties": false
},
"description": "Resolved canonical areas."
},
"effectiveMapDate": {
"type": [
"string",
"null"
],
"description": "Containing Tuesday."
}
},
"additionalProperties": false
}drought_get_current_severity annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}drought_get_timeseries — Get weekly drought observations
Advertised read-onlyOpen-world
Get weekly drought metrics and experimental DSCI for 1–100 explicit areas sharing one geography type and HUC level. Resolve identifiers with drought_list_reference. Dates select inclusive Tuesday map weeks. Missing values remain null; summaries include every tied peak. Large results are staged when analytics is enabled; use the returned dataframe tools to read every row and retained metadata page. Without analytics, complete results remain inline within acquisition limits.
drought_get_timeseries input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"areas",
"startDate",
"endDate"
],
"properties": {
"areas": {
"type": "array",
"items": {
"oneOf": [
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "us",
"description": "National geography."
}
},
"description": "National coverage selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "state",
"description": "State geography."
}
},
"description": "Exact state selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "county",
"description": "County geography."
}
},
"description": "Exact county selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "tribal",
"description": "Tribal geography."
}
},
"description": "Exact tribal selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "climate_division",
"description": "Climate division geography."
}
},
"description": "Exact climate division selector.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "river_forecast_center",
"description": "River Forecast Center geography."
}
},
"description": "Bundled RFC code or exact name.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"areaType",
"aoi",
"hucLevel"
],
"properties": {
"aoi": {
"type": "string",
"maxLength": 200,
"minLength": 1,
"description": "Exact geography identifier or state name; county names require a state and resolve exact names before unique suffix-free aliases."
},
"areaType": {
"type": "string",
"const": "huc",
"description": "Watershed geography."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "Exact HUC identifier width."
}
},
"description": "Exact watershed selector with matching HUC width.",
"additionalProperties": false
}
],
"description": "One supported geography and its exact identifier."
},
"maxItems": 100,
"minItems": 1,
"description": "Explicit homogeneous geographies."
},
"metric": {
"enum": [
"area_percent",
"area_sq_miles",
"population_percent",
"population_count"
],
"type": "string",
"default": "area_percent",
"description": "Measure; population supports US, state and county only and carries estimation assumptions in provenance.populationInterpretation."
},
"endDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Last requested calendar date, YYYY-MM-DD."
},
"canvas_id": {
"anyOf": [
{
"type": "string",
"const": ""
},
{
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Canvas ID as an earlier response on this server returned it — exactly 10 characters of letters, digits, hyphens, and underscores."
}
],
"description": "Canvas token from a previous drought producer to reuse when staging."
},
"startDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "First requested calendar date, YYYY-MM-DD."
},
"statisticsType": {
"enum": [
"cumulative",
"categorical"
],
"type": "string",
"default": "cumulative",
"description": "Overlapping cumulative or exclusive categorical buckets."
}
},
"additionalProperties": false
}drought_get_timeseries output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"areas",
"requestedRange",
"effectiveRange",
"latestMapDate",
"metric",
"statisticsType",
"unit",
"rows",
"rowCount",
"missingAreas",
"missingObservations",
"summary",
"staging",
"provenance"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name",
"row_id",
"mapDate",
"validStart",
"validEnd",
"metric",
"statisticsType",
"unit",
"buckets",
"dsci",
"dsciStatus"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"dsci": {
"type": [
"number",
"null"
],
"description": "Experimental upstream DSCI index, 0–500."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"unit": {
"type": "string",
"description": "Bucket units."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"metric": {
"enum": [
"area_percent",
"area_sq_miles",
"population_percent",
"population_count"
],
"type": "string",
"description": "Requested measure."
},
"row_id": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Stable one-based row index."
},
"buckets": {
"anyOf": [
{
"type": "object",
"required": [
"none",
"d0_d4",
"d1_d4",
"d2_d4",
"d3_d4",
"d4"
],
"properties": {
"d4": {
"type": [
"number",
"null"
],
"description": "D4."
},
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_d4": {
"type": [
"number",
"null"
],
"description": "D0 through D4."
},
"d1_d4": {
"type": [
"number",
"null"
],
"description": "D1 through D4."
},
"d2_d4": {
"type": [
"number",
"null"
],
"description": "D2 through D4."
},
"d3_d4": {
"type": [
"number",
"null"
],
"description": "D3 through D4."
}
},
"description": "Overlapping cumulative drought severity buckets.",
"additionalProperties": false
},
{
"type": "object",
"required": [
"none",
"d0_only",
"d1_only",
"d2_only",
"d3_only",
"d4_only"
],
"properties": {
"none": {
"type": [
"number",
"null"
],
"description": "No drought."
},
"d0_only": {
"type": [
"number",
"null"
],
"description": "D0 only."
},
"d1_only": {
"type": [
"number",
"null"
],
"description": "D1 only."
},
"d2_only": {
"type": [
"number",
"null"
],
"description": "D2 only."
},
"d3_only": {
"type": [
"number",
"null"
],
"description": "D3 only."
},
"d4_only": {
"type": [
"number",
"null"
],
"description": "D4 only."
}
},
"description": "Mutually exclusive drought severity buckets.",
"additionalProperties": false
}
],
"description": "Named source buckets."
},
"mapDate": {
"type": "string",
"description": "Tuesday map date."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
},
"validEnd": {
"type": "string",
"description": "Full map validity end."
},
"dsciStatus": {
"enum": [
"available",
"missing"
],
"type": "string",
"description": "Whether upstream DSCI is available."
},
"validStart": {
"type": "string",
"description": "Full map validity start."
},
"statisticsType": {
"enum": [
"cumulative",
"categorical"
],
"type": "string",
"description": "Bucket representation."
}
},
"description": "One geography and map week with source metric buckets and DSCI.",
"additionalProperties": false
},
"description": "Complete inline rows or exact staged preview."
},
"unit": {
"type": "string",
"description": "Bucket unit."
},
"areas": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Canonical geography identity and known state or watershed attributes.",
"additionalProperties": false
},
"description": "Resolved deduplicated areas."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"upstream_request_rejected",
"staging_busy",
"ambiguous_area",
"unknown_area",
"invalid_area",
"unsupported_metric",
"invalid_date_range",
"publication_unavailable",
"dataset_too_large",
"upstream_shape_invalid",
"canvas_unavailable",
"staging_capacity_exhausted",
"canvas_not_found",
"canvas_capacity_exhausted"
],
"description": "Machine-readable failure mode. Declared by this tool: `upstream_request_rejected`: USDM rejects a selector or date request. `staging_busy`: The bounded acquisition admission slots are occupied. `ambiguous_area`: Several exact names match. `unknown_area`: A geography name cannot resolve. `invalid_area`: Identifier or homogeneous area combination is invalid. `unsupported_metric`: Population is requested for an unsupported geography. `invalid_date_range`: Dates are impossible or reversed. `publication_unavailable`: No latest publication is available. `dataset_too_large`: The complete request exceeds acquisition or retained-data quotas. `upstream_shape_invalid`: Upstream data is malformed, duplicate or outside scope. `canvas_unavailable`: An explicit canvas token requires an unavailable analytical provider. `staging_capacity_exhausted`: Retained analytical capacity is exhausted. `canvas_not_found`: The supplied canvas is absent or expired. `canvas_capacity_exhausted`: The analytical provider cannot mint another canvas. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"metric": {
"enum": [
"area_percent",
"area_sq_miles",
"population_percent",
"population_count"
],
"type": "string",
"description": "Selected metric."
},
"notice": {
"type": "string",
"description": "Empty or partial-data guidance."
},
"staging": {
"anyOf": [
{
"type": "object",
"required": [
"canvas_id",
"table_name",
"row_count",
"columns",
"expires_at",
"describe_tool",
"query_tool"
],
"properties": {
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type",
"unit"
],
"properties": {
"name": {
"type": "string",
"description": "Column name."
},
"type": {
"type": "string",
"description": "SQL type."
},
"unit": {
"type": [
"string",
"null"
],
"description": "Physical unit or null."
}
},
"description": "One registered SQL column and its physical unit.",
"additionalProperties": false
},
"description": "Explicit column schema."
},
"canvas_id": {
"type": "string",
"description": "Canvas access token."
},
"row_count": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete row count."
},
"expires_at": {
"type": "string",
"description": "Actual table expiry."
},
"query_tool": {
"type": "string",
"const": "drought_dataframe_query",
"description": "Complete row reader."
},
"table_name": {
"type": "string",
"description": "Registered table."
},
"describe_tool": {
"type": "string",
"const": "drought_dataframe_describe",
"description": "Metadata reader."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Complete analytical table when staged."
},
"summary": {
"type": "array",
"items": {
"type": "object",
"required": [
"area",
"observationCount",
"firstMapDate",
"lastMapDate",
"peakDsci",
"peakD3D4"
],
"properties": {
"area": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Canonical area.",
"additionalProperties": false
},
"peakD3D4": {
"anyOf": [
{
"type": "object",
"required": [
"value",
"mapDateRuns",
"unit"
],
"properties": {
"unit": {
"type": "string",
"description": "Bucket measure unit."
},
"value": {
"type": "number",
"description": "Peak measured value."
},
"mapDateRuns": {
"type": "array",
"items": {
"type": "object",
"required": [
"startMapDate",
"endMapDate",
"stepDays"
],
"properties": {
"stepDays": {
"type": "number",
"const": 7,
"description": "Seven-day step."
},
"endMapDate": {
"type": "string",
"description": "Last Tuesday."
},
"startMapDate": {
"type": "string",
"description": "First Tuesday."
}
},
"description": "Inclusive run of Tuesday map dates separated by seven days.",
"additionalProperties": false
},
"description": "Every tied peak date."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Peak D3 through D4 and all ties."
},
"peakDsci": {
"anyOf": [
{
"type": "object",
"required": [
"value",
"mapDateRuns"
],
"properties": {
"value": {
"type": "number",
"description": "Peak measured value."
},
"mapDateRuns": {
"type": "array",
"items": {
"type": "object",
"required": [
"startMapDate",
"endMapDate",
"stepDays"
],
"properties": {
"stepDays": {
"type": "number",
"const": 7,
"description": "Seven-day step."
},
"endMapDate": {
"type": "string",
"description": "Last Tuesday."
},
"startMapDate": {
"type": "string",
"description": "First Tuesday."
}
},
"description": "Inclusive run of Tuesday map dates separated by seven days.",
"additionalProperties": false
},
"description": "Every tied peak date."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Peak experimental index and all ties."
},
"lastMapDate": {
"type": [
"string",
"null"
],
"description": "Last observed week."
},
"firstMapDate": {
"type": [
"string",
"null"
],
"description": "First observed week."
},
"observationCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Returned weekly rows."
}
},
"description": "Complete-series coverage and tied severity peaks for one area.",
"additionalProperties": false
},
"description": "Full-data area summaries."
},
"guidance": {
"type": "string",
"description": "Coverage guidance for known legacy Connecticut counties."
},
"rowCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete observation count."
},
"provenance": {
"type": "object",
"required": [
"sourceUrls",
"retrievedAt",
"credit",
"dsciCitation",
"dsciExperimental"
],
"properties": {
"credit": {
"type": "string",
"description": "USDM attribution."
},
"sourceUrls": {
"type": "array",
"items": {
"type": "string"
},
"description": "Public source URLs actually used."
},
"retrievedAt": {
"type": "string",
"description": "UTC retrieval timestamp."
},
"dsciCitation": {
"type": "string",
"description": "DSCI citation."
},
"dsciExperimental": {
"type": "boolean",
"const": true,
"description": "DSCI is an experimental index."
},
"populationInterpretation": {
"type": "object",
"required": [
"methodologyUrl",
"caveat"
],
"properties": {
"caveat": {
"type": "string",
"description": "Population assumptions and precision limitations."
},
"methodologyUrl": {
"type": "string",
"description": "Official population estimation methodology."
}
},
"description": "Present when the workflow includes a supported population metric.",
"additionalProperties": false
}
},
"description": "Actual sources and attribution.",
"additionalProperties": false
},
"missingAreas": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Canonical geography identity and known state or watershed attributes.",
"additionalProperties": false
},
"description": "Areas without metric observations."
},
"latestMapDate": {
"type": "string",
"description": "Latest map actually published."
},
"effectiveRange": {
"anyOf": [
{
"type": "object",
"required": [
"startDate",
"endDate"
],
"properties": {
"endDate": {
"type": "string",
"description": "Last inclusive date."
},
"startDate": {
"type": "string",
"description": "First inclusive date."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Published coverage intersection."
},
"metadata_pages": {
"type": "object",
"description": "Present only when complete metadata requires automatic continuation.",
"propertyNames": {
"enum": [
"areas",
"summary",
"missingAreas",
"missingObservations"
],
"type": "string"
},
"additionalProperties": {
"type": "object",
"required": [
"total",
"returned",
"next_offset"
],
"properties": {
"total": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": 0,
"description": "Complete retained collection size."
},
"returned": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": 0,
"description": "Items in this inline first prefix."
},
"next_offset": {
"anyOf": [
{
"type": "integer",
"maximum": 9007199254740991,
"minimum": 0
},
{
"type": "null"
}
],
"description": "Continue with drought_dataframe_describe metadata_field and this offset, or null."
}
},
"additionalProperties": false
}
},
"requestedRange": {
"type": "object",
"required": [
"startDate",
"endDate"
],
"properties": {
"endDate": {
"type": "string",
"description": "Last inclusive date."
},
"startDate": {
"type": "string",
"description": "First inclusive date."
}
},
"description": "Original requested dates.",
"additionalProperties": false
},
"statisticsType": {
"enum": [
"cumulative",
"categorical"
],
"type": "string",
"description": "Selected representation."
},
"missingObservations": {
"type": "array",
"items": {
"type": "object",
"required": [
"area",
"component",
"count",
"mapDateRuns"
],
"properties": {
"area": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Requested area.",
"additionalProperties": false
},
"count": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Missing weekly observations."
},
"component": {
"enum": [
"metric",
"dsci"
],
"type": "string",
"description": "Missing source component."
},
"mapDateRuns": {
"type": "array",
"items": {
"type": "object",
"required": [
"startMapDate",
"endMapDate",
"stepDays"
],
"properties": {
"stepDays": {
"type": "number",
"const": 7,
"description": "Seven-day step."
},
"endMapDate": {
"type": "string",
"description": "Last Tuesday."
},
"startMapDate": {
"type": "string",
"description": "First Tuesday."
}
},
"description": "Inclusive run of Tuesday map dates separated by seven days.",
"additionalProperties": false
},
"description": "Every missing date in lossless runs."
}
},
"description": "All absent weeks for one geography and source component.",
"additionalProperties": false
},
"description": "Missing metric and DSCI dates."
}
},
"additionalProperties": false
}drought_get_timeseries annotations
{
"readOnlyHint": true,
"openWorldHint": true
}drought_compare_areas — Compare drought severity across areas
Advertised read-onlyOpen-world
Rank all supported states, or counties within an optional state, on one published map. Omit state for nationwide supported counties. With baselineDate, rank target minus exact baseline; missing sides are excluded explicitly. Equal values share competition rank. limit controls a staged preview; without analytics, complete rankings remain inline within acquisition limits.
drought_compare_areas input schema
{
"type": "object",
"oneOf": [
{
"type": "object",
"required": [
"scope"
],
"properties": {
"date": {
"type": "string",
"pattern": "^(?:|\\d{4}-\\d{2}-\\d{2})$",
"maxLength": 10,
"description": "Target calendar date; defaults to latest published map."
},
"limit": {
"type": "integer",
"default": 20,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 20 preview rows; values above 200 are clamped with disclosure."
},
"scope": {
"type": "string",
"const": "states",
"description": "All supported states."
},
"metric": {
"enum": [
"dsci",
"d2_d4",
"d3_d4"
],
"type": "string",
"default": "dsci",
"description": "Experimental DSCI or cumulative area percentage."
},
"canvas_id": {
"anyOf": [
{
"type": "string",
"const": ""
},
{
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Canvas ID as an earlier response on this server returned it — exactly 10 characters of letters, digits, hyphens, and underscores."
}
],
"description": "Canvas token from an earlier drought producer to reuse."
},
"direction": {
"enum": [
"asc",
"desc"
],
"type": "string",
"default": "desc",
"description": "Order by severity or baseline change."
},
"baselineDate": {
"type": "string",
"pattern": "^(?:|\\d{4}-\\d{2}-\\d{2})$",
"maxLength": 10,
"description": "Optional exact baseline date, no later than target."
}
},
"additionalProperties": false
},
{
"type": "object",
"required": [
"scope"
],
"properties": {
"date": {
"type": "string",
"pattern": "^(?:|\\d{4}-\\d{2}-\\d{2})$",
"maxLength": 10,
"description": "Target calendar date; defaults to latest published map."
},
"limit": {
"type": "integer",
"default": 20,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 20 preview rows; values above 200 are clamped with disclosure."
},
"scope": {
"type": "string",
"const": "counties",
"description": "Supported counties."
},
"state": {
"type": "string",
"maxLength": 200,
"description": "Exact state postal, FIPS or full name; omitted means nationwide."
},
"metric": {
"enum": [
"dsci",
"d2_d4",
"d3_d4"
],
"type": "string",
"default": "dsci",
"description": "Experimental DSCI or cumulative area percentage."
},
"canvas_id": {
"anyOf": [
{
"type": "string",
"const": ""
},
{
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Canvas ID as an earlier response on this server returned it — exactly 10 characters of letters, digits, hyphens, and underscores."
}
],
"description": "Canvas token from an earlier drought producer to reuse."
},
"direction": {
"enum": [
"asc",
"desc"
],
"type": "string",
"default": "desc",
"description": "Order by severity or baseline change."
},
"baselineDate": {
"type": "string",
"pattern": "^(?:|\\d{4}-\\d{2}-\\d{2})$",
"maxLength": 10,
"description": "Optional exact baseline date, no later than target."
}
},
"additionalProperties": false
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema"
}drought_compare_areas output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"scope",
"state",
"includedStates",
"metric",
"unit",
"changeUnit",
"targetMapDate",
"baselineMapDate",
"rows",
"comparedCount",
"excludedAreas",
"staging",
"provenance",
"totalCount"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"rows": {
"type": "array",
"items": {
"type": "object",
"required": [
"areaType",
"id",
"name",
"row_id",
"targetValue",
"baselineValue",
"change",
"rankedValue",
"rank"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"rank": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Competition rank, preserving ties."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"change": {
"type": [
"number",
"null"
],
"description": "Target minus baseline in changeUnit."
},
"row_id": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Stable sorted row index."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
},
"rankedValue": {
"type": "number",
"description": "Value used for ordering."
},
"targetValue": {
"type": "number",
"description": "Target severity in output unit."
},
"baselineValue": {
"type": [
"number",
"null"
],
"description": "Baseline severity or null."
}
},
"description": "One ranked area with target severity and optional exact baseline.",
"additionalProperties": false
},
"description": "Complete ranking or staged preview."
},
"unit": {
"enum": [
"index",
"percent"
],
"type": "string",
"description": "Severity unit."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"upstream_request_rejected",
"staging_busy",
"ambiguous_area",
"unknown_area",
"invalid_area",
"invalid_date_range",
"publication_unavailable",
"dataset_too_large",
"upstream_shape_invalid",
"canvas_unavailable",
"staging_capacity_exhausted",
"canvas_not_found",
"canvas_capacity_exhausted"
],
"description": "Machine-readable failure mode. Declared by this tool: `upstream_request_rejected`: USDM rejects a selector or date request. `staging_busy`: The bounded acquisition admission slots are occupied. `ambiguous_area`: Several exact names match. `unknown_area`: The state name cannot resolve. `invalid_area`: State is used with the wrong scope. `invalid_date_range`: Dates are impossible or baseline follows target. `publication_unavailable`: No latest publication is available. `dataset_too_large`: The complete request exceeds acquisition or retained-data quotas. `upstream_shape_invalid`: Upstream data is malformed, duplicate or outside scope. `canvas_unavailable`: An explicit canvas token requires an unavailable analytical provider. `staging_capacity_exhausted`: Retained analytical capacity is exhausted. `canvas_not_found`: The supplied canvas is absent or expired. `canvas_capacity_exhausted`: The provider cannot mint another canvas. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"scope": {
"enum": [
"states",
"counties"
],
"type": "string",
"description": "Compared geography scope."
},
"state": {
"type": [
"string",
"null"
],
"description": "Resolved county state or null."
},
"metric": {
"enum": [
"dsci",
"d2_d4",
"d3_d4"
],
"type": "string",
"description": "Compared severity measure."
},
"notice": {
"type": "string",
"description": "Empty comparison or preview continuation guidance."
},
"staging": {
"anyOf": [
{
"type": "object",
"required": [
"canvas_id",
"table_name",
"row_count",
"columns",
"expires_at",
"describe_tool",
"query_tool"
],
"properties": {
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type",
"unit"
],
"properties": {
"name": {
"type": "string",
"description": "Column name."
},
"type": {
"type": "string",
"description": "SQL type."
},
"unit": {
"type": [
"string",
"null"
],
"description": "Physical unit or null."
}
},
"description": "One registered SQL column and its physical unit.",
"additionalProperties": false
},
"description": "Explicit column schema."
},
"canvas_id": {
"type": "string",
"description": "Canvas access token."
},
"row_count": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete row count."
},
"expires_at": {
"type": "string",
"description": "Actual table expiry."
},
"query_tool": {
"type": "string",
"const": "drought_dataframe_query",
"description": "Complete row reader."
},
"table_name": {
"type": "string",
"description": "Registered table."
},
"describe_tool": {
"type": "string",
"const": "drought_dataframe_describe",
"description": "Metadata reader."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Complete ranking table when staged."
},
"changeUnit": {
"enum": [
"index",
"percentage_points"
],
"type": "string",
"description": "Difference unit."
},
"provenance": {
"type": "object",
"required": [
"sourceUrls",
"retrievedAt",
"credit",
"dsciCitation",
"dsciExperimental"
],
"properties": {
"credit": {
"type": "string",
"description": "USDM attribution."
},
"sourceUrls": {
"type": "array",
"items": {
"type": "string"
},
"description": "Public source URLs actually used."
},
"retrievedAt": {
"type": "string",
"description": "UTC retrieval timestamp."
},
"dsciCitation": {
"type": "string",
"description": "DSCI citation."
},
"dsciExperimental": {
"type": "boolean",
"const": true,
"description": "DSCI is an experimental index."
},
"populationInterpretation": {
"type": "object",
"required": [
"methodologyUrl",
"caveat"
],
"properties": {
"caveat": {
"type": "string",
"description": "Population assumptions and precision limitations."
},
"methodologyUrl": {
"type": "string",
"description": "Official population estimation methodology."
}
},
"description": "Present when the workflow includes a supported population metric.",
"additionalProperties": false
}
},
"description": "Actual sources and attribution.",
"additionalProperties": false
},
"totalCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete comparable population before preview selection."
},
"limitNotice": {
"type": "string",
"description": "Disclosure when the requested limit was clamped."
},
"comparedCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete comparable population."
},
"excludedAreas": {
"type": "array",
"items": {
"type": "object",
"required": [
"area",
"missing"
],
"properties": {
"area": {
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Excluded geography.",
"additionalProperties": false
},
"missing": {
"type": "array",
"items": {
"enum": [
"target",
"baseline"
],
"type": "string"
},
"description": "Missing comparison sides."
}
},
"description": "One excluded area and its missing comparison sides.",
"additionalProperties": false
},
"description": "Every area lacking a required value."
},
"targetMapDate": {
"type": "string",
"description": "Exact target Tuesday."
},
"effectiveLimit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Effective preview ceiling after clamping to 200."
},
"includedStates": {
"type": "array",
"items": {
"type": "string"
},
"description": "Actual supported included state postal codes."
},
"baselineMapDate": {
"type": [
"string",
"null"
],
"description": "Exact baseline Tuesday or null."
}
},
"additionalProperties": false
}drought_compare_areas annotations
{
"readOnlyHint": true,
"openWorldHint": true
}drought_get_weeks_in_drought — Get county weeks in drought
Advertised read-onlyOpen-world
Get authoritative consecutive streaks or non-consecutive week counts when any county area meets the selected drought category or worse. Supply states or one county, never both; omitted selectors mean supported nationwide counties. Counts are duration statistics, not program eligibility. Follow nextCursor with unchanged filters within five minutes.
drought_get_weeks_in_drought input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"startDate",
"endDate",
"minCategory",
"minWeeks"
],
"properties": {
"mode": {
"enum": [
"consecutive",
"non_consecutive"
],
"type": "string",
"default": "consecutive",
"description": "Window-bounded consecutive streaks or qualifying week counts."
},
"limit": {
"type": "integer",
"default": 25,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 25 rows per page; values above 200 are clamped with disclosure."
},
"county": {
"type": "string",
"maxLength": 200,
"description": "County FIPS or exact/unique suffix-free county name, state; mutually exclusive with states."
},
"cursor": {
"type": "string",
"maxLength": 2048,
"description": "Continuation returned with identical filters."
},
"states": {
"type": "array",
"items": {
"type": "string",
"maxLength": 200
},
"maxItems": 54,
"minItems": 1,
"description": "Exact state postal, FIPS or full names; mutually exclusive with county."
},
"endDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "Last requested date, YYYY-MM-DD."
},
"minWeeks": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": 1,
"description": "Minimum weeks, no more than requested inclusive map weeks."
},
"startDate": {
"type": "string",
"pattern": "^\\d{4}-\\d{2}-\\d{2}$",
"description": "First requested date, YYYY-MM-DD."
},
"minCategory": {
"enum": [
"D0",
"D1",
"D2",
"D3",
"D4"
],
"type": "string",
"description": "Minimum drought category."
}
},
"additionalProperties": false
}drought_get_weeks_in_drought output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"mode",
"minCategory",
"minWeeks",
"thresholdRule",
"states",
"county",
"requestedRange",
"effectiveRange",
"latestMapDate",
"rows",
"totalCount",
"nextCursor",
"hasMore",
"provenance"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"mode": {
"enum": [
"consecutive",
"non_consecutive"
],
"type": "string",
"description": "Selected duration mode."
},
"rows": {
"type": "array",
"items": {
"type": "object",
"required": [
"fips",
"county",
"state"
],
"properties": {
"fips": {
"type": "string",
"description": "Five-digit county FIPS."
},
"state": {
"type": "string",
"description": "State postal code."
},
"county": {
"type": "string",
"description": "County name."
},
"endDate": {
"type": "string",
"description": "Observed consecutive streak Monday end within the effective window."
},
"startDate": {
"type": "string",
"description": "Observed consecutive streak start within the effective window."
},
"endMayContinue": {
"type": "boolean",
"description": "Monday end touches the effective window boundary; later continuation is unknown."
},
"consecutiveWeeks": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Consecutive map weeks."
},
"nonConsecutiveWeeks": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Qualifying map-week count."
},
"startMayExtendEarlier": {
"type": "boolean",
"description": "Start touches the effective window boundary; earlier continuation is unknown."
}
},
"description": "County drought duration reported by the official upstream source.",
"additionalProperties": false
},
"description": "Complete authoritative rows on this page."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"upstream_request_rejected",
"ambiguous_area",
"unknown_area",
"invalid_area",
"invalid_date_range",
"publication_unavailable",
"dataset_too_large",
"upstream_shape_invalid",
"invalid_cursor"
],
"description": "Machine-readable failure mode. Declared by this tool: `upstream_request_rejected`: USDM rejects a selector or date request. `ambiguous_area`: Several exact county names match. `unknown_area`: A county or state cannot resolve. `invalid_area`: Identifier or selector combination is invalid. `invalid_date_range`: Dates are impossible, reversed or shorter than minWeeks. `publication_unavailable`: No latest publication is available. `dataset_too_large`: Complete duration acquisition or cache exceeds resource quotas. `upstream_shape_invalid`: Upstream durations are malformed or duplicate. `invalid_cursor`: Continuation is malformed, expired or filters changed. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"county": {
"anyOf": [
{
"type": "object",
"required": [
"areaType",
"id",
"name"
],
"properties": {
"id": {
"type": "string",
"description": "Canonical identifier, preserving leading zeroes."
},
"name": {
"type": "string",
"description": "Source geography name."
},
"state": {
"type": "string",
"description": "State postal code where known."
},
"areaType": {
"enum": [
"us",
"state",
"county",
"huc",
"tribal",
"climate_division",
"river_forecast_center"
],
"type": "string",
"description": "Geography family."
},
"hucLevel": {
"anyOf": [
{
"type": "number",
"const": 2
},
{
"type": "number",
"const": 4
},
{
"type": "number",
"const": 6
},
{
"type": "number",
"const": 8
}
],
"description": "HUC width for watershed areas."
}
},
"description": "Canonical geography identity and known state or watershed attributes.",
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Resolved exact county or null."
},
"notice": {
"type": "string",
"description": "Empty threshold or coverage guidance."
},
"states": {
"type": "array",
"items": {
"type": "string"
},
"description": "Resolved supported state postal codes."
},
"hasMore": {
"type": "boolean",
"description": "Another page remains."
},
"guidance": {
"type": "string",
"description": "Coverage guidance for known legacy Connecticut counties."
},
"minWeeks": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Minimum qualifying map weeks."
},
"nextCursor": {
"type": [
"string",
"null"
],
"description": "Query-bound continuation, or null."
},
"provenance": {
"type": "object",
"required": [
"sourceUrls",
"retrievedAt",
"credit",
"dsciCitation",
"dsciExperimental"
],
"properties": {
"credit": {
"type": "string",
"description": "USDM attribution."
},
"sourceUrls": {
"type": "array",
"items": {
"type": "string"
},
"description": "Public source URLs actually used."
},
"retrievedAt": {
"type": "string",
"description": "UTC retrieval timestamp."
},
"dsciCitation": {
"type": "string",
"description": "DSCI citation."
},
"dsciExperimental": {
"type": "boolean",
"const": true,
"description": "DSCI is an experimental index."
},
"populationInterpretation": {
"type": "object",
"required": [
"methodologyUrl",
"caveat"
],
"properties": {
"caveat": {
"type": "string",
"description": "Population assumptions and precision limitations."
},
"methodologyUrl": {
"type": "string",
"description": "Official population estimation methodology."
}
},
"description": "Present when the workflow includes a supported population metric.",
"additionalProperties": false
}
},
"description": "Actual sources and attribution.",
"additionalProperties": false
},
"totalCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Full filtered result count."
},
"limitNotice": {
"type": "string",
"description": "Disclosure when the requested limit was clamped."
},
"minCategory": {
"enum": [
"D0",
"D1",
"D2",
"D3",
"D4"
],
"type": "string",
"description": "Minimum category."
},
"latestMapDate": {
"type": "string",
"description": "Latest actually published map."
},
"thresholdRule": {
"type": "string",
"const": "any_area_at_or_above",
"description": "County qualifies if any area meets category or worse."
},
"effectiveLimit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Effective page ceiling after clamping to 200."
},
"effectiveRange": {
"anyOf": [
{
"type": "object",
"required": [
"startDate",
"endDate"
],
"properties": {
"endDate": {
"type": "string",
"description": "Last inclusive date."
},
"startDate": {
"type": "string",
"description": "First inclusive date."
}
},
"additionalProperties": false
},
{
"type": "null"
}
],
"description": "Published map-week coverage intersection."
},
"requestedRange": {
"type": "object",
"required": [
"startDate",
"endDate"
],
"properties": {
"endDate": {
"type": "string",
"description": "Last inclusive date."
},
"startDate": {
"type": "string",
"description": "First inclusive date."
}
},
"description": "Original dates.",
"additionalProperties": false
}
},
"additionalProperties": false
}drought_get_weeks_in_drought annotations
{
"readOnlyHint": true,
"openWorldHint": true,
"idempotentHint": true
}drought_dataframe_query — Query staged drought data
Advertised read-only
Run one DuckDB read expression against staged drought tables, optionally ending with one semicolon. Get canvas_id from drought_get_timeseries or drought_compare_areas and inspect columns with drought_dataframe_describe. For every original row, SELECT * FROM the table ORDER BY row_id and follow next_offset until null. Arbitrary SQL pagination requires your own stable ORDER BY. Exact totals require SELECT COUNT(*).
drought_dataframe_query input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"canvas_id",
"sql"
],
"properties": {
"sql": {
"type": "string",
"maxLength": 16384,
"minLength": 1,
"description": "One DuckDB read expression with an optional terminal semicolon; staged tables only."
},
"limit": {
"type": "integer",
"default": 25,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 25 rows per page; values above 500 are clamped with disclosure."
},
"offset": {
"type": "integer",
"default": 0,
"maximum": 250000,
"minimum": 0,
"description": "Rows to skip in the stable ordered query."
},
"canvas_id": {
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Token returned by a drought producer."
}
},
"additionalProperties": false
}drought_dataframe_query output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"canvas_id",
"columns",
"rows",
"returnedCount",
"offset",
"next_offset",
"has_more",
"countIsExact",
"tableMetadata"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"cap": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Requested maximum page rows."
},
"rows": {
"type": "array",
"items": {
"type": "object",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"description": "Complete projected values on this page."
},
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"canvas_unavailable",
"canvas_not_found",
"missing_table",
"invalid_sql",
"sql_execution_error",
"sql_read_only",
"staging_busy"
],
"description": "Machine-readable failure mode. Declared by this tool: `canvas_unavailable`: Analytical provider is disabled or unavailable. `canvas_not_found`: Token is absent, expired or belongs to another tenant. `missing_table`: A named staged table is absent. `invalid_sql`: SQL cannot parse or bind. `sql_execution_error`: A data conversion or range expression fails. `sql_read_only`: SQL gate rejects a write, external read or system catalog. `staging_busy`: Two queries are already active in this process. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"shown": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete rows shown on the truncated page."
},
"notice": {
"type": "string",
"description": "Empty-result or continuation guidance."
},
"offset": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Rows skipped by this query."
},
"columns": {
"type": "array",
"items": {
"type": "string"
},
"description": "Projected column names in order."
},
"has_more": {
"type": "boolean",
"description": "Whether another page remains."
},
"canvas_id": {
"type": "string",
"description": "Supplied canvas token."
},
"truncated": {
"type": "boolean",
"description": "More query rows remain beyond this page."
},
"limitNotice": {
"type": "string",
"description": "Disclosure when the requested limit was clamped."
},
"next_offset": {
"anyOf": [
{
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991
},
{
"type": "null"
}
],
"description": "Continue with this offset and identical SQL, or null."
},
"countIsExact": {
"type": "boolean",
"description": "True only when the page exhausts the query at offset zero."
},
"returnedCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Number of rows returned."
},
"tableMetadata": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"provenance"
],
"properties": {
"name": {
"type": "string",
"description": "Staged source table."
},
"provenance": {
"description": "Source attribution; full metadata is available from describe."
}
},
"description": "One staged source table and its retained attribution.",
"additionalProperties": false
},
"description": "Bounded table identity and source provenance."
},
"effectiveLimit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Effective page ceiling after clamping to 500."
}
},
"additionalProperties": false
}drought_dataframe_query annotations
{
"readOnlyHint": true,
"openWorldHint": false
}drought_dataframe_describe — Describe staged drought tables
Advertised read-only
Inspect tables and column types in a canvas_id returned by drought_get_timeseries or drought_compare_areas. Supply table_name for its complete source query, area/date/metric, units, missing-data and provenance metadata. Omit table_name for bounded schema summaries. Tokens are shareable capabilities and expire; this tool never lists other tokens.
drought_dataframe_describe input schema
{
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"canvas_id"
],
"properties": {
"canvas_id": {
"type": "string",
"pattern": "^[A-Za-z0-9_-]{10}$",
"description": "Token returned by a drought producer."
},
"table_name": {
"anyOf": [
{
"type": "string",
"const": ""
},
{
"type": "string",
"pattern": "^[A-Za-z_][A-Za-z0-9_]{0,62}$",
"description": "SQL identifier of an existing staged table."
}
],
"description": "Table name from the stage handle; omit for schema summaries."
},
"metadata_field": {
"enum": [
"areas",
"summary",
"missingAreas",
"missingObservations"
],
"type": "string",
"description": "Retained metadata collection to page; requires table_name."
},
"metadata_limit": {
"type": "integer",
"default": 20,
"maximum": 9007199254740991,
"minimum": 1,
"description": "Default 20 metadata items per page; values above 100 are clamped with disclosure."
},
"metadata_offset": {
"type": "integer",
"default": 0,
"maximum": 9007199254740991,
"minimum": 0,
"description": "Items to skip in the retained metadata snapshot."
}
},
"additionalProperties": false
}drought_dataframe_describe output schema
{
"type": "object",
"anyOf": [
{
"not": {
"required": [
"error"
]
},
"required": [
"canvas_id",
"expires_at",
"tables"
]
},
{
"required": [
"error"
]
}
],
"$schema": "https://json-schema.org/draft/2020-12/schema",
"properties": {
"error": {
"type": "object",
"required": [
"code",
"message"
],
"properties": {
"code": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "JSON-RPC error code for this failure."
},
"data": {
"type": "object",
"properties": {
"reason": {
"type": "string",
"examples": [
"invalid_metadata_page",
"canvas_unavailable",
"canvas_not_found",
"missing_table"
],
"description": "Machine-readable failure mode. Declared by this tool: `invalid_metadata_page`: Metadata pagination lacks a named table or uses an unavailable collection. `canvas_unavailable`: Analytical provider is unavailable. `canvas_not_found`: Token is absent, expired or belongs to another tenant. `missing_table`: The requested table is absent. Other values are possible when a failure originates below the handler."
},
"recovery": {
"type": "object",
"required": [
"hint"
],
"properties": {
"hint": {
"type": "string"
}
},
"description": "Actionable next step for the caller.",
"additionalProperties": {}
},
"retryable": {
"type": "boolean",
"description": "Whether retrying may succeed."
}
},
"additionalProperties": {}
},
"message": {
"type": "string",
"description": "Human-readable description of what went wrong."
}
},
"description": "Present when the call failed. Absent on success.",
"additionalProperties": {}
},
"tables": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"kind",
"rowCount",
"columns",
"expiresAt",
"metadata"
],
"properties": {
"kind": {
"enum": [
"table",
"view"
],
"type": "string",
"description": "Stored object kind."
},
"name": {
"type": "string",
"description": "Table name."
},
"columns": {
"type": "array",
"items": {
"type": "object",
"required": [
"name",
"type"
],
"properties": {
"name": {
"type": "string",
"description": "Column name."
},
"type": {
"type": "string",
"description": "SQL type."
},
"nullable": {
"type": "boolean",
"description": "Whether NULL values are permitted."
}
},
"description": "One SQL column and its nullability.",
"additionalProperties": false
},
"description": "Explicit SQL schema."
},
"metadata": {
"type": "object",
"description": "Complete producer metadata for a requested table; empty for summaries.",
"propertyNames": {
"type": "string"
},
"additionalProperties": {}
},
"rowCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Complete table row count."
},
"expiresAt": {
"type": [
"string",
"null"
],
"description": "Actual per-table expiry, or null."
}
},
"description": "One table in the supplied canvas with its explicit schema.",
"additionalProperties": false
},
"description": "Tables only in this specified canvas."
},
"canvas_id": {
"type": "string",
"description": "Supplied canvas token."
},
"expires_at": {
"type": "string",
"description": "Actual canvas expiry."
},
"totalCount": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Total items in the requested retained metadata collection."
},
"limitNotice": {
"type": "string",
"description": "Disclosure when metadata_limit was clamped."
},
"metadata_page": {
"type": "object",
"required": [
"field",
"items",
"total",
"offset",
"next_offset"
],
"properties": {
"field": {
"enum": [
"areas",
"summary",
"missingAreas",
"missingObservations"
],
"type": "string",
"description": "Requested metadata collection."
},
"items": {
"type": "array",
"items": {},
"description": "Unchanged complete items from the retained snapshot."
},
"total": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Total collection items."
},
"offset": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Requested item offset."
},
"next_offset": {
"anyOf": [
{
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991
},
{
"type": "null"
}
],
"description": "Next offset, or null at the end."
}
},
"description": "Requested count of complete metadata items, fewer only at exhaustion.",
"additionalProperties": false
},
"effectiveLimit": {
"type": "integer",
"maximum": 9007199254740991,
"minimum": -9007199254740991,
"description": "Effective metadata page ceiling after clamping to 100."
}
},
"additionalProperties": false
}drought_dataframe_describe annotations
{
"readOnlyHint": true,
"openWorldHint": false,
"idempotentHint": true
}Prompts
0 advertised
Resources
1 advertised
us-drought-monitor-guide
Use drought_* tools to assess published U.S. Drought Monitor severity, compare areas or periods, and investigate county drought duration. Resolve geography, check coverage and interpretation, then complete staged SQL rows and retained metadata before drawing conclusions.
us-drought-monitor-guide URI
skill://us-drought-monitor-guide/SKILL.mdio.modelcontextprotocol/skills
io.modelcontextprotocol/skills URI template
skill://{+path}30-day availability
Aggregated from read-only remote checks; this is not a tool-execution or security guarantee.
- Successful checks
- 1 of 1 (100%)
- Average latency
- 832 ms
- 95th percentile latency
- 832 ms
Maintenance history
Public check and source-refresh events. Editorial and ownership records remain private.
- · probe · passed · 832 ms · metadata changed · 7 tool(s), 1 resource(s), 1 resource template(s), 0 prompt(s)
Connect from your client
Each snippet registers the same endpoint; pick the client you use.
Claude Code
Claude Code configuration
claude mcp add --transport http us-drought-monitor-mcp-server https://us-drought-monitor.caseyjhand.com/mcpCodex
Codex configuration
codex mcp add us-drought-monitor-mcp-server --url https://us-drought-monitor.caseyjhand.com/mcpCursor
Cursor configuration
{
"mcpServers": {
"us-drought-monitor-mcp-server": {
"url": "https://us-drought-monitor.caseyjhand.com/mcp"
}
}
}Cline
Cline configuration
{
"mcpServers": {
"us-drought-monitor-mcp-server": {
"type": "streamableHttp",
"url": "https://us-drought-monitor.caseyjhand.com/mcp",
"disabled": false
}
}
}VS Code
VS Code configuration
{
"servers": {
"us-drought-monitor-mcp-server": {
"type": "http",
"url": "https://us-drought-monitor.caseyjhand.com/mcp"
}
}
}Gemini CLI
Gemini CLI configuration
gemini mcp add --transport http us-drought-monitor-mcp-server https://us-drought-monitor.caseyjhand.com/mcpClaude Desktop
Claude Desktop configuration
{
"mcpServers": {
"us-drought-monitor-mcp-server": {
"url": "https://us-drought-monitor.caseyjhand.com/mcp"
}
}
}Windsurf
Windsurf configuration
{
"mcpServers": {
"us-drought-monitor-mcp-server": {
"serverUrl": "https://us-drought-monitor.caseyjhand.com/mcp"
}
}
}Let your agent find its tools
Find servers like us-drought-monitor-mcp-server from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.