ZBS Index What actually exists in applied AI, with the source next to it

mcp server

socrata-mcp-server

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

Description as published by the maintainer. Source

  • version 0.1.14
  • active
  • document understanding
  • retrieval

active — Most recent push to the repository was 2026-07-30. Dashed tags are derived by ZBS Index from the published description, not stated by the maintainer.

What this server can do

6 functions, named and described by the server itself. Parameter names are shown because they say more about what a function does than its name usually does.

socrata_dataframe_describe(canvas_id)
List registered tables in a DataCanvas session — schema, row count, column names, and registration time. 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(sql, limit, canvas_id)
Run SELECT-only SQL against a DataCanvas table populated by socrata_query_dataset. DuckDB infers types from spilled data, so numeric columns that SODA returned as strings become queryable with numeric comparisons (year > 2020, amount < 500). Only works when CANVAS_PROVIDER_TYPE=duckdb is set. Use socrata_dataframe_describe to see registered tables and their schemas. Required: canvas_id, sql.
socrata_find_datasets(only, tags, limit, order, query, domain, offset, categories)
Search for datasets across all Socrata-powered government open-data portals, or scope to one portal with the domain parameter. Returns dataset IDs, names, abbreviated column lists, domains, and update timestamps. Use socrata_get_dataset to fetch the full typed column schema before writing queries — columnNames here are preview-only and lack type information.
socrata_get_dataset(domain, dataset_id)
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) while Text columns require single-quoted strings (year='2023'). Required: dataset_id.
socrata_list_portals(limit, query, offset)
List known Socrata-powered government open-data portals with their domain, organization name, and approximate dataset count. The catalog is a curated list of 40 well-known portals; dataset counts are fetched from the Discovery API and cached for ~24 hours. Filtering is client-side substring match on the query parameter. Use this first when you do not know which portal to target, then pass the domain to socrata_find_datasets.
socrata_query_dataset(group, limit, order, where, domain, having, offset, search, select, canvas_id, dataset_id)
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. All SODA 2.1 row values are strings even for numeric columns — check dataType from socrata_get_dataset to determine correct WHERE quoting: Number columns use bare literals (year=2023), Text columns use single-quoted strings (year='2023'). To enumerate distinct values, use select="col, count(*) as n" with group="col" and order="n DESC". When CANVAS_PROVIDER_TYPE=duckdb and rows fill the limit, results spill to a DataCanvas table for SQL-based analysis. Required: dataset_id.

Last successful function declaration observed on . Source: https://socrata.caseyjhand.com/mcp. We list what the server declared; we do not call any of these functions.

Endpoint status observed on . Source: https://socrata.caseyjhand.com/mcp.

Signals

These are separate measurements of different things. They are deliberately not combined into one score, because a popularity number that mixes website traffic with saves and stars cannot be checked or acted on.

Signal Value What it measures Window Observed Source
GitHub stars 2 Number of GitHub accounts that bookmarked this repository since it was created. It is a bookmark count, not installs, not active users and not quality. cumulative, all time GitHub
Last commit 2026-07-30 Date of the most recent push to any branch. This is the strongest cheap indicator of whether the project is still maintained. point in time GitHub
Open issues 7 Open issues plus open pull requests, as GitHub counts them together. A high number can mean an active project or an abandoned one. as of fetch GitHub
Latest published version 0.1.14 Latest version string the maintainer published to the registry. as of fetch Model Context Protocol
Registry record last updated 2026-07-10 When the registry record was last updated by its maintainer. point in time Model Context Protocol
License Apache-2.0 Licence GitHub detected in the repository. Detection can be wrong; the LICENSE file is authoritative. as of fetch GitHub
First listed in the MCP Registry 2026-07-10 Date this server was first published to the official MCP Registry. Not a usage or quality measure. point in time Model Context Protocol
repository status active The repository exists on GitHub and is not archived. This says nothing about how recently it was worked on. as of fetch GitHub
mcp tools declared 6 tools Number of functions the server itself declared when asked to list them. This is what the server offers an agent, not a measure of how well any of them work. as of probe socrata.caseyjhand.com
mcp endpoint status ok The server listed 6 functions when asked. as of probe socrata.caseyjhand.com

Where to get it

Related, by what their authors tagged them

  • io.github.cyanheads/cdc-health-mcp-server — last commit 2026-07-11, shares cyanheads, socrata
    Search and query CDC public health data — mortality, vaccinations, surveillance, behavioral risk.
  • io.github.cyanheads/census-mcp-server — last commit 2026-07-31, shares bun, government-data, open-data
    Query U.S. Census Bureau data, variables, and geography via MCP.
  • io.github.cyanheads/treasury-fiscaldata-mcp-server — last commit 2026-07-30, shares bun, government-data
    MCP server for US Treasury Fiscal Data — debt, interest rates, exchange rates, and spending.
  • ai.smithery/alphago2580-naramarketmcp — last commit 2026-02-09, shares government-data, open-data
    Access Korea’s G2B procurement and Nara Market data for bid notices, awards, contracts, statistics…
  • io.github.aborruso/ckan-mcp-server — last commit 2026-08-06, shares government-data, open-data
    MCP server for interacting with CKAN open data portals
  • Agentic House Search — last commit 2026-08-06, shares government-data, open-data
    UK neighbourhood research from government open data: postcode reports, comparisons, 45 datasets.
  • LiveDataLink — last commit 2026-07-30, shares government-data, open-data
    One key for 284 tools across 59 US public-data domains. Resale-safe government and open data.
  • ihalent — last commit 2026-08-04, shares government-data, open-data
    Turkish public-tender (EKAP) award intelligence: firm histories, discounts, competition, red flags
  • io.github.civdotiq/civiq — last commit 2026-08-06, shares government-data
    U.S. civic data for AI agents: reps, votes, bills, finance, lobbying, cited gov sources. 47 tools.
  • Government Contracts MCP — last commit 2026-07-16, shares government-data
    Government contract search and federal procurement data: SAM.gov opportunities + USASpending awards.

These share tags the maintainers applied themselves, such as cyanheads, socrata, bun, government-data. Common tags like "mcp" or "ai" are ignored for this: agreeing with six hundred other projects is not a similarity.

This is not a recommendation and not a test result. It is a map of what the authors said their work is about.

Also from cyanheads

How the author describes it

Topics the maintainer set on GitHub: ai, bun, civic-data, cyanheads, government-data, mcp, mcp-server, model-context-protocol, open-data, socrata, soda-api, typescript.

This record as data

Every field on this page, with its source and observation date, is in the catalog JSON. Fetch the whole kind at once instead of parsing this HTML.

GET /api/v1/entries/mcp_server.json

Sources

  1. cyanheads/socrata-mcp-server on GitHub — GitHub, observed , trust tier 3.
  2. Official MCP Registry — Model Context Protocol, observed , trust tier 1.
  3. Tools declared by the MCP server at https://socrata.caseyjhand.com/mcp — socrata.caseyjhand.com, observed , trust tier 4.