Spiral gives your agent every tool with one account. Browse the tools →

Hermes · Public Records

How to Use Data.gov.au table records in Hermes

Returns rows from a resource stored in Data.gov.au's DataStore. Use it to retrieve the relevant part of a table for analysis without downloading the entire source file.

Prompts to try with Data.gov.au table records in Hermes

Copy an example into Hermes, or ask in your own words.

Every month, use Data.gov.au table records on a previously selected Australian regional population DataStore resource to retrieve Melbourne rows and report differences from the previous extract.

Data.gov.au table recordsHermes
Try asking
  • Every Monday at 9am: use Data.gov.au table records to look this up and give me the result as a table.

  • Pull the latest numbers from Data.gov.au table records and tell me what changed since last week.

  • Check Data.gov.au table records and summarize what you find in three bullet points.

  • Pull the newest data from Data.gov.au table records and give me the result as a table.

How to set up Data.gov.au table records in Hermes

Pick the way that suits you. Each takes about two minutes.

Use the Spiral skill

  1. Send Hermes this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use Spiral's MCP server

  1. Add the server and sign in

    Hermes opens your browser: sign in to Spiral and click Authorize. No API key. When Hermes asks Enable all tools? \[Y/n/select], answer Y: n cancels without saving the server, and select hides the tools you leave out.

    hermes mcp add spiral \
      --url https://api.spiral.ai/mcp \
      --auth oauth \
      --connect-timeout 300
  2. Check it

    In a chat that was already open, run /reload-mcp.

    hermes mcp list
    hermes mcp test spiral

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run Data.gov.au table records

    One request; the result comes back by polling or a webhook.

    curl https://api.spiral.ai/v1/runs \
      -H "Authorization: Bearer $SPIRAL_API_KEY" \
      -H "Content-Type: application/json" \
      -H "Idempotency-Key: $(uuidgen)" \
      -d '{
        "provider": "alexandria",
        "model": "data-gov-au/open-data/query_datastore",
        "input": {
          "resource_id": "<resource_id>"
        }
      }'

Then paste one of the prompts above: Hermes finds Data.gov.au table records on Spiral, shows the price and runs it.

Data.gov.au table records providers and prices

Spiral runs Data.gov.au table records through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
data.gov.au open data catalogue · Query datastore
data-gov-au/open-data/query_datastore

Settings you can ask for

Ask Hermes for any of these in your prompt.

SettingAllowed valuesDefaultDescription
Limit1 to 1000100

Rows per page.

Distincton or off

distinct

Every API field of data.gov.au open data catalogue · Query datastore is on its tool page: open its card above.

What can you do with Data.gov.au table records in Hermes?

Maintain a weekly digest of changes to Australian government data sources used in your research. A scheduled agent can compare publisher, dataset, resource, and available table results with earlier snapshots to identify changes worth reviewing.

Build a regional evidence pack

Identify relevant government publishers, find datasets about Melbourne, inspect their resources, and extract available DataStore rows for a regional comparison. Keep each result tied to its source dataset.

Prepare council asset data for a map

Find a council's catalog entry and published asset datasets, inspect the resources, and retrieve relevant rows where DataStore access is available. Use the resulting locations to prepare a map of public infrastructure.

Compare published reporting years

Identify the publishing agency and locate a dataset with resources for multiple years. Inspect each resource and extract comparable DataStore rows where available before calculating changes.

Audit an agency's published data

Resolve the agency's catalog name, inventory its datasets and resources, and sample accessible DataStore tables. Produce a report showing which sources support row analysis and which require separate file retrieval.

Diagnose a missing data extract

Inspect a dataset and its selected resource to establish where the data lives. If the resource is stored in DataStore, query its rows; otherwise identify the linked file that needs separate retrieval.

Questions about Data.gov.au table records in Hermes

Can Hermes use Data.gov.au table records?

Yes. Add Spiral to Hermes as an MCP server, and Hermes can find and run Data.gov.au table records like any built-in tool.

How much does Data.gov.au table records cost in Hermes?

$0.00873 per call. You pay from your Spiral balance as you go, with no subscription, and a failed run is not charged. Your Hermes plan is separate.

Do I need an Alexandria account to use Data.gov.au table records in Hermes?

No. Spiral runs Data.gov.au table records on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up Data.gov.au table records in Hermes?

About two minutes: add the server and sign in, then check it.

Does Hermes wait while Data.gov.au table records runs?

Data.gov.au table records runs in the background. Hermes starts the run, checks on it and gives you the json when it's ready.

Does Data.gov.au cover only federal government data?

It includes data published by Australian federal, state, and local government agencies. A search can therefore surface national statistics alongside council datasets.

How fresh and accurate is the data?

Data.gov.au explicitly does not guarantee dataset quality or timeliness. Its catalog should not be treated as a promise that every published dataset reflects current conditions.

Does a dataset search return the underlying table rows?

Search results represent datasets. Row access requires a resource loaded into DataStore; a resource can instead point to a file hosted elsewhere.

How much historical data can I retrieve?

Historical coverage depends on the resources supplied for the dataset. CKAN supports separate resources for different years, so inspect those resources before planning a year-to-year comparison.

What attribution does Data.gov.au request?

Its requested attribution includes the publishing organization, jurisdiction, dataset title, date sourced, and dataset URL. Preserve those details when preparing a report or derived dataset.

Get started

Start using Data.gov.au table records in Hermes

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Hermes:

Set up Hermes

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options