Sınırlı açık veri SQL sorgusu
istanbul_datastore_queryRun a bounded SELECT over records from one allowlisted CKAN resource.
SQLite dialect: use table records and published column names. GROUP BY and
aggregates are supported; no writes, arbitrary functions or application DB.
A complete bounded capture is required, never partial counts. The server
enforces an outer result limit (default 20, max 100) even if SQL omits LIMIT.
Only resources configured in CKAN_SQL_ALLOWED_RESOURCE_IDS are available.
Local query syntax and bounds: https://github.com/Batu1-1an/istanbulmcp/blob/main/docs/datastore-sql.md
Source API: https://docs.ckan.org/en/latest/maintaining/datastore.html
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"resource_id": "<resource_id>",
"sql": "<sql>"
},
"name": "istanbul_datastore_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| limit | No | ||
| resource_id | Yes |