Socrata MCP Server
Search and query government open-data portals (Socrata SODA API).
Connect it
Settings → Connectors → Add custom connector
URL: https://socrata.caseyjhand.com/mcpSettings → Apps & Connectors → Advanced → Developer mode
Create connector with URL: https://socrata.caseyjhand.com/mcp{
"mcpServers": {
"socrata-mcp-server": {
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}claude mcp add --transport http socrata-mcp-server https://socrata.caseyjhand.com/mcp{
"servers": {
"socrata-mcp-server": {
"type": "http",
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}{
"mcpServers": {
"socrata-mcp-server": {
"command": "npx",
"args": [
"-y",
"@cyanheads/socrata-mcp-server@0.3.0"
]
}
}
}claude mcp add socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server@0.3.06 tools, verified live
socrata_find_datasetsread-onlySearch 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 column schema before writing queries â column_names carry no type information.
socrata_get_datasetread-onlyFetch 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) while Text columns require single-quoted strings (year='2023').
socrata_query_datasetread-onlyExecute 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 name (field_name from socrata_get_dataset, e.g. cuisine_description), never the display label. All SO
socrata_list_portalsread-onlyList 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 the query parameter. Use this first when you do not know which portal to target, then pass the doma
socrata_dataframe_describeread-onlyList 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_queryread-onlyRun 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). Only works when CANVAS_PROVIDER_TYPE=duckdb is set. Use s
Alternatives in Search & Research
Compare →CAConnected AppsA
Read Gmail, search GitHub, update Sheets, and post to Slack through Composio.
FLflightclawA
Search ~300 airlines and book flights with a checkout link. OAuth sign-in by email code.
SESerpApiA
Official SerpApi MCP server for Google, Bing, and other search engines.
SKSkillmdA
Search, fetch, lint, and install Agent Skills (SKILL.md) from the SkillMD registry.
WRWrapsA
Search the Wraps docs and estimate AWS SES costs. Public, read-only, no authentication.
FRfreeqA
Read and verify freeq conversations: channels, history, search, signatures, pins.