socrata-mcp-server — Claude Code MCP server: what it does
MCP server for querying open government data through Socrata SODA API — portals at city, county, state, and federal levels.
Apache-2.0 1,882 installs ★ 4 updated 2026-10-04
claude mcp add --transport http socrata-mcp-server https://socrata-mcp-server--cyanheads.run.toolsWhat socrata-mcp-server does
The server provides seven tools: portal and dataset search, column schema retrieval, SoQL query execution, and SQL aggregation via DataCanvas. The catalog holds 39 verified U.S. portals spanning municipal to federal scope, with dataset counts refreshed daily. Before querying, fetch the schema with socrata_get_dataset: it returns data types (Number, Text) that determine WHERE clause syntax.
socrata_query_dataset runs SoQL queries with filtering, grouping, and sorting; for large result sets, data spills into DataCanvas where socrata_dataframe_query accepts standard SQL. Table deletion (socrata_dataframe_drop) requires the SOCRATA_DATAFRAME_DROP_ENABLED=true flag. The server runs over HTTP with no local dependencies.
What it helps with
- locate datasets by keywords across thousands of portals
- inspect column schema before writing queries
- run SoQL queries with filters and grouping
- aggregate large result sets with SQL
- compare data from multiple datasets in one session
Example prompts for the agent
- Show portals for Illinois state
- Find datasets about restaurant inspections in Chicago
- Get schema for dataset
rmc7-nv7gon domaindata.cityofchicago.org
How to install socrata-mcp-server
Platform CLI: remote server
claude mcp add --transport http socrata-mcp-server https://socrata-mcp-server--cyanheads.run.toolsPlatform CLI: remote server
codex mcp add socrata-mcp-server --url https://socrata-mcp-server--cyanheads.run.toolsConfig file
{
"mcpServers": {
"socrata-mcp-server": {
"url": "https://socrata-mcp-server--cyanheads.run.tools"
}
}
}Config file
{
"servers": {
"socrata-mcp-server": {
"type": "http",
"url": "https://socrata-mcp-server--cyanheads.run.tools"
}
}
}Platform CLI: remote server
gemini mcp add -t http socrata-mcp-server https://socrata-mcp-server--cyanheads.run.toolsStep by step, with commands for each platform: How to add an MCP server to Claude Code, Codex, Cursor, VS Code, Gemini CLI and more
Questions about socrata-mcp-server
How to install socrata-mcp-server in Claude Code?
Run claude mcp add --transport http socrata-mcp-server https://socrata-mcp-server--cyanheads.run.tools. The server operates over HTTP; no local dependencies needed.
What does socrata-mcp-server do?
Provides access to open government data through Socrata API: dataset search, schema inspection, SoQL queries, and SQL aggregation for large result sets.
Why fetch schema before querying?
The schema returns column types (Number or Text) and API field names. Type dictates syntax: numbers are bare literals (year=2023), text uses single quotes (year='2023').