Back to search
100
MCP v0.1.3 streamable-http

io.github.cyanheads/socrata-mcp-server

io.github.cyanheads/socrata-mcp-server

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

Uptime
—
no direct probes in 30d
Response
536ms
last probe
Tools
6
callable
Resources
0
readable
Prompts
0
available
Primary URL
https://socrata.caseyjhand.com/mcp

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, abbreviated column lists, domains, and update…

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 dataset count. Backed by the Discovery API domains catalog. Filtering is client-side substring match o…

socrata_dataframe_describe

List registered tables in a DataCanvas session — schema, row count, column names, and registration time. Shows what datasets are available for SQL queries via socrata_dataframe_query. Only meaningful …

socrata_dataframe_query

Run SELECT-only SQL against a DataCanvas table populated by socrata_query_dataset. DuckDB infers types from spilled data, so numeric columns that SODA returned as strings become queryable with numeric…

How to use

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

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