sf_query
ActiveTool of Data Sf
declared in 0.1.0
Run a raw SoQL query against any San Francisco open-data resource (data.sfgov.org) by its Socrata id (8-char like "wg3w-h783"). Full SoQL: where/select/group/order/limit/offset. Use sf_datasets to find a resource id, or sf_recent for the common ones.
Parameters schema
{
"type": "object",
"required": [
"resource_id"
],
"properties": {
"group": {
"type": "string",
"description": "SoQL $group (e.g. \"incident_category\")."
},
"limit": {
"type": "number",
"description": "Max rows (default 100, max 5000)."
},
"order": {
"type": "string",
"description": "SoQL $order (e.g. \"incident_datetime DESC\")."
},
"where": {
"type": "string",
"description": "SoQL $where filter (e.g. \"incident_year=2025\")."
},
"offset": {
"type": "number",
"description": "Row offset for paging."
},
"select": {
"type": "string",
"description": "SoQL $select (e.g. \"incident_category, count(*)\")."
},
"_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. \"wg3w-h783\" (police incidents)."
}
}
}No endpoints wrapped at confidence ≥ 0.70.
Parent server
Data Sf
https://github.com/pipeworx-io/mcp-data-sf
2/7 registries