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.
- mcp-ts-core Agent-native TypeScript framework for building MCP servers with declarative definitions. ★ 148
- obsidian-mcp-server Read, write, search, and surgically edit Obsidian notes, tags, and frontmatter via MCP. ★ 668
- git-mcp-server Comprehensive Git MCP server enabling native git tools including clone, commit, worktree, & more. ★ 235
- pubmed-mcp-server Search PubMed/Europe PMC, fetch articles and full text (PMC/EPMC/Unpaywall), citations, MeSH terms. ★ 137
- clinicaltrialsgov-mcp-server Search ClinicalTrials.gov - find studies, retrieve results, match patients to eligible trials. ★ 90
- mcp-ts-template TypeScript template for building MCP servers with declarative tooling, observability, and auth. ★ 148
05 · Facts
- repository
- github.com/cyanheads/socrata-mcp-server
- 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
Alternatives to Socrata MCP Server
Maintained API integration servers if Socrata MCP Server isn't the fit.
- Microsoft 365 MCP Server Interact with Microsoft 365 and Office services through the Microsoft Graph API. ★ 932 · 2026-08-24
- Tapo MCP MCP server for discovering and controlling TP-Link Tapo smart home devices via AI Agents ★ 796 · 2026-08-21
- Idea Reality MCP Pre-build reality check. Scans GitHub, HN, npm, PyPI, Product Hunt - returns 0-100 signal. ★ 782 · 2026-08-11
- Sqz Pre-injection context compression for coding agents. Zero LLM calls, zero telemetry, offline-safe. ★ 609 · 2026-08-23
- Sv Number MCP Server Phone numbers for AI agents: order a private number, read the SMS verification code, hand it back. ★ 560 · 2026-08-10
- Anytype MCP Official MCP server for Anytype API - your encrypted, local and collaborative wiki. ★ 510 · 2026-08-24
More API integration MCP servers · Justicelibre · AiPayGen - 65+ AI Tools as an MCP Server · Hibp · Ovh API MCP · HAL
More TypeScript MCP servers · Stackexchange MCP Server · Survey MCP Server · Toolkit MCP Server · Treasury Fiscaldata MCP Server · Un Comtrade MCP Server · see all