query
Pack: data-reunion · Endpoint: https://gateway.pipeworx.io/data-reunion/mcp
Query records from a Réunion Open Data dataset with ODSQL. Filter (where), aggregate (group_by/select), sort (order_by), paginate (limit/offset).
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
dataset_id | string | yes | Dataset id from search_datasets. |
query | string | no | Free-text keyword across all fields (optional). |
where | string | no | ODSQL filter, e.g. year >= 2020 AND city = "Paris" (overrides query). |
select | string | no | ODSQL select/aggregation, e.g. count(*) as n, sum(amount). |
group_by | string | no | ODSQL group_by field(s). |
order_by | string | no | Sort, e.g. date desc. |
limit | number | no | Max records (1-100, default 20). |
offset | number | no | Pagination offset (default 0). |
Example call
curl -X POST https://gateway.pipeworx.io/data-reunion/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"query","arguments":{}}}'Connect
Add this to your MCP client config, or use one-click install buttons:
{
"mcpServers": {
"data-reunion": {
"url": "https://gateway.pipeworx.io/data-reunion/mcp"
}
}
}See Getting Started for client-specific install steps.