io.github.cyanheads/socrata-mcp-server

up checked 2026-11-11T08:40:18.008Z

Unclaimed · Unverified

Agent searches it appeared in, last 30 days: 0. Run this server? Claim the listing: verified label, uptime alerts and analytics.

Publisher-provided description

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

Summary by lookupd

Lets an agent search open-data portals, read dataset schemas, run SoQL queries on government datasets, and run SQL over the results.

Install

Claude Code, remote (streamable-http)

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

Claude Code, npm package (stdio)

claude mcp add socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server

Claude Code, npm package (stdio)

claude mcp add socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server

Codex, remote (streamable-http)

codex mcp add socrata-mcp-server --url https://socrata.caseyjhand.com/mcp

Codex, npm package (stdio)

codex mcp add socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server

Codex, npm package (stdio)

codex mcp add socrata-mcp-server -- npx -y @cyanheads/socrata-mcp-server

Cursor, remote (streamable-http) → .cursor/mcp.json

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

Cursor, npm package (stdio) → .cursor/mcp.json

{
  "mcpServers": {
    "socrata-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@cyanheads/socrata-mcp-server"
      ]
    }
  }
}

Cursor, npm package (stdio) → .cursor/mcp.json

{
  "mcpServers": {
    "socrata-mcp-server": {
      "command": "npx",
      "args": [
        "-y",
        "@cyanheads/socrata-mcp-server"
      ]
    }
  }
}

Other clients: docs. Or tell your agent: Set up lookupd for me: read https://lookupd.com/agent.md and follow it.

Tools (6 tools)

Publisher-provided text

socrata_find_datasets Search for datasets across all Socrata-powered government open-data portals, or scope to one portal with the domain parameter. Returns dataset IDs, names, domai
socrata_get_dataset 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 bef
socrata_query_dataset 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
socrata_list_portals 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
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_qu
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)

Details

Version: 0.7.0
Transports: streamable-http, stdio
Uptime (7 days): 100%
Median latency: 599 ms
First indexed: 2026-11-01T09:26:40.068Z
Last seen in registry: 2026-11-08T18:17:25.089Z
Repository: https://github.com/cyanheads/socrata-mcp-server

Badge for your README

Shows this live status and links here; updates hourly.

[![lookupd status](https://lookupd.com/badge/io.github.cyanheads/socrata-mcp-server.svg)](https://lookupd.com/servers/io.github.cyanheads/socrata-mcp-server)

62092 servers
Last crawl: 2026-11-11T17:38:11.606Z
API base: https://api.lookupd.com
MCP URL: https://api.lookupd.com/mcp