socrata-mcp-server
Search and query government open-data portals (Socrata SODA API)
Reviews
No review yet. Used socrata-mcp-server? Be the first to help others choose.What it does
socrata-mcp-server is an MCP server, a connector that lets an AI assistant use it as a tool. It can be used hosted (nothing to install) or installed locally.
No capability identified yet from its description.
Facts come from the Official MCP Registry, as declared by the publisher. Capabilities are matched automatically (low confidence). None of this is a test of the tool.
At a glance
How to connect
As declared in the Official MCP Registry · hosted endpoint tested by Electra Index 16h ago (live check)Hosted endpoint
https://socrata.caseyjhand.com/mcpstreamable-http
In Claude Code: claude mcp add --transport http socrata-mcp-server https://socrata.caseyjhand.com/mcp
Install packages
- NPM
@cyanheads/socrata-mcp-serverv0.7.0 · runs locally (stdio) - NPM
@cyanheads/socrata-mcp-serverv0.7.0 · runs as a server (streamable-http)
MCP settings (Claude Desktop, Cursor and other MCP clients)
{
"mcpServers": {
"socrata-mcp-server": {
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}Live check
Electra Index connected to the hosted endpoint 16h agoONLINE socrata-mcp-server answered an MCP connection on 17 Nov 2026 and introduced itself as socrata-mcp-server 0.7.0 (MCP protocol 2025-06-18).
6 tools offered to AI assistants
socrata_find_datasets· 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 disocrata_get_dataset· 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 csocrata_query_dataset· 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 yousocrata_list_portals· 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 cachesocrata_dataframe_describe· 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_datasesocrata_dataframe_query· 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,
What "online" means: the server answered an MCP connection at the time of the check. It is not a guarantee of security, quality or continuous uptime. How we test: we open an MCP session and ask for the tool list, as an AI assistant would. We never run a tool and never send a key. Checked every few days. Method
Is this your server? Monitoring Pro: a check every 30 minutes and an email within the hour when it stops answering. Launch offer: $39.99 once, for life.
Facts & evidence
Each fact shows where it was seen and when.| Fact | Value | Evidence | Source | Last confirmed |
|---|---|---|---|---|
| Install package | @cyanheads/socrata-mcp-server, @cyanheads/socrata-mcp-server | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Version | 0.7.0 | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Hosted endpoint | https://socrata.caseyjhand.com/mcp | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Package registries | npm | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Local install (package) | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Remote access (hosted) | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Repository | https://github.com/cyanheads/socrata-mcp-server | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| Registry status | active | DECLARED | SRC-001 Official MCP Registry | 1d ago |
| MCP server | yes | DECLARED | SRC-001 Official MCP Registry | 1d ago |
Change history
- VERSION08 Nov 20260.6.1 → 0.7.0
- VERSION04 Nov 20260.6.0 → 0.6.1
- VERSION31 Oct 20260.5.1 → 0.6.0
- VERSION28 Oct 20260.4.0 → 0.5.1
- VERSION24 Oct 20260.3.0 → 0.4.0
- VERSION04 Oct 20260.2.1 → 0.3.0
Is this page accurate?
Flag it and our robot re-checks the official source. Reports never change a score.Is socrata-mcp-server still online?
Free alerts · no account▲ 0Do you run socrata-mcp-server? Know when it stops answering
For publishers · optionalIts hosted endpoint can be monitored. Monitoring Pro connects every 30 minutes like an AI assistant, emails you within the hour when it stops answering, keeps a 90-day availability history and adds your answer rate to your badge.
Monitoring never changes a score or a rank.
Questions about socrata-mcp-server
How do I connect socrata-mcp-server?
Use the hosted endpoint https://socrata.caseyjhand.com/mcp in your assistant's MCP settings. The exact settings are in "How to connect" above, as declared in the Official MCP Registry.
What tools does socrata-mcp-server offer?
When Electra Index connected on 17 Nov 2026, it listed 6 tools: socrata_find_datasets, socrata_get_dataset, socrata_query_dataset, socrata_list_portals, socrata_dataframe_describe, socrata_dataframe_query. The full list is in "Live check" above.
Is socrata-mcp-server online?
Yes. Its hosted endpoint answered an MCP connection from Electra Index 16h ago.