[Integrations](https://spiral.ai/integrations) › [opencode](https://spiral.ai/integrations/opencode) › [Edmonton dataset records](https://spiral.ai/integrations/opencode/edmonton-dataset-records)

# How to Use Edmonton dataset records in opencode

Returns records from an Edmonton dataset, with support for filtered queries and grouped summaries. Use it for data beyond the dedicated lookups, such as development permit outcomes, after checking the dataset's column definitions.

|  |  |
| --- | --- |
| Model | Edmonton dataset records |
| Available through | Alexandria |
| Category | Public Records |
| Price | $0.00873 per call. |
| Returns | json |
| Runs | In the background |
| Setup | About 2 minutes, no API key |

## Prompts to try with Edmonton dataset records in opencode

- Use Edmonton dataset records to summarize Downtown development applications by published status, after checking the source definitions, and add the results to the project.
- Use Edmonton dataset records to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from Edmonton dataset records and tell me what changed since last week.
- Check Edmonton dataset records and summarize what you find in three bullet points.
- Pull the newest data from Edmonton dataset records and give me the result as a table.

## How to set up Edmonton dataset records in opencode

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

### Use Spiral's MCP server

1. **Add the server**: Leave out `--global` to add Spiral to the current project only. No header and no client ID or secret: opencode registers itself with Spiral.

```bash
opencode mcp add spiral --global --url https://api.spiral.ai/mcp
```

2. **Sign in**: Your browser opens. Sign in to Spiral, pick the organization and click Authorize, then return to the terminal. No API key. Inside opencode, `/mcps` starts the same sign-in.

```bash
opencode mcp auth spiral
```

3. **Check it**: Spiral shows as connected.

```bash
opencode mcp list
```

### Use the Spiral skill

1. **Send opencode 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 the Spiral CLI

1. **Install and sign in**: Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

```bash
npx -y spiral-cli@latest init
```

### Call the Spiral API

1. **Create an API key**: In the console, under API keys.

2. **Run Edmonton dataset records**: One request; the result comes back by polling or a webhook.

```bash
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-edmonton-ca/open-data/rows",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'
```

Then paste one of the prompts above: opencode finds Edmonton dataset records on Spiral, shows the price and runs it.

Setup guide in the docs: https://spiral.ai/docs/quickstarts/opencode

## Edmonton dataset records tools and prices

- [City of Edmonton Open Data · Rows](https://spiral.ai/tools/alexandria/data-edmonton-ca/open-data/rows) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| q |  | — | SoQL $q full-text search across all text columns. |
| group |  | — | SoQL $group; pair with aggregates in `select`. |
| limit | 1 to 50000 | 100 | Rows per page. The portal caps a request at 50000; wide datasets with geometry should use far less. |
| order |  | — | SoQL $order, for example `issue_date DESC` or `count(*) DESC`. Default `:id` when no `group` is given. |
| where |  | — | SoQL $where, for example `address like '%86 STREET NW'`, `issue_date between '2026-09-01T00:00:00' and '2026-09-30T23:59:59'`, `within_circle(geometry_point,53.5449,-113.4885,200)`. |
| cursor |  | — | Row offset to start from: the `next_cursor` of the previous page. Pattern: ^[0-9]{1,12}$. |

## What can you do with Edmonton dataset records in opencode?

Build an Edmonton commercial activity report with permit records, licence activity, and published assessments. Use catalog labels, dataset definitions, and record counts to choose and check the sources behind the project's tables.

### Downtown business district briefing

Prepare a Downtown briefing with commercial licence activity, issued construction work, and published property assessments. Find the relevant catalog subjects, inspect definitions, and count matching records before assembling the supporting tables.

### Commercial corridor comparison

Compare Jasper Avenue and 124 Street using published assessments, commercial licences, and construction records. Discover the source datasets through their categories and tags, check column meanings, and calculate comparable record counts for each corridor.

### Public commercial site background

Compile the available assessment, issued building permits, and commercial licence records for a proposed business location on Whyte Avenue. Use catalog labels to find related development data, inspect its definitions, and count and retrieve the matching records.

### Municipal data source audit

Build a source inventory for an Edmonton commercial activity report. Document catalog categories, dataset definitions, assessment coverage, licence date meanings, permit scope, and matching record totals, then inspect sample records from each source.

### Construction activity summary

Summarize issued building permits in McIntyre Industrial by building type and work description. Report units added separately from the number of permits.

### Public business licence check

Look up Tim Hortons commercial licence records in Edmonton and summarize the published categories, issue dates, and expiry dates. Explain that the latest issue date may reflect a renewal.

### Assessment comparison table

Compare published property assessments along Jasper Avenue using a consistent coverage year. Include the source's assessment definitions with the comparison.

### Development application outcome report

Locate Edmonton's development permit data and summarize approved, refused, and appealed applications in Downtown. Keep these outcomes separate from issued building permit activity.

## Overview

- [Alexandria](https://spiral.ai/providers/alexandria)
- [All opencode guides](https://spiral.ai/integrations/opencode)

## Edmonton dataset records in other agents

- [Amp](https://spiral.ai/integrations/amp/edmonton-dataset-records)
- [ChatGPT](https://spiral.ai/integrations/chatgpt/edmonton-dataset-records)
- [Claude](https://spiral.ai/integrations/claude-desktop/edmonton-dataset-records)
- [Claude Code](https://spiral.ai/integrations/claude-code/edmonton-dataset-records)
- [Cline](https://spiral.ai/integrations/cline/edmonton-dataset-records)
- [Codex](https://spiral.ai/integrations/codex/edmonton-dataset-records)
- [Cursor](https://spiral.ai/integrations/cursor/edmonton-dataset-records)
- [Devin](https://spiral.ai/integrations/devin/edmonton-dataset-records)
- [dots](https://spiral.ai/integrations/dots/edmonton-dataset-records)
- [Factory Droid](https://spiral.ai/integrations/factory-droid/edmonton-dataset-records)
- [Gemini](https://spiral.ai/integrations/gemini/edmonton-dataset-records)
- [Gemini CLI](https://spiral.ai/integrations/gemini-cli/edmonton-dataset-records)
- [Google Antigravity](https://spiral.ai/integrations/antigravity/edmonton-dataset-records)
- [goose](https://spiral.ai/integrations/goose/edmonton-dataset-records)
- [Grok](https://spiral.ai/integrations/grok/edmonton-dataset-records)
- [Grok Build](https://spiral.ai/integrations/grok-build/edmonton-dataset-records)
- [Hermes](https://spiral.ai/integrations/hermes/edmonton-dataset-records)
- [Instinct](https://spiral.ai/integrations/instinct/edmonton-dataset-records)
- [Manus](https://spiral.ai/integrations/manus/edmonton-dataset-records)
- [Muse](https://spiral.ai/integrations/muse/edmonton-dataset-records)
- [Muse Code](https://spiral.ai/integrations/muse-code/edmonton-dataset-records)
- [n8n](https://spiral.ai/integrations/n8n/edmonton-dataset-records)
- [Notion](https://spiral.ai/integrations/notion/edmonton-dataset-records)
- [OpenClaw](https://spiral.ai/integrations/openclaw/edmonton-dataset-records)
- [Perplexity](https://spiral.ai/integrations/perplexity/edmonton-dataset-records)
- [Raycast](https://spiral.ai/integrations/raycast/edmonton-dataset-records)
- [VS Code](https://spiral.ai/integrations/vscode/edmonton-dataset-records)
- [Windsurf](https://spiral.ai/integrations/windsurf/edmonton-dataset-records)
- [Zapier](https://spiral.ai/integrations/zapier/edmonton-dataset-records)

## More opencode guides

- [Edmonton dataset record count](https://spiral.ai/integrations/opencode/edmonton-dataset-record-count)
- [Edmonton dataset search](https://spiral.ai/integrations/opencode/edmonton-dataset-search)
- [Edmonton dataset details](https://spiral.ai/integrations/opencode/edmonton-dataset-details)
- [Edmonton property assessments](https://spiral.ai/integrations/opencode/edmonton-property-assessments)
- [Edmonton data categories and tags](https://spiral.ai/integrations/opencode/edmonton-data-categories-and-tags)
- [Elections Alberta candidate records](https://spiral.ai/integrations/opencode/elections-alberta-candidate-records)

## Questions about Edmonton dataset records in opencode

**Can opencode use Edmonton dataset records?**

Yes. Add Spiral to opencode as an MCP server, and opencode can find and run Edmonton dataset records like any built-in tool.

**How much does Edmonton dataset records cost in opencode?**

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

**Do I need an Alexandria account to use Edmonton dataset records in opencode?**

No. Spiral runs Edmonton dataset 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 Edmonton dataset records in opencode?**

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

**Does opencode wait while Edmonton dataset records runs?**

Edmonton dataset records runs in the background. opencode starts the run, checks on it and gives you the json when it's ready.

**What geographic area do the property assessments cover?**

The property assessment dataset covers properties within the City of Edmonton. It does not describe an assessment inventory for the entire Edmonton metropolitan region.

**How often are property assessments refreshed?**

The property assessment dataset lists automated weekly updates. Its coverage period is a calendar year, so a weekly refresh does not make the assessed value a weekly market valuation.

**How far back do building permit records go?**

Edmonton states that its published building permit records start on January 1, 2009. This source does not establish permit history before that date.

**Does a recent business licence issue date mean a business just opened?**

No. Edmonton defines the most recent issue date as the date a licence was most recently issued or renewed, so renewals can appear in a recent-date search.

**Are all business addresses public?**

No. Edmonton redacts business addresses for some licence types because of privacy.

