datastore_query

Active

declared in 0.1.0

Read actual table rows from a Jersey resource via CKAN datastore_search. Works only for resources with datastore_active=true (get the resource_id from dataset_details). Returns parsed records plus field definitions — e.g. population projections by Year/Age/Sex.

Parameters schema

{
  "type": "object",
  "required": [
    "resource_id"
  ],
  "properties": {
    "q": {
      "type": "string",
      "description": "Full-text filter across the table."
    },
    "limit": {
      "type": "number",
      "description": "Max rows, 1-32000 (default 100)."
    },
    "offset": {
      "type": "number",
      "description": "0-based row offset for paging."
    },
    "filters": {
      "type": "object",
      "description": "Exact-match column filters, e.g. {\"Sex\":\"F\",\"Year\":2025}."
    },
    "resource_id": {
      "type": "string",
      "description": "Resource UUID from dataset_details, e.g. \"6e222cd7-d296-429a-abea-09001dcc45f6\"."
    }
  }
}

What this tool wraps· 0 endpoints

min confidence0.70 0.50

No endpoints wrapped at confidence ≥ 0.70.

Parent server

Jersey Opendata

https://github.com/pipeworx-io/mcp-jersey-opendata

1/7 registries

View full server →