Socrata MCP Server

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

People who work with socrata, dataset and dataframe and want it reachable from Claude, Cursor, VS Code, or another MCP client. The project is written in TypeScript.

VERIFIED ACTIVE

LAST COMMIT 2026-09-22 · ★ 3 · #81 OF 292 MAINTAINED API INTEGRATION · VERIFIED 2026-09-30

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-09-30

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.

The 6 tools it gives your agent

Extracted from the project's README - what socrata-mcp-server lets an agent do.

socrata_list_portals
- List known Socrata-powered government open-data portals with domain, organization name, and approximate dataset count
socrata_find_datasets
- Search for datasets across all Socrata portals or scope to one portal via the Discovery API
socrata_get_dataset
- Fetch full metadata and typed column schema for a dataset by ID - required before writing SoQL queries
socrata_query_dataset
- Execute a SoQL query against any dataset: search, select, where, group, having, order, with DataCanvas spillover
socrata_dataframe_describe
- List registered tables in a DataCanvas session - schema, row count, column names
socrata_dataframe_query
- Run SELECT-only SQL against DataCanvas tables populated by socrata_query_dataset

Latest releases

v0.2.1 · 2026-09-22

Canvas typing, table names, full-length rendering · socrata_query_dataset spills register a typed schema from the SODA response headers (number → DOUBLE) instead of a 100-row DuckDB sniff (#25) · socrata_query_dataset…

v0.2.0 · 2026-09-22

Error classification, portal scoping, SoQL field names · socrata_find_datasets column_names now carries SoQL field names instead of display labels - ⚠️ breaking output change (#29) · Non-Socrata hosts (HTML 404, DNS…

v0.1.16 · 2026-09-20

mcp-ts-core 0.13 canvas-id and error contract adoption · canvas_id is validated as a minted token at argument validation - a blank or malformed value is now an argument rejection, never a canvas lookup · Argument…

04 · Who maintains Socrata MCP Server

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

  1. obsidian-mcp-server Read, write, search, and surgically edit Obsidian notes, tags, and frontmatter via MCP. ★ 690
  2. mcp-ts-core Agent-native TypeScript framework for MCP servers. ★ 152
  3. git-mcp-server Comprehensive Git MCP server enabling native git tools including clone, commit, worktree, & more. ★ 240
  4. clinicaltrialsgov-mcp-server Search ClinicalTrials.gov - find studies, retrieve results, match patients to eligible trials. ★ 96
  5. openalex-mcp-server Access the OpenAlex academic research catalog - 270M+ publications. ★ 14
  6. mcp-ts-template TypeScript template for building MCP servers with declarative tooling, observability, and auth. ★ 152

05 · Facts

repository
github.com/cyanheads/socrata-mcp-server
category
API integration - ranked #81 of 292 actively-maintained API integration servers as of 2026-09-30.
release cadence
9 releases in the last 90 days (latest 2026-09-22)
registry
io.github.cyanheads/socrata-mcp-server (active, first published 2026-05-23 · 18 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-09-30, its last commit was 2026-09-22 and it shipped 9 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-09-30; you can connect without credentials.

07 · Alternatives to Socrata MCP Server

Alternatives to Socrata MCP Server

Maintained API integration servers if Socrata MCP Server isn't the fit.

  1. LetsFG - Flights & Hotels Search and book flights and hotels: hundreds of airlines, plus bookable hotel rates. ★ 2,075 · 2026-09-29
  2. Microsoft 365 MCP Server Interact with Microsoft 365 and Office services through the Microsoft Graph API. ★ 1,002 · 2026-09-29
  3. Idea Reality MCP Pre-build reality check. Scans GitHub, HN, npm, PyPI, Product Hunt - returns 0-100 signal. ★ 823 · 2026-09-18
  4. Tapo MCP MCP server for discovering and controlling TP-Link Tapo smart home devices via AI Agents ★ 810 · 2026-09-29
  5. Sv Number MCP Server Phone numbers for AI agents: order a private number, read the SMS verification code, hand it back. ★ 551 · 2026-08-10
  6. Anytype MCP Official MCP server for Anytype API - your encrypted, local and collaborative wiki. ★ 528 · 2026-09-21

More API integration MCP servers · Dabra MCP · Justicelibre · AiPayGen - 65+ AI Tools as an MCP Server · Hibp · Ovh API MCP

More TypeScript MCP servers · Sports MCP Server · Stackexchange MCP Server · Survey MCP Server · Toolkit MCP Server · Treasury Fiscaldata MCP Server · see all