io.github.cyanheads/socrata-mcp-server
REMOTE · SOCRATA.CASEYJHAND.COM · 2 COMPONENTS
Search and query government open-data portals (Socrata SODA API).
Available components
Last scanned (2 hours ago)
Scores higher than 84% of remote servers
Reachable. Last reached 5 Nov 2026.
Category Data and Analytics
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. How we score → Why this is hard to score →
Endpoint Security66
- The endpoint's TLS certificate is valid, in date, and uses a strong key. View diagnostics → Pass
- Authorisation not fully verified: no authorisation is required to call this server, and 1 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe. See how to fix → View diagnostics → Unverified
- HTTPS is enforced; there's no plaintext access path. View diagnostics → Pass
- The HSTS (Strict-Transport-Security) header is present. View diagnostics → Pass
- DNSSEC is configured correctly; the domain's records validate against the full chain to the root. View diagnostics → Pass
Transport & Reachability100
- Verified streamable-http transport via a live MCP handshake. View diagnostics → Pass
Schema Quality & AI Usability77
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 2571 tokens (~285/item across 9 items; 6 tools + 3 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 Management100
- No destabilizing schema changes in the last 30 days.Pass
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 8 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
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.
- 5 Nov 26 +57
- Injection markers: unverified → pass ▲ security
- Stability: unverified → pass ▲ security
- HSTS header: fail → pass ▲ security
- Transport: fail → pass ▲ security
- Authorization: Authorisation not fully verified: no authorisation is required to call this server, and 1 tool(s) never declared a destructiveHint. The MCP spec treats an absent hint as destructive by default, so we cannot call this surface safe. security
- Tool “socrata_query_dataset” rewrote its description, which is the text the model reads security
- Endpoint reachability: not serving MCP → reachable ▲ functional
- Tool coverage: unverified → 100 ▲ functional
- MCP protocol: unverified → pass ▲ functional
- Schema quality: unverified → 100 ▲ functional
- Server version: 0.6.0 → 0.6.1 functional
- “socrata_query_dataset” added an optional parameter “stage” cosmetic
- “socrata_query_dataset” reworded the description of “limit” cosmetic
- “socrata_query_dataset” reworded the description of “canvas_id” cosmetic
- “socrata_find_datasets” reworded the description of “tags” cosmetic
- “socrata_find_datasets” reworded the description of “domain” cosmetic
- “socrata_find_datasets” reworded the description of “categories” cosmetic
- 4 Nov 26 −57
- Endpoint reachability: reachable → not serving MCP ▼ security
- Stability: pass → unverified ▼ security
- Tool safety: pass → unverified ▼ security
- Transport: pass → fail ▼ security
- HSTS header: pass → fail ▼ security
- Authorization: Authorisation not yet verified: we couldn't confirm whether this endpoint requires it. security
- Capabilities: pass → unverified ▼ functional
- Schema quality: 100 → unverified ▼ functional
- Tool coverage: 100 → unverified ▼ functional
- 31 Oct 26 0
- Tool “socrata_query_dataset” rewrote its description, which is the text the model reads security
- Tool “socrata_dataframe_describe” rewrote its description, which is the text the model reads security
- Tool “socrata_dataframe_query” rewrote its description, which is the text the model reads security
- Schema quality: 244 → 271 ▼ functional
- Server version: 0.5.1 → 0.6.0 functional
- “socrata_query_dataset” added an optional parameter “table_name” cosmetic
- “socrata_query_dataset” reworded the description of “limit” cosmetic
- “socrata_query_dataset” reworded the description of “canvas_id” cosmetic
- “socrata_find_datasets” reworded the description of “tags” cosmetic
- “socrata_find_datasets” reworded the description of “offset” cosmetic
- “socrata_find_datasets” reworded the description of “limit” cosmetic
- “socrata_find_datasets” reworded the description of “categories” cosmetic
- “socrata_dataframe_query” reworded the description of “limit” cosmetic
- 28 Oct 26 0
- New resource “socrata-guide” functional
- Server version: 0.4.0 → 0.5.1 functional
- 24 Oct 26 0
- The server rewrote its instructions, which are the text every model session reads security
- Server version: 0.3.0 → 0.4.0 functional
- 4 Oct 26 0
- Server version: 0.2.1 → 0.3.0 functional
- 28 Sept 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 25 Sept 26 0
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
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 5 Nov 2026 · Probed https://socrata.caseyjhand.com/mcp
TLS valid
Negotiated TLS 1.3 with TLS_AES_128_GCM_SHA256 .
| Subject | Issuer | Valid from | Valid until | Key | Signature | Serial |
|---|---|---|---|---|---|---|
| CN=caseyjhand.com | CN=WE1,O=Google Trust Services,C=US | 2 Nov 2026 | 31 Jan 2027 | ECDSA 256 | ECDSA-SHA256 | 995a30681ab772540e934241ca1d576c |
| SANs: caseyjhand.com, *.caseyjhand.com | ||||||
| CN=WE1,O=Google Trust Services,C=US (CA) | CN=GTS Root R4,O=Google Trust Services LLC,C=US | 13 Dec 2023 | 20 Feb 2029 | ECDSA 256 | ECDSA-SHA384 | 7ff31977972c224a76155d13b6d685e3 |
| CN=GTS Root R4,O=Google Trust Services LLC,C=US (CA) | CN=GlobalSign Root CA,OU=Root CA,O=GlobalSign nv-sa,C=BE | 15 Nov 2023 | 28 Jan 2028 | ECDSA 384 | SHA256-RSA | 7fe530bf331343bedd821610493d8a1b |
Background: What to check on a remote MCP endpoint →
DNSSEC secure
Validation of socrata.caseyjhand.com. — Secure
| Zone | DS | Keys | Algorithms | Outcome |
|---|---|---|---|---|
| . | trust_anchor | 20326, 38696 | 8, 8 | Verified |
| com. | present | 19718 | 13 | Verified |
| caseyjhand.com. | present | 2371 | 13 | Verified |
| socrata.caseyjhand.com. | Verified address RRset verified with the apex keys |
Authentication No authorisation required
The endpoint answered without asking for a token. Anyone who knows the URL can reach it.
| Result | No authorisation required |
|---|---|
| HTTP status | 200 |
| Header | Value |
|---|---|
| strict-transport-security | max-age=63072000; includeSubDomains; preload |
| x-content-type-options | nosniff |
Background: How OAuth 2.1 works in the 2026 MCP spec →
Transports 2 probes
| Transport | URL | Outcome | Status | Location |
|---|---|---|---|---|
| streamable-http | https://socrata.caseyjhand.com/mcp | Verified | 200 | |
| http (plaintext) | http://socrata.caseyjhand.com/mcp | HTTPS enforced | 301 | https://socrata.caseyjhand.com/mcp |
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 ~123
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. Meaningful when the server has a DataCanvas. 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 ~231
Run SELECT-only SQL against a DataCanvas table populated by socrata_query_dataset. Columns SODA types as number (including aggregate aliases like count(*) as n) are staged as DOUBLE, so numeric comparisons work without a cast (year > 2020, amount < 500). Text and timestamp columns stay VARCHAR — compare times with CAST(date AS TIMESTAMP). Works when the server has a DataCanvas. 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–50,000). One call returns at most 10,000 rows: a larger limit is served as 10,000, with a notice naming how to page through the rest when more rows match. 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 for this page: how to adjust the SQL when it returned zero rows, or how to reach the rest when rows were capped, naming the requested and served limit when a limit above the 10,000-row per-c… |
| 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 ~422
Search for datasets across all Socrata-powered government open-data portals, or scope to one portal with the domain parameter. Returns dataset IDs, names, domains, update timestamps, and column_names — the API field names SoQL takes, not display labels. Use socrata_get_dataset to fetch the typed column schema before writing queries — column_names carry no type information.
| Name | Type | Req | Description |
|---|---|---|---|
| categories | array | – | Filter by the portal's own categories (e.g. ["Public Safety", "Transportation"]). Requires domain: each portal assigns its own categories. Multiple values are ORed: a dataset in any listed category m… |
| domain | string | – | Scope search to a single portal by bare hostname (e.g. data.seattle.gov, data.cityofnewyork.us); URL forms like https://data.seattle.gov/ are accepted and reduced to the host. Omit to search all port… |
| limit | integer | – | Number of results to return (1–10,000). One call returns at most 100 results: a larger limit is served as 100, with a notice naming the offset that continues. Default 10. |
| offset | integer | – | Pagination offset. Default 0. Must be below 10,000: the Discovery catalog serves only the first 10,000 matches of a search. |
| 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 the portal's own tags (e.g. ["covid19", "permits"]). Requires domain: each portal assigns its own tags. Multiple values are ORed: a dataset carrying any listed tag matches. Across portals,… |
| Name | Type | Req | Description |
|---|---|---|---|
| effectiveQuery | string | – | Search query applied, for reference. |
| error | object | – | Present when the call failed. Absent on success. |
| notice | string | – | Guidance for this page. When limit was served below the requested value (the 100-result per-call cap or the 10,000-match window), names the served limit and where paging continues; when results are e… |
| results | array | – | Matching datasets. Empty when no results. |
| totalCount | number | – | Total matches before pagination. 0 when empty. Discovery counts no further than 10,000: when totalCountCapped is true, 10,000 is a lower bound. |
| totalCountCapped | boolean | – | True when totalCount reached Discovery's 10,000-match count ceiling, so more datasets may match than totalCount says. Absent otherwise. |
No examples provided.
socrata_get_dataset Get Dataset Schema ~219
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. IDs are portal-scoped: take it from socrata_find_datasets together with that result’s domain. |
| domain | string | – | Portal the dataset lives on, as a bare hostname (e.g. data.cityofnewyork.us); URL forms like https://data.cityofnewyork.us/ are accepted and reduced to the host. Pass the domain from the same socrata… |
| Name | Type | Req | Description |
|---|---|---|---|
| asset_type | string | – | Catalog asset type, such as dataset, filter (a filtered view), map, chart, calendar, visualization, measure, story, href (an external link), federated_href, file. Only dataset and filter answer socra… |
| 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 39 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 for an empty page: no portals matched the filter, or offset passed the last portal (names the offset to page below). 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 ~975
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. Columns are referenced by API field name (field_name from socrata_get_dataset, e.g. cuisine_description), never the display label. All SODA 2.1 row values are strings even for numeric columns — check data_type 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 the server has a canvas and more rows match past a full page, up to 50,000 matching rows spill to a DataCanvas table whatever the limit: list its columns with socrata_dataframe_describe, then run SQL with socrata_dataframe_query. Pass stage false to return the page alone, without staging.
| 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 to mint a fresh canvas. Large result sets spill here automatically unless s… |
| dataset_id | string | yes | Four-by-four dataset ID (e.g. kzjm-xkqj). IDs are portal-scoped: take it from socrata_find_datasets together with that result’s domain. |
| domain | string | – | Portal the dataset lives on, as a bare hostname (e.g. data.cityofnewyork.us); URL forms like https://data.cityofnewyork.us/ are accepted and reduced to the host. Pass the domain from the same socrata… |
| group | string | – | SoQL GROUP BY clause over API field names (field_name from socrata_get_dataset). 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–50,000). One call returns at most 5,000 rows: a larger limit is served as 5,000, with a notice naming the offset that continues when more rows match. Default 100. Use with offse… |
| offset | integer | – | Row offset for pagination. Default 0. |
| order | string | – | SoQL ORDER BY clause over API field names or select aliases, 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 — API field names (field_name from socrata_get_dataset, not display labels), aliases, aggregates: "state, sum(deaths) as total_deaths". Omit for all columns. |
| stage | boolean | – | Stage the matching rows on a canvas when more rows match past this page and the server has a canvas. Default true. Pass false to return the page alone, skipping the staging request; canvas_id and tab… |
| table_name | string | – | Name for the canvas table a spill stages: letters, digits, and underscores, starting with a letter or underscore, 63 characters at most; lowercased, and not a SQL keyword such as select or order. Def… |
| where | string | – | SoQL WHERE clause over API field names (field_name from socrata_get_dataset). Check column data_type there first — Number columns: year=2023, Text columns: year='2023'; an unquoted text value is read… |
| 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. Pass to socrata_dataframe_query to run SQL over the staged rows in table_name — a bounded copy of the matching set (up to 50,000 rows, reported in canvas_row_co… |
| 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 hostname queried, normalized from the domain input. |
| error | object | – | Present when the call failed. Absent on success. |
| notice | string | – | Guidance when the query returned zero rows (review the SoQL or broaden the filter; past offset 0, whether the offset passed the end of the match), or when more rows match past this page: how to page,… |
| 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. |
| table_name | string | – | Canvas table holding the staged rows; present when canvas_id is. Use it as the FROM target in socrata_dataframe_query SQL; list its columns with socrata_dataframe_describe. |
| total_count | number | – | Rows the query matches, in the same unit as rows: groups for a grouped query, distinct values for a distinct select. Counted when rows fill limit or a page past offset 0 comes back empty; present whe… |
| truncated | boolean | – | True when more rows match past this page: total_count exceeds offset + row_count, or rows filled the limit and no count was made. Spills to canvas when enabled and stage is not false; table_name name… |
No examples provided.
How do I install the io.github.cyanheads/socrata-mcp-server server?
io.github.cyanheads/socrata-mcp-server is a hosted endpoint at https://socrata.caseyjhand.com/mcp, so there is nothing to install locally. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
remote · socrata.caseyjhand.com
claude mcp add --transport http cyanheads-socrata-mcp-server 'https://socrata.caseyjhand.com/mcp'
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 hosted endpoint (https://socrata.caseyjhand.com/mcp).
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. 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 2,128 tokens of context every time the server is loaded.
Does the io.github.cyanheads/socrata-mcp-server server require authentication?
No. We connected to io.github.cyanheads/socrata-mcp-server without credentials and it answered, so anything it exposes is reachable by anyone who knows the address.
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 5 November 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.