query
ActiveTool of Data Santaclara
declared in 0.1.0
Run a Socrata SoQL query against a Santa Clara County Open Data dataset by resource_id (e.g. "n9u6-aijz"). Filter with where/select/group/order (SoQL clauses, without the leading $) plus limit/offset. Returns matching rows as JSON.
Parameters schema
{
"type": "object",
"required": [
"resource_id"
],
"properties": {
"group": {
"type": "string",
"description": "SoQL $group column(s)."
},
"limit": {
"type": "number",
"description": "Max rows (default Socrata 1000)."
},
"order": {
"type": "string",
"description": "SoQL $order, e.g. \"date DESC\"."
},
"where": {
"type": "string",
"description": "SoQL $where filter, e.g. \"year >= 2020 AND status = 'Active'\"."
},
"offset": {
"type": "number",
"description": "Pagination offset."
},
"select": {
"type": "string",
"description": "SoQL $select, e.g. \"name, count(*) AS n\"."
},
"resource_id": {
"type": "string",
"description": "Dataset id, e.g. \"n9u6-aijz\" (from datasets)."
}
}
}No endpoints wrapped at confidence ≥ 0.70.
Parent server
Data Santaclara
https://github.com/pipeworx-io/mcp-data-santaclara
1/7 registries