io.github.cyanheads/socrata-mcp-server
REMOTE · SOCRATA.CASEYJHAND.COM · 2 COMPONENTS · SCANNED AUG 3
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 against the live server, and we only credit what we can confirm. How we 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 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. 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 1714 tokens (~214/item across 8 items; 6 tools + 2 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 Management27
- Stability observed for 8 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
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
Add this component to your MCP client. Where a client-specific snippet is available, pick your client below and copy it straight into your config; otherwise use the connection detail shown.
remote · socrata.caseyjhand.com
claude mcp add --transport http cyanheads-socrata-mcp-server https://socrata.caseyjhand.com/mcp
[mcp_servers.cyanheads-socrata-mcp-server] url = "https://socrata.caseyjhand.com/mcp"
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"cyanheads-socrata-mcp-server": {
"type": "remote",
"url": "https://socrata.caseyjhand.com/mcp",
"enabled": true
}
}
} openclaw mcp add cyanheads-socrata-mcp-server --url https://socrata.caseyjhand.com/mcp --transport streamable-http
mcp_servers:
cyanheads-socrata-mcp-server:
url: "https://socrata.caseyjhand.com/mcp" {
"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.
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.
- 3 Aug 26 +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.
- 1 Aug 26 +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.
- 31 Jul 26 +1
- We updated how we score, so this day's move reflects our rubric, not a change to the server See what changed → functional
- 30 Jul 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
- 29 Jul 26 +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.
- 28 Jul 26 +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.
- 27 Jul 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
- 26 Jul 26 66
First indexed and scored.
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 3 Aug 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 | 7 Jul 2026 | 5 Oct 2026 | ECDSA 256 | ECDSA-SHA256 | 5aad900eb2055a0b0ea55912ec19680c |
| 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 |
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 |
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.
socrata_dataframe_describe Describe DataCanvas Tables ~129
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.
| 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. |
| notice | string | — | Status message when canvas is not enabled or no tables are registered. Absent when tables are present. |
| tables | array | yes | 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 | yes | 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 | yes | Number of rows returned. |
| rows | array | yes | 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 | yes | 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. |
| notice | string | — | Recovery hint when results are empty — echoes filters and suggests how to broaden. Absent on non-empty result pages. |
| results | array | yes | Matching datasets. Empty when no results. |
| totalCount | number | yes | 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 | yes | 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 | yes | Four-by-four dataset ID. |
| description | string | — | Dataset description when available. |
| domain | string | yes | Portal domain hosting this dataset. |
| license | string | — | License name when available. |
| name | string | yes | 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 | yes | 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 |
|---|---|---|---|
| notice | string | — | Recovery hint when no portals matched the filter. Absent on non-empty pages. |
| portals | array | yes | Matching portals. Empty when no results. |
| totalCount | number | yes | Total portals before pagination. 0 when empty. |
No examples provided.
socrata_query_dataset Query Dataset ~521
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 call. Omit on first call when CANVAS_PROVIDER_TYPE=duckdb to mint a fresh canvas. Large result sets spill here automatically. |
| 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 | yes | 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 | yes | Dataset ID queried. |
| domain | string | yes | 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 | yes | Rows returned in this response. |
| rows | array | yes | 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.