[Integrations](https://spiral.ai/integrations) › [Cline](https://spiral.ai/integrations/cline) › [DataSF record count](https://spiral.ai/integrations/cline/datasf-record-count)

# How to Use DataSF record count in Cline

Returns the number of records matching a DataSF dataset query. Use it for a how-many question or to size an extraction, while checking whether several rows can describe the same permit or event.

|  |  |
| --- | --- |
| Model | DataSF record count |
| 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 record count in Cline

- Use DataSF record count to count 311 Cases created during October 2026, then add the result and query criteria to this project's report.
- Use DataSF record count to look this up and give me the result as a table. Save the result in ./assets.
- Pull the latest numbers from DataSF record count and tell me what changed since last week.
- Check DataSF record count and summarize what you find in three bullet points.
- Pull the newest data from DataSF record count and give me the result as a table.

## How to set up DataSF record count in Cline

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

### Use Spiral's MCP server

1. **Add the server**: In the Cline panel, click the MCP Servers icon and open the Remote Servers tab. Enter:

```bash
cline mcp add spiral https://api.spiral.ai/mcp --transport http --yes
```

2. **Sign in**: Open the Configure tab and click Authenticate on the Spiral server. Sign in to Spiral, pick the organization and click Authorize. No API key.

3. **Check it**: Spiral shows as connected on the Configure tab. In the CLI:

```bash
cline config mcp
```

### Use the Spiral skill

1. **Send Cline 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 record count**: 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/row_count",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'
```

Then paste one of the prompts above: Cline finds DataSF record count on Spiral, shows the price and runs it.

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

## DataSF record count tools and prices

- [DataSF open data portal · Row count](https://spiral.ai/tools/alexandria/data-sf-gov/open-data/row_count) (Alexandria): $0.00873 per call.

## Settings you can ask for

| Setting | Allowed values | Default | Description |
| --- | --- | --- | --- |
| q |  | — | SoQL $q full-text search. |
| where |  | — | SoQL $where predicate. |
| filters |  | — | Bare equality filters sent as `field=value` query parameters. |

## What can you do with DataSF record count in Cline?

Build a San Francisco civic report backed by source definitions and queryable records. A coding agent can turn catalog discovery, schema inspection, and record counts into an analysis that fits your project's files.

### 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 Cline guides](https://spiral.ai/integrations/cline)

## DataSF record count in other agents

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

## More Cline guides

- [DataSF dataset search](https://spiral.ai/integrations/cline/datasf-dataset-search)
- [Earth Search Sentinel-2 image clip](https://spiral.ai/integrations/cline/earth-search-sentinel-2-image-clip)
- [DataSF dataset records](https://spiral.ai/integrations/cline/datasf-dataset-records)
- [Earth Search Sentinel-2 imagery availability](https://spiral.ai/integrations/cline/earth-search-sentinel-2-imagery-availability)
- [DataSF dataset details](https://spiral.ai/integrations/cline/datasf-dataset-details)
- [Earth Search Sentinel-2 scene details](https://spiral.ai/integrations/cline/earth-search-sentinel-2-scene-details)

## Questions about DataSF record count in Cline

**Can Cline use DataSF record count?**

Yes. Add Spiral to Cline as an MCP server, and Cline can find and run DataSF record count like any built-in tool.

**How much does DataSF record count cost in Cline?**

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

**Do I need an Alexandria account to use DataSF record count in Cline?**

No. Spiral runs DataSF record count 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 record count in Cline?**

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

**Does Cline wait while DataSF record count runs?**

DataSF record count runs in the background. Cline 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.

