# io.github.cyanheads/socrata-mcp-server (remote · socrata.caseyjhand.com)

Search and query government open-data portals (Socrata SODA API).

- Trust score: 71/100 (medium)
- Change this week: +5
- Registry status: active
- Liveness: live
- Owner verified: no
- Last scored: 2026-08-03

## Components

- remote · `socrata.caseyjhand.com`: 71/100 (this document), [markdown](https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata.md), [page](https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata)
- npm · `@cyanheads/socrata-mcp-server`: 35/100, [markdown](https://verifymcp.io/servers/cyanheads-socrata-mcp-server/cyanheads-socrata-mcp-server.md), [page](https://verifymcp.io/servers/cyanheads-socrata-mcp-server/cyanheads-socrata-mcp-server)

## Channel facts

- Endpoint: `https://socrata.caseyjhand.com/mcp`
- Transports: `streamable-http`
- Auth: `none`
- Version: `0.1.14`

## Trust breakdown

How this component scores in each security and reliability category. Every signal is checked automatically against the live server, and we only credit what we can confirm. Scores are 0–100 per category. Scoring method: https://verifymcp.io/docs/scoring (what has changed: https://verifymcp.io/docs/scoring/changelog)

Scored 2026-08-03.

- **Endpoint Security**: 66/100
  - The endpoint's TLS certificate is valid, in date, and uses a strong key.
  - Authorisation not fully verified: no authorisation is required to call this server, and 6 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe.
  - HTTPS is enforced; there's no plaintext access path.
  - The HSTS (Strict-Transport-Security) header is present.
  - DNSSEC is configured correctly; the domain's records validate against the full chain to the root.
- **Transport & Reachability**: 100/100
  - Verified streamable-http transport via a live MCP handshake.
- **Schema Quality & AI Usability**: 77/100
  - 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).
  - AI-judged instruction clarity (excellent).
  - Context-footprint check failed: tool/resource definitions use about 1714 tokens (~214/item across 8 items; 6 tools + 2 resources), over budget; trim descriptions and params.
  - Usage-examples check failed: none of the tools include examples.
- **Stability & Change Management**: 27/100
  - Stability observed for 8 of 30 days with no destabilising changes; credit accrues until the full window elapses.
