kcmo_query
ActiveTool of Data Kcmo
declared in 0.1.0
Run a raw SoQL query against any Kansas City, MO open-data resource (data.kcmo.org) by its Socrata id (8-char like "vsgj-uufz"). Full SoQL: where/select/group/order/limit/offset. Use kcmo_datasets to find a resource id, or kcmo_recent for the common ones.
Parameters schema
{
"type": "object",
"required": [
"resource_id"
],
"properties": {
"group": {
"type": "string",
"description": "SoQL $group."
},
"limit": {
"type": "number",
"description": "Max rows (default 100, max 5000)."
},
"order": {
"type": "string",
"description": "SoQL $order."
},
"where": {
"type": "string",
"description": "SoQL $where filter."
},
"offset": {
"type": "number",
"description": "Row offset for paging."
},
"select": {
"type": "string",
"description": "SoQL $select."
},
"_apiKey": {
"type": "string",
"description": "Optional — your own Socrata app token for higher rate limits. Omit to use the keyless endpoint."
},
"resource_id": {
"type": "string",
"description": "Socrata resource id, e.g. \"vsgj-uufz\"."
}
}
}No endpoints wrapped at confidence ≥ 0.70.
Parent server
Data Kcmo
https://github.com/pipeworx-io/mcp-data-kcmo
2/7 registries