Skip to main content
MCP server CX Codex

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

Install into Claude Code · Platform CLI: remote server All methods and platforms ↓
claude mcp add --transport http socrata-mcp-server https://socrata-mcp-server--cyanheads.run.tools
Open on GitHub

What 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-nv7g on domain data.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.tools

Step 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').

Similar MCP servers

All MCP servers for Data and databases →

Project sponsors

Companies that keep this analytics open