query_dataset
ActiveTool of Datos Co
declared in 0.1.0
Query rows from a datos.gov.co dataset using SoQL. datasetId is the Socrata 4x4 code from search_datasets. SoQL clauses: $select (columns / aggregates like "count(*)"), $where (SQL-like filter, e.g. "departamento_nom='BOGOTA' AND edad > 60"), $order ("count desc"), $group, $q (full-text across the row). Use dataset_columns first to learn field names. Returns an array of row objects keyed by field name. Default $limit is 50 (Socrata max per page is 50000).
Parameters schema
{
"type": "object",
"required": [
"datasetId"
],
"properties": {
"$q": {
"type": "string",
"description": "Full-text search across the whole row."
},
"$group": {
"type": "string",
"description": "Group-by field(s) for aggregation."
},
"$limit": {
"type": "number",
"description": "Rows to return (default 50)."
},
"$order": {
"type": "string",
"description": "Sort, e.g. \"fecha_reporte_web desc\"."
},
"$where": {
"type": "string",
"description": "SQL-like filter, e.g. \"edad > 60 AND sexo='F'\"."
},
"$offset": {
"type": "number",
"description": "Pagination offset (default 0)."
},
"$select": {
"type": "string",
"description": "Columns or aggregates, e.g. \"departamento_nom, count(*)\"."
},
"datasetId": {
"type": "string",
"description": "Socrata 4x4 id, e.g. \"gt2j-8ykr\"."
}
}
}No endpoints wrapped at confidence ≥ 0.70.
Parent server
Datos Co
https://github.com/pipeworx-io/mcp-datos-co
1/7 registries