Skip to content

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.

Tools: 0 delete, 0 irreversible, 2 write, 4 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.
Govern this server →

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".

      Matched text

      annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false}; The name "socrata_dataframe_query" says "query": a word for reading.

      What this check looks for
    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".

      Matched text

      annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true}; The name "socrata_query_dataset" says "query": a word for reading.

      What this check looks for
    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.

Tools listed without sign-in

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.

    Matched text

    https://socrata.caseyjhand.com/mcp: tools/list returned 6 tools to an anonymous client, including socrata_query_dataset (write), socrata_dataframe_query (write)

    What this check looks for

Findings

Matches of fixed checks, with the text they matched.

2 warn
  • The server marks "socrata_query_dataset" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

    Matched text

    annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true}; The name "socrata_query_dataset" says "query": a word for reading.

    What this check looks for
  • The server marks "socrata_dataframe_query" read-only (readOnlyHint: true), and its own name, description or input give the class "write".

    Matched text

    annotations: {"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false}; The name "socrata_dataframe_query" says "query": a word for reading.

    What this check looks for

History

Changes to its tool definitions and to its remote endpoint, newest first.

  1. Tools1 changed.~1 changedView diff
  2. Tools6 changed.~6 changedView diff
  3. Tools4 changed.~4 changedView diff

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/mcp
claude mcp add --transport http socrata https://socrata.caseyjhand.com/mcp

Run 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.

.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.xml

An Atom feed. Works in any feed reader or Slack's RSS app.

Badge

Anlyon Radar badge for io.github.cyanheads/socrata-mcp-server
[![Anlyon Radar](https://radar.anlyon.com/badge/io.github.cyanheads/socrata-mcp-server.svg)](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.