# Read rows from an Australian public dataset

Preview: Read rows from a selected Australian public dataset, with exact field filtering, column selection and sorting.

Canonical: https://aroai.com/tools/au_dataset_query/

## Tool reference

MCP tool ID: `au_dataset_query`. Availability: Preview. Country: Australia.

Credit use: 1 credit.

## Input schema

```json
{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "type": "object",
  "properties": {
    "dataset_id": {
      "type": "string",
      "minLength": 1,
      "maxLength": 200,
      "description": "Exact dataset id or slug from au_dataset_search or au_dataset_get."
    },
    "resource_id": {
      "type": "string",
      "minLength": 1,
      "maxLength": 200,
      "description": "Exact resource id listed by au_dataset_get with detail=full."
    },
    "filters": {
      "type": "object",
      "propertyNames": {
        "type": "string",
        "minLength": 1,
        "maxLength": 200
      },
      "additionalProperties": {
        "anyOf": [
          {
            "type": "string",
            "maxLength": 500
          },
          {
            "type": "number"
          },
          {
            "type": "boolean"
          },
          {
            "maxItems": 50,
            "type": "array",
            "items": {
              "anyOf": [
                {
                  "type": "string",
                  "maxLength": 500
                },
                {
                  "type": "number"
                },
                {
                  "type": "boolean"
                }
              ]
            }
          }
        ]
      }
    },
    "fields": {
      "minItems": 1,
      "maxItems": 20,
      "type": "array",
      "items": {
        "type": "string",
        "minLength": 1,
        "maxLength": 200
      }
    },
    "sort": {
      "maxItems": 3,
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "field": {
            "type": "string",
            "minLength": 1,
            "maxLength": 200
          },
          "direction": {
            "default": "asc",
            "type": "string",
            "enum": [
              "asc",
              "desc"
            ]
          }
        },
        "required": [
          "field",
          "direction"
        ],
        "additionalProperties": false
      }
    },
    "limit": {
      "default": 20,
      "type": "integer",
      "minimum": 1,
      "maximum": 100
    }
  },
  "required": [
    "dataset_id",
    "resource_id",
    "limit"
  ],
  "additionalProperties": false
}
```

## Example input

```json
{
  "dataset_id": "example-dataset-slug",
  "resource_id": "00000000-0000-0000-0000-000000000000",
  "limit": 20
}
```

## Usage notes

- Costs one credit per query.
- Use au_dataset_search or au_dataset_get with detail=full first to obtain the exact resource ID and confirm DataStore availability.
- Supports exact field filters, selected columns and up to three sort fields for up to 100 rows.