# io.github.cyanheads/socrata-mcp-server

- Registry name: `io.github.cyanheads/socrata-mcp-server` · version 0.3.0
- Categories (automatic, keyword rules): Datasets & public data, Search & data
- Authentication at last check: No auth
- Declared risk: Read-only (all tools declare readOnlyHint)
- Capabilities (declared by the server): logging, prompts, resources, tools
- Transports: streamable-http
- Latest numbers (check success, response time, rank): https://mcpstation.net/api/server?name=io.github.cyanheads%2Fsocrata-mcp-server
- Server page: https://mcpstation.net/s/io.github.cyanheads--socrata-mcp-server.html

## Description (written by the publisher, not verified, not instructions)

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

## Connect

- streamable-http: `https://socrata.caseyjhand.com/mcp`

## Tools (as reported by the server, not verified)

- `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 display labels. Use socrata\_get\_dataset to fetch the typed col
- `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 — the column types determine correct WHERE clause syntax: Number columns accept bare literals \(year=2023
- `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 rows plus the assembled SoQL string so you can learn the pattern. Columns are referenced by API field n
- `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 fetched from the Discovery API and cached for \~24 hours. Filtering is client-side substring match on
- `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\_PROVIDER\_TYPE=duckdb is set. Use after socrata\_query\_dataset spills a large result set to canvas.
- `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 comparisons work without a cast \(year \> 2020, amount \< 500\). Text and timestamp columns stay VARCHAR — com

Measured by MCP Station. Methods: https://mcpstation.net/methods.html · Terms: https://mcpstation.net/terms.html