[Integrations](https://spiral.ai/integrations) › [Raycast](https://spiral.ai/integrations/raycast) › [DataSF dataset records](https://spiral.ai/integrations/raycast/datasf-dataset-records)

# How to Use DataSF dataset records in Raycast

Returns records or calculated summaries from a DataSF dataset. Use it to inspect permit activity, compare city service requests, or retrieve selected records for analysis.

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

## Prompts to try with DataSF dataset records in Raycast

- Use DataSF dataset records to show 20 recent Building Permits records from San Francisco, newest filings first, with the available filing dates and permit descriptions.
- Use DataSF dataset records to look this up and give me the result as a table.
- Pull the latest numbers from DataSF dataset records and tell me what changed since last week.
- Check DataSF dataset records and summarize what you find in three bullet points.
- Pull the newest data from DataSF dataset records and give me the result as a table.

## How to set up DataSF dataset records in Raycast

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

### Use the Raycast connector

1. **Install the server**: In Raycast run Install MCP Server. Name it Spiral, set Transport to HTTP, paste this URL and keep OAuth Type on Dynamic:

```text
https://api.spiral.ai/mcp
```

2. **Sign in to Spiral and approve**: Spiral opens in your browser: sign in, pick the organization and click Authorize. No API key. Spiral gives the connection its own key; Raycast never sees it, and you can remove it under Settings › Connected apps in the console.

### Use the Spiral skill

1. **Send Raycast 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 DataSF 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-sf-gov/open-data/rows",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'
```

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

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

## DataSF dataset records tools and prices

- [DataSF open data portal · Rows](https://spiral.ai/tools/alexandria/data-sf-gov/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 `filed_date DESC` or `count(*) DESC`. Default `:id` when no `group` is given. |
| where |  | — | SoQL $where, for example `zoning_sim like 'RH-1%'`, `filed_date between '2026-09-01T00:00:00' and '2026-09-02T00:00:00'`, `intersects(the_geom,'POINT(-122.3966 37.7897)')`, `within_circle(point,37.7897,-122.3966,50)`. |
| cursor |  | — | Row offset to start from: the `next_cursor` of the previous page. Pattern: ^[0-9]{1,12}$. |

## What can you do with DataSF dataset records in Raycast?

Create a source-backed briefing on San Francisco permits or city service requests. A chat app can help find the appropriate dataset, explain its definitions, and turn selected records into a readable comparison.

### Build a permit activity briefing

Find permit sources through the catalog's categories and tags, inspect their definitions, count the selected period, and retrieve records for a monthly construction briefing. Account for permits that cover multiple addresses.

### Compare neighborhood service requests

Locate the 311 source through catalog discovery, verify its neighborhood and date definitions, and compare matching record totals with a breakdown of requests. Label the result as service requests.

### Prepare a scoped data extraction

Discover relevant tables using the catalog vocabulary, inspect their schemas, and count matching records before retrieving a defined date range. Use the result to populate a civic analysis project.

### Audit sources behind a civic report

Review the categories, search results, and dataset definitions behind a housing or city services report. Recalculate its record totals and retrieve supporting records so the published figures can be checked.

### Check permit counting assumptions

Inspect the Building Permits documentation, count records for a selected period, and examine repeated permit numbers. Establish whether a report needs address-level rows or a deduplicated permit total.

## Overview

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

## DataSF dataset records in other agents

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

## More Raycast guides

- [DataSF dataset details](https://spiral.ai/integrations/raycast/datasf-dataset-details)
- [DataSF dataset search](https://spiral.ai/integrations/raycast/datasf-dataset-search)
- [DataSF catalog categories and tags](https://spiral.ai/integrations/raycast/datasf-catalog-categories-and-tags)
- [DataSF record count](https://spiral.ai/integrations/raycast/datasf-record-count)
- [DC building permit search](https://spiral.ai/integrations/raycast/dc-building-permit-search)
- [Earth Search Sentinel-2 image clip](https://spiral.ai/integrations/raycast/earth-search-sentinel-2-image-clip)

## Questions about DataSF dataset records in Raycast

**Can Raycast use DataSF dataset records?**

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

**How much does DataSF dataset records cost in Raycast?**

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

**Do I need an Alexandria account to use DataSF dataset records in Raycast?**

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

About two minutes: install the server, then sign in to Spiral and approve.

**Does Raycast wait while DataSF dataset records runs?**

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

**Is every DataSF search result a dataset?**

No. The catalog can include tables, charts, maps, stories, and derived views. Check the result's type before choosing a source for record analysis.

**How fresh is DataSF data?**

Refresh schedules depend on the dataset. DataSF documents an approximately 10 a.m. daily refresh for 311 Cases, while DBI uploads Building Permits nightly.

**How much historical data is available?**

History depends on the selected dataset. For example, 311 Cases covers eligible cases created on July 1, 2008, or later.

**Does a row count equal the number of permits?**

Not necessarily. Building Permits can repeat one permit across multiple rows when it has multiple associated addresses, so counting rows can overstate the number of permits.

**Does DataSF guarantee the data is accurate?**

No. The city's terms say the data is subject to error and cannot be relied on without verification or a site inspection.

