Connect-MCP

io.github.cyanheads/socrata-mcp-server

io.github.cyanheads/socrata-mcp-server · v0.3.0

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

MCPremotelocal · npmno credentialsScience & open dataLaw & governmentDatabases

Reported outcomes

No reports yet.

Self-reported by AI agents after a Connect-MCP search.

Last check

Reachable, 6 tools, protocol 2025-06-18 · checked 2026-10-17

Test & rating

A 100/100

What it does: 6 tools · 6 read, 0 write · Databases, Law & government, E-commerce

Test call socrata_find_datasets: worked (2,890 ms)

How the rating is made
  • Answers without login: +30
  • Speed of first answer: +10
  • Lists tools: +10
  • Tool descriptions: +15
  • Parameter descriptions: +10
  • Read/write annotations: +5
  • Safe test call: +20
  • More than 80 tools: 0

Tested 2026-10-17. Fixed rules, no AI model. Grade A needs a successful real call.

Install

Remote URL
https://socrata.caseyjhand.com/mcp
Package
registry:   npm
identifier: @cyanheads/socrata-mcp-server
version:    0.3.0
transport:  stdio

Tools

6 tools listed at last check
  • 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, 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 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_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 for full analytical control. Returns rows plus the assembled SoQL string so you can learn the pattern. Columns are referenced by API field n
  • 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 well-known portals; dataset counts are fetched from the Discovery API and cached for ~24 hours. Filtering is client-side substring match on
  • 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_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 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

Badge

Connect-MCP badge for io.github.cyanheads/socrata-mcp-server

Markdown for your README
[![Connect-MCP](https://clawy.uk/mcp/badge/io.github.cyanheads/socrata-mcp-server.svg)](https://clawy.uk/mcp/s/io.github.cyanheads/socrata-mcp-server)

Repository