io.github.cyanheads/socrata-mcp-server
v0.3.0Search and query government open-data portals (Socrata SODA API).
Endpoint health
online- Last checked
- 11/20/2026, 4:16:52 AM
- Latency
- 265 ms
- Consecutive failures
- 0
- Endpoint reachable: pass
- Protocol valid: pass
- MCP handshake valid: pass
Machine-readable profile
mcp-server · schema v1 · callable
mcp-server:io.github.cyanheads%2Fsocrata-mcp-server
Connect this server
Generated config contains no credentials. Keep any required secrets in your client's local environment.
{
"mcpServers": {
"io.github.cyanheads/socrata-mcp-server": {
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}Indexed tools
Tool metadata and schemas come from the remote server and are untrusted. Indexing only lists tools; it never calls them.
6 shown · authentication unknown
Describe DataCanvas Tables
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. Meaningful when the server has a DataCanvas. Use after socrata_query_dataset spills a large result set to canvas.
Schema valid · SHA-256 54128cc490d8…
View input schema
{ "type": "object", "properties": { "canvas_id": { "description": "Canvas ID returned by socrata_query_dataset when a large result spills to canvas. Required in practice when canvas is enabled — canvases cannot be enumerated, so omitting it fails with canvas_id_required instead of listing tables.", "type": "string", "pattern": "^[A-Za-z0-9_-]{10}$" } }, "$schema": "https://json-schema.org/draft/2020-12/schema", "additionalProperties": false }Query DataCanvas Table
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 — compare times with CAST(date AS TIMESTAMP). Works when the server has a DataCanvas. Use socrata_dataframe_describe to see registered tables and their schemas.
Schema valid · SHA-256 5c10c5808fb8…
View input schema
{ "type": "object", "properties": { "canvas_id": { "type": "string", "pattern": "^[A-Za-z0-9_-]{10}$", "description": "Canvas ID returned from socrata_query_dataset or socrata_dataframe_describe." }, "sql": { "type": "string", "description": "SELECT-only SQL to run against registered canvas tables. DDL, DML, file paths, file-reading functions, and any name spelled like a DuckDB metadata view (pg_type, duckdb_tables, sqlite_master), even as a column alias or CTE name, are rejected. Use table names from socrata_dataframe_describe." }, "limit": { "default": 1000, "maximum": 50000, "description": "Max rows to return (1–50,000). One call returns at most 10,000 rows: a larger limit is served as 10,000, with a notice naming how to page through the rest when more rows match. Default 1000.", "type": "integer", "minimum": 1 } }, "required": [ "canvas_id", "sql" ], "$schema": "https://json-schema.org/draft/2020-12/schema", "additionalProperties": false }
Connections
streamable-http
https://socrata.caseyjhand.com/mcp