MCP server

Socrata

io.github.cyanheads/socrata-mcp-server

Checked 26 Oct 2026, 08:29 UTC · Connected to it and listed its tools

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

Source

At a glance

Type

MCP server

Publisher

Not verified

Status

Working at last check

Tools

6

Token cost

About 2,750 tokens per request

Sets up in

Claude Code, Claude Desktop, Codex, Gemini CLI, Cursor, VS Code, Antigravity, ChatGPT, OpenAI API, Grok

Last checked

26 Oct 2026, 08:29 UTC

Connect it to your agent

Add to CursorAdd to VS CodeVS Code Insiders

Opens the app, which shows the server and asks you to confirm. For other apps, copy the setup below.

Claude Code

claude mcp add --transport http socrata-mcp-server https://socrata.caseyjhand.com/mcp

Claude Desktop

Settings → Connectors → Add custom connector, and paste the URL.

Codex (config.toml)

[mcp_servers.socrata-mcp-server]
url = "https://socrata.caseyjhand.com/mcp"

Gemini CLI

{"mcpServers":{"socrata-mcp-server":{"httpUrl":"https://socrata.caseyjhand.com/mcp"}}}

Cursor

{"mcpServers":{"socrata-mcp-server":{"url":"https://socrata.caseyjhand.com/mcp"}}}

VS Code

{"servers":{"socrata-mcp-server":{"type":"http","url":"https://socrata.caseyjhand.com/mcp"}}}

Antigravity

agy mcp add socrata-mcp-server https://socrata.caseyjhand.com/mcp

ChatGPT

Settings → Apps & Connectors → Advanced settings: turn on Developer mode, then Create a connector and paste the URL. Which plans can do this varies.

OpenAI API (Responses tools)

{"type":"mcp","server_label":"socrata-mcp-server","server_url":"https://socrata.caseyjhand.com/mcp","require_approval":"always"}

Grok (xAI API tools)

{"type":"mcp","server_label":"socrata-mcp-server","server_url":"https://socrata.caseyjhand.com/mcp"}

Tools

• socrata_dataframe_describe ~225 tokens
  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 ~333 tokens
  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
• socrata_find_datasets ~526 tokens
  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 ~328 tokens
  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_list_portals ~291 tokens
  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_query_dataset ~1047 tokens
  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

Browse

• GitHub tools
• GitHub and code hosting
• Databases
• Government and public data

Related MCP servers

• Nova Scotia Data Explorer
  Query and explore Nova Scotia open datasets via the Socrata SODA API.
• Data Calgary
  DataCalgary MCP — Calgary open data (data.calgary.ca, Socrata SODA API).
• Data Cambridge
  DataCambridge MCP — Cambridge open data (data.cambridgema.gov, Socrata SODA API).
• Data Dallas
  DataDallas MCP — Dallas open data (www.dallasopendata.com, Socrata SODA API).
• Data Edmonton
  DataEdmonton MCP — Edmonton open data (data.edmonton.ca, Socrata SODA API).
• Data Seattle
  DataSeattle MCP — Seattle open data (data.seattle.gov, Socrata SODA API).
• Data Austin
  DataAustin MCP — Austin, TX open data (data.austintexas.gov, Socrata SODA API).
• Data Cincinnati
  DataCincinnati MCP — Cincinnati open data (data.cincinnati-oh.gov, Socrata SODA API).

Badge for your README

[![AptLynx](https://aptlynx.net/badge/io.github.cyanheads/socrata-mcp-server.svg)](https://aptlynx.net/servers/io.github.cyanheads/socrata-mcp-server)

Listing text is written by the maker; AptLynx lists tools and does not vouch for them. Find another tool · Browse by topic · For agents