Back to search
100
MCP live v0.1.3 MCP 2026-07-28 http

socrata-mcp-server

io.github.cyanheads/socrata-mcp-server

Search and query government open-data portals (Socrata SODA API).

Uptime
100.0%
4 direct probes · 30d
Response
1381ms
last probe
Tools
6
callable
Resources
2
readable
Prompts
1
available
Primary URL
https://socrata.caseyjhand.com/mcp
Score: 100/100
Handshake verified by our own probe.
why this score
pass Answers the MCP handshake 50/50
The handshake and the list calls succeeded on the primary URL.
pass Lists tools, resources or prompts 30/30
6 tools, 2 resources, 1 prompts returned.
pass 3 or more catalogue items 10/10
9 items in total; 3 or more earns these points.
pass Describes itself 10/10
65 characters; more than 30 earns these points.

Tools · 6

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 …

socrata_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 — th…

socrata_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 row…

socrata_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 …

socrata_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. Only meaningful when CANVAS_PROVIDE…

socrata_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 compar…

Resources · 2

socrata-portals

List of known Socrata-powered government open-data portals with organization name and approximate dataset count. The catalog is a curated list of 39 well-known portals; dataset counts are fetched from…

socrata://portals
Seattle 911 Incidents (example)

Fetch full metadata and column schema for a Socrata dataset addressable by stable URI. Same payload as socrata_get_dataset. Name, description, and column descriptions are upstream-provided portal meta…

socrata://datasets/data.seattle.gov/kzjm-xkqj

Prompts · 1

explore_open_data

Structured workflow for investigating a civic data question. Guides: discover relevant datasets on the right portal, inspect schemas, query for baseline data, group/aggregate for trends, and synthesiz…

How to use

Add to your Claude Desktop / Cursor / Cline MCP config:

{
  "mcpServers": {
    "socrata-mcp-server": {
      "url": "https://socrata.caseyjhand.com/mcp",
      "transport": "http"
    }
  }
}