socrata-mcp-server
io.github.cyanheads/socrata-mcp-servercyanheadsstreamable-httpv0.7.0Scanned
Search and query government open-data portals (Socrata SODA API).
6 tools: 2 change things and 4 only read.
- Reads private data · 3
- Reads text others write · 4
- Can send data out · 0
- 2 findings
Tools listed without sign-in. Remote posture
With Anlyon
2 tools here change things. Govern them.
- Anlyon lists the tools and adopts none.
- Each tool you adopt gets approvals and receipts.
- Your agent never holds the key.
A tool your agent calls directly is not routed through Anlyon and is not governed by it. Anlyon Radar only lists and labels, and these labels are the same either way.
What the socrata-mcp-server can do
The socrata-mcp-server is published by the GitHub account cyanheads. It has 6 tools. It can create or change data (2 tools: socrata_query_dataset and socrata_dataframe_query), but cannot delete data. 4 tools only read.
3 tools read private data (socrata_query_dataset, socrata_dataframe_describe and socrata_dataframe_query); 4 tools bring in text other people can write (socrata_find_datasets, socrata_get_dataset, socrata_query_dataset and 1 more).
The fixed checks matched 2 findings (annotation-conflict). Each one comes with the text it matched.
Its remote endpoint lists its tools without sign-in, and its tools changed 3 times since Anlyon Radar first saw them.
Last scanned Nov 8, 2026, version 0.7.0.
Tools
Grouped by what each tool does, most consequential first. Open one for its reasons and full description; descriptions are the publisher's own words.
6 tools
Changes things 2Claude Code: ask
socrata_dataframe_queryRun SELECT-only SQL against a DataCanvas table populated by socrata_query_dataset.Reads private data1 finding
Why it is in this group
- The name "socrata_dataframe_query" says "query": a word for reading.
- The description's first verb is "run": a word for a change.
- The input takes a statement or command to run (input.sql), which can change anything it can reach.
- The server marks it read-only (readOnlyHint: true), but an annotation never lowers a class.
What it can reach
- private-dataThe description's first sentence says "sql": it reads databases.
- private-dataThe name says "query" and the input takes a statement (input.sql): it reads databases.
Findings
- Warn
The server marks "socrata_dataframe_query" read-only (readOnlyHint: true), and its own name, description or input give the class "write".
What this check looks forMatched text
annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false}; The name "socrata_dataframe_query" says "query": a word for reading.
Description, as the server wrote it 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.
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: false
socrata_query_datasetExecute a SoQL query against any dataset on any Socrata portal.Reads private dataReads text others write1 finding
Why it is in this group
- The name "socrata_query_dataset" says "query": a word for reading.
- The description's first verb is "execute": a word for a change.
- The server marks it read-only (readOnlyHint: true), but an annotation never lowers a class.
What it can reach
- private-dataThe input names a table (input.table_name), and the tool reads: it reads databases.
- untrusted-inputThe server marks it openWorldHint: true: it reaches things outside the server's own data.
Findings
- Warn
The server marks "socrata_query_dataset" read-only (readOnlyHint: true), and its own name, description or input give the class "write".
What this check looks forMatched text
annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true}; The name "socrata_query_dataset" says "query": a word for reading.
Description, as the server wrote it 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.
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: true
Only reads 4Show 4 read-only tools
socrata_dataframe_describeList registered tables in a DataCanvas session — schema, row count, and column names.Reads private dataNo findings
Why it is in this group
- The name "socrata_dataframe_describe" says "describe": a word for reading.
What it can reach
- private-dataThe description's first sentence says "list" and "table": it reads databases.
Description, as the server wrote it 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.
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: false
socrata_find_datasetsSearch for datasets across all Socrata-powered government open-data portals, or scope to one portal with the domain parameter.Reads text others writeNo findings
Why it is in this group
- The name "socrata_find_datasets" says "find": a word for reading.
What it can reach
- untrusted-inputThe server marks it openWorldHint: true: it reaches things outside the server's own data.
Description, as the server wrote it 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.
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: true
socrata_get_datasetFetch full metadata and column schema for a Socrata dataset by ID.Reads text others writeNo findings
Why it is in this group
- The name "socrata_get_dataset" says "get": a word for reading.
What it can reach
- untrusted-inputThe server marks it openWorldHint: true: it reaches things outside the server's own data.
Description, as the server wrote it 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').
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: true
socrata_list_portalsList known Socrata-powered government open-data portals with their domain, organization name, and approximate dataset count.Reads text others writeNo findings
Why it is in this group
- The name "socrata_list_portals" says "list": a word for reading.
What it can reach
- untrusted-inputThe server marks it openWorldHint: true: it reaches things outside the server's own data.
Description, as the server wrote it 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.
Annotations the server declares
- readOnlyHint: true
- idempotentHint: true
- openWorldHint: true
This is not a safety rating, and no finding is not a safety guarantee. The groups and findings come from fixed checks of the tool definitions the server returned on the date shown, not from its code or what it does when called. How the checks work.
Exfil surface
Which tools read private data, which read text someone else can write, and which can send data out. One of each is a path a prompt injection can use.
No private-data, untrusted-input, outbound path in this server alone: no tool is tagged outbound.
- Reads private data3
- Reads files, mail, messages, databases, secrets, calendars or repositories.
- Reads text others write4
- Brings in text someone else can write: web pages, inbound email, messages, issues and comments.
- Can send data out0
- Can carry data to people or systems: it sends, posts or publishes, or takes a recipient, channel or URL.
Other servers in the same agent add their own tools to these paths. Audit your whole setup to see them together.
Remote posture
What anyone on the internet sees at the remote endpoint: an anonymous initialize and tools/list, and the public OAuth metadata.
Looked at Nov 20, 2026, 19:34 UTC, unchanged since Oct 22, 2026. No credentials were sent and no tool was called. What is looked at.
- Reachable
- yes
- HTTP status of an anonymous initialize
- 200
- tools/list served without credentials
- yes
- Tools that change things, listed without credentials
- 2
- Protocol version
- 2025-06-18
- WWW-Authenticate on 401
- not observed
- resource_metadata in WWW-Authenticate
- not observed
- RFC 9728 protected resource metadata
- not observed
- Authorization servers
- not observed
- Legacy HTTP+SSE transport
- no
- Dynamic client registration
- not observed
- Client ID metadata documents
- not observed
- WarnThe whole server
The endpoint served tools/list without credentials, and the list has 2 tools that change things (2 write). Whether a call also works without credentials was not tested: tools are never called.
What this check looks forMatched text
https://socrata.caseyjhand.com/mcp: tools/list returned 6 tools to an anonymous client, including socrata_query_dataset (write), socrata_dataframe_query (write)
Findings
Matches of fixed checks, with the text they matched.
The server marks "socrata_query_dataset" read-only (readOnlyHint: true), and its own name, description or input give the class "write".
What this check looks forMatched text
annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true}; The name "socrata_query_dataset" says "query": a word for reading.
The server marks "socrata_dataframe_query" read-only (readOnlyHint: true), and its own name, description or input give the class "write".
What this check looks forMatched text
annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false}; The name "socrata_dataframe_query" says "query": a word for reading.
History
Changes to its tool definitions and to its remote endpoint, newest first.
Tools1 changed.~1 changedView diff
- Changed:socrata_dataframe_queryChanges thingsinputSchema
Tools6 changed.~6 changedView diff
- Changed:socrata_dataframe_describeOnly readsannotations
- Changed:socrata_dataframe_queryChanges thingsannotations
- Changed:socrata_find_datasetsOnly readsinputSchema
- Changed:socrata_get_datasetOnly readsinputSchemaannotations
- Changed:socrata_list_portalsOnly readsannotations
- Changed:socrata_query_datasetChanges thingsdescriptioninputSchemaannotations
Tools4 changed.~4 changedView diff
- Changed:socrata_dataframe_describeOnly readsdescription
- Changed:socrata_dataframe_queryChanges thingsdescriptioninputSchema
- Changed:socrata_find_datasetsOnly readsinputSchema
- Changed:socrata_query_datasetChanges thingsdescriptioninputSchema
Install
Pinned to version 0.7.0. Values in angle brackets are yours to fill in.
claude mcp add --transport http socrata https://socrata.caseyjhand.com/mcpclaude mcp add --transport http socrata https://socrata.caseyjhand.com/mcpRun in a terminal.
Claude Code permissions
Allow the reads, ask before a change or a way out, deny the deletes. Paste into .claude/settings.json.
{
"permissions": {
"allow": [
"mcp__socrata__socrata_find_datasets",
"mcp__socrata__socrata_get_dataset",
"mcp__socrata__socrata_list_portals",
"mcp__socrata__socrata_dataframe_describe"
],
"ask": [
"mcp__socrata__socrata_query_dataset",
"mcp__socrata__socrata_dataframe_query"
],
"deny": []
}
}Tools that only read are allowed, tools that change things ask first, tools that delete or cancel are denied. A read that can send data out (it takes a URL, say) asks first too. It assumes the server is installed as socrata. Review it before you use it.
Capability tags behind 6 rules
- mcp__socrata__socrata_find_datasets untrusted-input
- mcp__socrata__socrata_get_dataset untrusted-input
- mcp__socrata__socrata_query_dataset private-data, untrusted-input
- mcp__socrata__socrata_list_portals untrusted-input
- mcp__socrata__socrata_dataframe_describe private-data
- mcp__socrata__socrata_dataframe_query private-data
Pin
Keep the decision: fail CI when the tools change, follow every change, or show a badge.
Pin in CI
Fail a build when the tools you reviewed are not the tools the server serves today.
curl -s "https://radar.anlyon.com/api/v1/servers/io.github.cyanheads/socrata-mcp-server/verify?hash=b542ddfb218e2c37cb0a5e3a8b08a7fbb0d2c3f2570e59b2d99f1dce19c2e9c8" | jq -e '.changed == false'Pinned hash b542ddfb218e, from Nov 8, 2026, 18:18 UTC.
Watch
Get told when its tools change: a new tool, a new description, a new class.
https://radar.anlyon.com/servers/io.github.cyanheads/socrata-mcp-server/changes.xmlAn Atom feed. Works in any feed reader or Slack's RSS app.
Badge
[](https://radar.anlyon.com/servers/io.github.cyanheads/socrata-mcp-server)Source: MCP Registry · repository. Synced Nov 8, 2026, 18:17 UTC.
socrata-mcp-server: questions and answers
Answered from the scan above, not from the publisher's description.
Is the socrata-mcp-server safe?
- No scan can promise that. What its definitions show: 6 tools, 2 of which can change, send or delete something, and 2 findings from fixed checks. Allow the reads, ask before each change, and deny the deletes; the permissions block on this page does that.
Can the socrata-mcp-server delete data?
- No tool is classed as destructive: going by their definitions, none of them deletes, cancels or revokes anything.
Can the socrata-mcp-server do things that cannot be undone?
- No tool is classed as irreversible: none of them sends, pays, publishes or merges, going by their definitions.
What tools does the socrata-mcp-server have?
- 6 tools: 2 write, 4 read. socrata_query_dataset, socrata_dataframe_query, socrata_find_datasets, socrata_get_dataset, socrata_list_portals and socrata_dataframe_describe.
Does the socrata-mcp-server need sign-in or OAuth?
- Its remote endpoint listed its tools to an anonymous client, without sign-in.
Does the socrata-mcp-server send data to outside services?
- None of its tools sends, posts or publishes, or takes a recipient, channel or URL.
Has the socrata-mcp-server changed its tools?
- Yes, 3 times since Anlyon Radar started tracking it, most recently on Nov 8, 2026. Every change is on this page and in its Atom feed.