Socrata MCP Server

@cyanheads/socrata-mcp-server Search and query government open-data portals (Socrata SODA API) via MCP. STDIO or Streamable HTTP. Its 7 documented tools cover socrata, dataset, dataframe.

People connecting API integration tools to Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-08-22 · ★ 2 · #76 OF 250 MAINTAINED API INTEGRATION · VERIFIED 2026-08-25

Apache-2.0 · TypeScript servers · how we verify → /methodology

01 · Install Socrata MCP Server

before you install - you'll need

Set MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL before connecting.

Claude Code

claude mcp add cyanheads-socrata-mcp-server --transport http https://socrata.caseyjhand.com/mcp

Claude Desktop / Cursor / VS Code - add to config

{
  "mcpServers": {
    "cyanheads-socrata-mcp-server": {
      "url": "https://socrata.caseyjhand.com/mcp"
    }
  }
}

Same JSON for Cursor. For VS Code, rename the top-level key from `mcpServers` to `servers`.

Using another client? Same JSON, different key

Claude Desktop · mcpServers

Cursor · mcpServers

VS Code · servers

Windsurf · mcpServers

Zed · context_servers

Cline · mcpServers

Roo Code · mcpServers

Continue · mcpServers

LibreChat · mcpServers

Gemini CLI · mcpServers

Codex CLI · mcp_servers

Full setup guides: every client.

02 · Evidence

https://socrata.caseyjhand.com/mcp

transport: streamable-http

endpoint alive - responded to MCP initialize · probed 2026-08-25

Security posture

What to check before giving this server access to your agent - from the registry, GitHub, and our own probes. We don't score safety; we show what's verifiable.

runs as local process (stdio) - runs on your machine with your user's permissions · remote - your agent's requests go to socrata.caseyjhand.com

endpoint auth accepted our unauthenticated MCP initialize - no credentials needed to connect

license Apache-2.0 - declared in the repository

npm package @cyanheads/socrata-mcp-server - published under the repo owner's npm scope (@cyanheads)

registry namespace io.github.cyanheads is GitHub-verified and matches the repo owner

03 · What Socrata MCP Server can do

Prose above is summarized from the project's README and registry record - no invented capabilities.

What you can build

With this server connected, an agent can list known Socrata-powered government open-data portals with domain, organization name, and approximate dataset count, search for datasets across all Socrata portals or scope to one portal via the Discovery API, fetch full metadata and typed column schema for a dataset by ID - required before writing SoQL queries, and execute a SoQL query against any dataset: search, select, where, group, having, order, with DataCanvas spillover.

Capability map

Tools grouped from the project's README - what Socrata MCP Server lets an agent do.

Socrata

6 tools - e.g. List known Socrata-powered government open-data portals with domain, organization name, and approximate dataset count; Search for datasets across all Socrata portals or scope to one portal via the…

socrata_list_portals · socrata_find_datasets · socrata_get_dataset · socrata_query_dataset · socrata_dataframe_describe · socrata_dataframe_query

Aggregation

1 tool - e.g. count(), sum(), avg(), min(), max() with group and having

Aggregation

Latest releases

v0.1.15 · 2026-08-22

MCP SDK v2 maintenance · Serves protocol revision 2026-07-28 alongside the supported 2025 HTTP revision, with strict top-level tool inputs and advertised error envelopes · Resource responses now advertise their JSON…

v0.1.14 · 2026-07-10

Discovery domain aliases, keyless token fallback · Two coupled fixes to socrata_find_datasets and app-token handling. · Changed: · invalid_app_token error contract removed from socrata_find_datasets…

v0.1.13 · 2026-07-10

mcp-ts-core ^0.10.14, supply-chain hardening · Full content[] rendering, bounded paginated canvas spillover, and sql_rejected contract parity for socrata_dataframe_query. · Added: · table_not_found error contract on…

04 · Who maintains Socrata MCP Server

socrata-mcp-server is maintained by cyanheads. We track 125 MCP servers from cyanheads - 124 actively maintained, 1,730 combined GitHub stars, oldest repo from Dec 2024. Full record: all servers from cyanheads.

  1. mcp-ts-core Agent-native TypeScript framework for building MCP servers with declarative definitions. ★ 148
  2. obsidian-mcp-server Read, write, search, and surgically edit Obsidian notes, tags, and frontmatter via MCP. ★ 668
  3. git-mcp-server Comprehensive Git MCP server enabling native git tools including clone, commit, worktree, & more. ★ 235
  4. pubmed-mcp-server Search PubMed/Europe PMC, fetch articles and full text (PMC/EPMC/Unpaywall), citations, MeSH terms. ★ 137
  5. clinicaltrialsgov-mcp-server Search ClinicalTrials.gov - find studies, retrieve results, match patients to eligible trials. ★ 90
  6. mcp-ts-template TypeScript template for building MCP servers with declarative tooling, observability, and auth. ★ 148

05 · Facts

category
API integration - ranked #76 of 250 actively-maintained API integration servers as of 2026-08-25.
release cadence
10+ releases in the last 90 days (latest 2026-08-22)
registry
io.github.cyanheads/socrata-mcp-server (active, first published 2026-05-23 · 15 versions)
packages
npm:@cyanheads/socrata-mcp-server · npm:@cyanheads/socrata-mcp-server

06 · Socrata MCP Server FAQ

Is Socrata MCP Server still maintained?

Yes - as of 2026-08-25, its last commit was 2026-08-22 and it shipped 10+ releases in the last 90 days. We re-verify nightly.

What can Socrata MCP Server do?

With this server connected, an agent can list known Socrata-powered government open-data portals with domain, organization name, and approximate dataset count, search for datasets across all Socrata portals or scope to one portal via the Discovery API, fetch full metadata and typed column schema for a dataset by ID - required before writing SoQL queries, and execute a SoQL query against any dataset: search, select, where, group, having, order, with DataCanvas spillover.

How do I install Socrata MCP Server?

Run `npx -y @cyanheads/socrata-mcp-server`. The README documents 2 environment variables (MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL) to set first. Set MCP_TRANSPORT_TYPE, MCP_LOG_LEVEL before connecting. You can also paste the ready-made client config above.

Does Socrata MCP Server require authentication?

No - the endpoint accepted our unauthenticated MCP initialize when probed on 2026-08-25; you can connect without credentials.

07 · Alternatives to Socrata MCP Server