io.github.cyanheads/socrata-mcp-server
NPM · @CYANHEADS/SOCRATA-MCP-SERVER · 2 COMPONENTS · SCANNED SEP 20
Search and query government open-data portals (Socrata SODA API).
Available components
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security99
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- 16 of 60 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency48
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (Apache-2.0).Pass
- Actively maintained (last published 0 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability67
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1544 tokens (~257/item across 6 items; 6 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management97
- Stability observed for 29 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "socrata_query_dataset" implies "execute" and declares readOnlyHint instead, contradicting what its own name says it does. See how to fix → Fail
- An AI judge read all 7 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a current MCP spec version (2026-07-28).Pass
How do I install the io.github.cyanheads/socrata-mcp-server server?
io.github.cyanheads/socrata-mcp-server runs locally as an npm package, launched with npx -y @cyanheads/socrata-mcp-server. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @cyanheads/socrata-mcp-server
claude mcp add cyanheads-socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server
{
"mcpServers": {
"cyanheads-socrata-mcp-server": {
"command": "npx",
"args": [
"-y",
"@cyanheads/socrata-mcp-server"
]
}
}
} {
"servers": {
"cyanheads-socrata-mcp-server": {
"command": "npx",
"args": [
"-y",
"@cyanheads/socrata-mcp-server"
]
}
}
} codex mcp add cyanheads-socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"cyanheads-socrata-mcp-server": {
"type": "local",
"command": [
"npx",
"-y",
"@cyanheads/socrata-mcp-server"
],
"enabled": true
}
}
} openclaw mcp add cyanheads-socrata-mcp-server --command npx --arg -y --arg @cyanheads/socrata-mcp-server
mcp_servers:
cyanheads-socrata-mcp-server:
command: "npx"
args: ["-y", "@cyanheads/socrata-mcp-server"] {
"McpServers": {
"cyanheads-socrata-mcp-server": {
"Transport": "stdio",
"Command": "npx",
"Arguments": [
"-y",
"@cyanheads/socrata-mcp-server"
]
}
}
} assistant mcp add cyanheads-socrata-mcp-server -t stdio -c npx -a -y @cyanheads/socrata-mcp-server
{
"mcpServers": {
"cyanheads-socrata-mcp-server": {
"command": "npx",
"args": [
"-y",
"@cyanheads/socrata-mcp-server"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 20 Sept 26 −2
- Stability: 0.93 → unverified ▼ security
- Tool safety: pass → unverified ▼ security
- Schema quality: 213 → 257 ▼ functional
- Tool coverage: 100 → unverified ▼ functional
- Schema quality: 100 → unverified ▼ functional
- Capabilities: pass → unverified ▼ functional
- Security disclosure: pass → unverified ▼ functional
- Package version: 0.1.15 → 0.1.16 functional
- 19 Sept 26 +3
- Schema quality: 255 → 213 ▲ functional
- 17 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 14 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 73 to 77. That category is still filling its 30-day observation window: 22 days of observed history at the previous scan, 23 at this one. The score rises as the window fills, whether or not the server changes.
- 12 Sept 26 +1
- Security disclosure: unverified → pass ▲ functional
- 11 Sept 26 0
- Security disclosure: pass → unverified ▼ functional
- 10 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 60 to 63. That category is still filling its 30-day observation window: 18 days of observed history at the previous scan, 19 at this one. The score rises as the window fills, whether or not the server changes.
- 8 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 53 to 57. That category is still filling its 30-day observation window: 16 days of observed history at the previous scan, 17 at this one. The score rises as the window fills, whether or not the server changes.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 20 Sept 2026 · Analysed npm/@cyanheads/socrata-mcp-server@0.1.16
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | npm |
Background: How many MCP packages publish verified provenance →
Dependencies 60 packages
| Packages resolved | 60 |
|---|---|
| Stale | 16 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
socrata_dataframe_describe Describe DataCanvas Tables ~126
List registered tables in a DataCanvas session — schema, row count, and column names. 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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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… |
| Name | Type | Req | Description |
|---|---|---|---|
| canvas_id | string | – | Canvas ID resolved, when canvas is enabled. |
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
socrata_dataframe_query Query DataCanvas Table ~177
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.
| Name | Type | Req | Description |
|---|---|---|---|
| canvas_id | string | yes | Canvas ID returned from socrata_query_dataset or socrata_dataframe_describe. |
| limit | integer | – | Max rows to return (1–10000). Default 1000. |
| sql | string | yes | SELECT-only SQL to run against registered canvas tables. DDL, DML, and file-reading functions are rejected. Use table names from socrata_dataframe_describe. |
| Name | Type | Req | Description |
|---|---|---|---|
| canvas_id | string | – | Canvas ID queried. |
| cap | number | – | The row limit that was applied when capped. |
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
socrata_find_datasets Find Socrata Datasets ~267
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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"]). |
| Name | Type | Req | Description |
|---|---|---|---|
| effectiveQuery | string | – | Search query applied, for reference. |
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
socrata_get_dataset Get Dataset Schema ~150
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').
| Name | Type | Req | Description |
|---|---|---|---|
| dataset_id | string | yes | 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. |
| Name | Type | Req | Description |
|---|---|---|---|
| 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. |
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
socrata_list_portals List Socrata Portals ~158
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.
| Name | Type | Req | Description |
|---|---|---|---|
| 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. |
| Name | Type | Req | Description |
|---|---|---|---|
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
socrata_query_dataset Query Dataset ~533
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.
| Name | Type | Req | Description |
|---|---|---|---|
| canvas_id | string | – | Optional 10-char DataCanvas token from a prior socrata_query_dataset or socrata_dataframe_describe call. Omit on first call when CANVAS_PROVIDER_TYPE=duckdb to mint a fresh canvas. Large result sets… |
| dataset_id | string | yes | 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(),… |
| Name | Type | Req | Description |
|---|---|---|---|
| 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. |
| error | object | – | Present when the call failed. Absent on success. |
| 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. |
No examples provided.
What is the io.github.cyanheads/socrata-mcp-server server?
io.github.cyanheads/socrata-mcp-server is listed in the public MCP registry as io.github.cyanheads/socrata-mcp-server. Search and query government open-data portals (Socrata SODA API). This page covers its npm package (@cyanheads/socrata-mcp-server).
Is the io.github.cyanheads/socrata-mcp-server server safe to use?
io.github.cyanheads/socrata-mcp-server scores 81 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 September 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the io.github.cyanheads/socrata-mcp-server server expose?
io.github.cyanheads/socrata-mcp-server exposes 6 tools: socrata_find_datasets, socrata_get_dataset, socrata_query_dataset, socrata_list_portals, socrata_dataframe_describe, socrata_dataframe_query. Their descriptions and schemas cost roughly 1,411 tokens of context every time the server is loaded.
Is the io.github.cyanheads/socrata-mcp-server server still maintained?
io.github.cyanheads/socrata-mcp-server is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the io.github.cyanheads/socrata-mcp-server server under?
io.github.cyanheads/socrata-mcp-server declares the Apache-2.0 licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.