- **Tool Coverage**: 100/100
  - 100% of tools have a non-trivial description (not blank, and not just the tool's name).
  - 100% of tool parameters carry a description.
  - Structured output schemas are declared (100% of tools); any adoption earns full credit.
- **Capabilities**: 100/100
  - Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.

## Install

### Claude

```bash
claude mcp add --transport http cyanheads-socrata-mcp-server https://socrata.caseyjhand.com/mcp
```

### Codex

```toml
[mcp_servers.cyanheads-socrata-mcp-server]
url = "https://socrata.caseyjhand.com/mcp"
```

### opencode

```json
{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "cyanheads-socrata-mcp-server": {
      "type": "remote",
      "url": "https://socrata.caseyjhand.com/mcp",
      "enabled": true
    }
  }
}
```

### OpenClaw

```bash
openclaw mcp add cyanheads-socrata-mcp-server --url https://socrata.caseyjhand.com/mcp --transport streamable-http
```

### Hermes

```yaml
mcp_servers:
  cyanheads-socrata-mcp-server:
    url: "https://socrata.caseyjhand.com/mcp"
```

### Other

```json
{
  "mcpServers": {
    "cyanheads-socrata-mcp-server": {
      "type": "http",
      "url": "https://socrata.caseyjhand.com/mcp"
    }
  }
}
```

The mcpServers block is a cross-client convention. Remote transports vary, so check your client's docs.

## Changelog

Every change recorded for this component, newest first. Days that predate change tracking, or that we cannot explain, say so: "we were watching and nothing happened" and "we were not watching" are different claims.

### 2026-08-03 (score 71, +1)

No change was recorded against any check on this day. Stability & Change Management went from 23 to 27. That category is still filling its 30-day observation window: 7 days of observed history at the previous scan, 8 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-08-01 (score 70, +1)

No change was recorded against any check on this day. Stability & Change Management went from 17 to 20. That category is still filling its 30-day observation window: 5 days of observed history at the previous scan, 6 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-07-31 (score 69, +1)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-30 (score 68, 0)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-29 (score 68, +1)

No change was recorded against any check on this day. Stability & Change Management went from 7 to 10. That category is still filling its 30-day observation window: 2 days of observed history at the previous scan, 3 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-07-28 (score 67, +1)

No change was recorded against any check on this day. Stability & Change Management went from 3 to 7. That category is still filling its 30-day observation window: 1 days of observed history at the previous scan, 2 at this one. The score rises as the window fills, whether or not the server changes.

### 2026-07-27 (score 66, 0)

- [functional] We updated how we score, so this day's move reflects our rubric, not a change to the server

### 2026-07-26 (score 66)

First indexed and scored.

## MCP tools (6)

### `socrata_find_datasets` (~267 tokens)

Find Socrata Datasets

Search for datasets across all Socrata-powered government open-data portals, or scope to one portal with the domain parameter. Returns dataset IDs, names, abbreviated column lists, domains, and update timestamps. Use socrata_get_dataset to fetch the full typed column schema before writing queries — columnNames here are preview-only and lack type information.

Input parameters:

- `categories` (array): Filter by domain categories (e.g. ["Public Safety", "Transportation"]).
- `domain` (string): Scope search to a single portal (e.g. data.seattle.gov, data.cityofnewyork.us). Omit to search all portals.
- `limit` (integer): Number of results to return (1–100). Default 10.
- `offset` (integer): Pagination offset. Default 0.
- `only` (string): Filter by asset type. Omit to include all types. Usually "datasets" is what you want.
- `order` (string): Sort order. Defaults to relevance. Use updated_at to surface recently-refreshed datasets.
- `query` (string): Full-text search across dataset names and descriptions. Omit to browse without filtering.
- `tags` (array): Filter by tags (e.g. ["covid19", "permits"]).

Output parameters:

- `effectiveQuery` (string): Search query applied, for reference.
- `notice` (string): Recovery hint when results are empty — echoes filters and suggests how to broaden. Absent on non-empty result pages.
- `results` (array): Matching datasets. Empty when no results.
- `totalCount` (number): Total matches before pagination. 0 when empty.

### `socrata_get_dataset` (~150 tokens)

Get Dataset Schema

Fetch full metadata and column schema for a Socrata dataset by ID. Returns field names, data types, descriptions, row count, and licensing. Always call this before writing a socrata_query_dataset — the column types determine correct WHERE clause syntax: Number columns accept bare literals (year=2023) while Text columns require single-quoted strings (year='2023').

Input parameters:

- `dataset_id` (string, required): Four-by-four dataset ID matching pattern like kzjm-xkqj. Obtain from socrata_find_datasets.
- `domain` (string): Portal domain (e.g. data.seattle.gov). Defaults to SOCRATA_DEFAULT_DOMAIN env var or data.seattle.gov.

Output parameters:

- `category` (string): Domain category when available.
- `columns` (array): Column schema. Computed region columns (:@computed_region_*) are excluded to reduce noise.
- `data_updated_at` (string): ISO 8601 timestamp of last data update when available.
- `dataset_id` (string): Four-by-four dataset ID.
- `description` (string): Dataset description when available.
- `domain` (string): Portal domain hosting this dataset.
- `license` (string): License name when available.
- `name` (string): Dataset display name.
- `row_count` (number): Approximate row count when available. See row_count_source for provenance.
- `row_count_source` (string): How row_count was obtained: 'top_level_cached_contents' — reported directly by the portal's views metadata; 'column_cached_contents' — derived as the maximum per-column cached count when the top-leve…
- `tags` (array): Associated tags.

### `socrata_query_dataset` (~521 tokens)

Query Dataset

Execute a SoQL query against any dataset on any Socrata portal. Use the search parameter for quick full-text lookup, or combine select/where/group/having/order for full analytical control. Returns rows plus the assembled SoQL string so you can learn the pattern. All SODA 2.1 row values are strings even for numeric columns — check dataType from socrata_get_dataset to determine correct WHERE quoting: Number columns use bare literals (year=2023), Text columns use single-quoted strings (year='2023'). To enumerate distinct values, use select="col, count(*) as n" with group="col" and order="n DESC". When CANVAS_PROVIDER_TYPE=duckdb and rows fill the limit, results spill to a DataCanvas table for SQL-based analysis.

Input parameters:

- `canvas_id` (string): Optional 10-char DataCanvas token from a prior call. Omit on first call when CANVAS_PROVIDER_TYPE=duckdb to mint a fresh canvas. Large result sets spill here automatically.
- `dataset_id` (string, required): Four-by-four dataset ID (e.g. kzjm-xkqj). Obtain from socrata_find_datasets.
- `domain` (string): Portal domain (e.g. data.seattle.gov). Defaults to SOCRATA_DEFAULT_DOMAIN or data.seattle.gov.
- `group` (string): SoQL GROUP BY clause. Requires an aggregate function in select.
- `having` (string): SoQL HAVING clause. Filters on aggregated results, e.g. count > 100.
- `limit` (integer): Max rows to return (1–5000). Default 100. Use with offset for pagination.
- `offset` (integer): Row offset for pagination. Default 0.
- `order` (string): SoQL ORDER BY clause, e.g. "total_deaths DESC" or "date ASC".
- `search` (string): Full-text search across all text columns ($q). For field-specific filtering, use where instead.
- `select` (string): SoQL SELECT clause — column names, aliases, aggregates: "state, sum(deaths) as total_deaths". Omit for all columns.
- `where` (string): SoQL WHERE clause. Check column dataType from socrata_get_dataset first — Number columns: year=2023, Text columns: year='2023'. Operators: =, !=, >, <, LIKE, IN(...), BETWEEN, IS NULL, starts_with(),…

Output parameters:

- `assembled_query` (string): SoQL clauses assembled for this request — useful for learning the syntax.
- `canvas_id` (string): DataCanvas token when results spilled (requires CANVAS_PROVIDER_TYPE=duckdb). Pass to socrata_dataframe_query to run SQL over the staged rows — a bounded copy of the matching set (up to 50,000 rows,…
- `canvas_row_count` (number): Rows staged onto the DataCanvas — a bounded copy of the matching result set (capped at 50,000). Fewer than total_count when the match exceeds the cap. Present only when canvas_id is.
- `cap` (number): The row limit that was applied when capped.
- `dataset_id` (string): Dataset ID queried.
- `domain` (string): Portal domain queried.
- `notice` (string): Guidance when the query returned zero rows — suggests narrowing or reviewing the SoQL. Absent on non-empty result sets.
- `row_count` (number): Rows returned in this response.
- `rows` (array): Result rows. Scalar values are strings (SODA 2.1); geo/location columns return nested objects. Use column schema from socrata_get_dataset for type context.
- `shown` (number): Rows returned in this response when capped.
- `total_count` (number): Total matching source rows when a plain row query is truncated (row_count < total_count). Absent when the full result fits and for grouped/aggregate queries (group set), where a source-row count woul…
- `truncated` (boolean): True when rows filled the limit — more rows may match (see total_count when present). Spills to canvas when enabled.

### `socrata_list_portals` (~158 tokens)

List Socrata Portals

List known Socrata-powered government open-data portals with their domain, organization name, and approximate dataset count. The catalog is a curated list of 40 well-known portals; dataset counts are fetched from the Discovery API and cached for ~24 hours. Filtering is client-side substring match on the query parameter. Use this first when you do not know which portal to target, then pass the domain to socrata_find_datasets.

Input parameters:

- `limit` (integer): Max portals to return (1–200). Default 50.
- `offset` (integer): Pagination offset. Default 0.
- `query` (string): Keyword to filter portal names or organization names (case-insensitive substring match). Omit to list all portals.

Output parameters:

- `notice` (string): Recovery hint when no portals matched the filter. Absent on non-empty pages.
- `portals` (array): Matching portals. Empty when no results.
- `totalCount` (number): Total portals before pagination. 0 when empty.

### `socrata_dataframe_describe` (~129 tokens)

Describe DataCanvas Tables

List registered tables in a DataCanvas session — schema, row count, column names, and registration time. Shows what datasets are available for SQL queries via socrata_dataframe_query. Only meaningful when CANVAS_PROVIDER_TYPE=duckdb is set. Use after socrata_query_dataset spills a large result set to canvas.

Input parameters:

- `canvas_id` (string): Canvas ID returned by socrata_query_dataset when a large result spills to canvas. Required in practice when canvas is enabled — canvases cannot be enumerated, so omitting it fails with canvas_id_requ…

Output parameters:

- `canvas_id` (string): Canvas ID resolved, when canvas is enabled.
- `notice` (string): Status message when canvas is not enabled or no tables are registered. Absent when tables are present.
- `tables` (array): Tables available for SQL queries. Empty when none registered.

### `socrata_dataframe_query` (~177 tokens)

Query DataCanvas Table

Run SELECT-only SQL against a DataCanvas table populated by socrata_query_dataset. DuckDB infers types from spilled data, so numeric columns that SODA returned as strings become queryable with numeric comparisons (year > 2020, amount < 500). Only works when CANVAS_PROVIDER_TYPE=duckdb is set. Use socrata_dataframe_describe to see registered tables and their schemas.

Input parameters:

- `canvas_id` (string, required): Canvas ID returned from socrata_query_dataset or socrata_dataframe_describe.
- `limit` (integer): Max rows to return (1–10000). Default 1000.
- `sql` (string, required): SELECT-only SQL to run against registered canvas tables. DDL, DML, and file-reading functions are rejected. Use table names from socrata_dataframe_describe.

Output parameters:

- `canvas_id` (string): Canvas ID queried.
- `cap` (number): The row limit that was applied when capped.
- `notice` (string): Guidance when the SQL returned zero rows. Absent when rows are present.
- `row_count` (number): Number of rows returned.
- `rows` (array): Query result rows. DuckDB may return native JS types (number, boolean, null) for numeric/boolean columns.
- `shown` (number): Rows returned in this response when capped.
- `sql` (string): SQL that was executed.
- `truncated` (boolean): True when results were capped at the limit — more rows match the query.

## Diagnostics

Captured diagnostic sections: TLS, DNSSEC, Authorisation, Transports. The full working is on the page: https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata#diagnostics

## Score history

- 2026-08-03: 71
- 2026-08-02: 70
- 2026-08-01: 70
- 2026-07-31: 69
- 2026-07-30: 68
- 2026-07-29: 68
- 2026-07-28: 67
- 2026-07-27: 66
- 2026-07-26: 66

## Links

- Remote endpoint: https://socrata.caseyjhand.com/mcp
- Repository: https://github.com/cyanheads/socrata-mcp-server
- Changelog RSS feed: https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata/changelog.xml
- Changelog JSON feed: https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata/changelog.json
- HTML version of this page: https://verifymcp.io/servers/cyanheads-socrata-mcp-server/socrata