Search / io.github.cyanheads/socrata-mcp-server
protogridR0· no sign-inSearch and query government open-data portals (Socrata SODA API).
v0.3.0 · active · repository · descriptor JSON · versions
{
"mcpServers": {
"socrata-mcp-server": {
"type": "http",
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}claude mcp add --transport http socrata-mcp-server https://socrata.caseyjhand.com/mcp[mcp_servers.socrata-mcp-server]
url = "https://socrata.caseyjhand.com/mcp"
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"socrata-mcp-server": {
"type": "remote",
"url": "https://socrata.caseyjhand.com/mcp",
"enabled": true
}
}
}{
"mcpServers": {
"socrata-mcp-server": {
"type": "http",
"url": "https://socrata.caseyjhand.com/mcp"
}
},
"deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=socrata-mcp-server&config=eyJ0eXBlIjoiaHR0cCIsInVybCI6Imh0dHBzOi8vc29jcmF0YS5jYXNleWpoYW5kLmNvbS9tY3AifQ%3D%3D"
}{
"servers": {
"socrata-mcp-server": {
"type": "http",
"url": "https://socrata.caseyjhand.com/mcp"
}
}
}{
"mcpServers": {
"socrata-mcp-server": {
"httpUrl": "https://socrata.caseyjhand.com/mcp"
}
}
}extensions:
"socrata-mcp-server":
enabled: true
name: "socrata-mcp-server"
type: streamable_http
uri: "https://socrata.caseyjhand.com/mcp"
timeout: 300
protocol.modernsupports 2026-07-28 (server/discover)protocol.statelessanswers without a sessionprotocol.transportstreamable HTTPprotocol.list_ttltools/list declares ttlMs 0, so clients re-fetch it on every useauth.prm, auth.as_metadata, auth.cimdno remote uses OAuthauth.secret_in_urlno templated URLtools.descriptionsevery tool has a descriptiontools.description_lengthdescriptions are concisetools.schemasevery tool has an object input schematools.annotations6 of 6 tools declare readOnlyHint or destructiveHinttools.directory_hintsno tool declares all four of readOnlyHint, destructiveHint, idempotentHint and openWorldHint; missing: socrata_dataframe_query (destructiveHint, openWorldHint); socrata_find_datasets (destructiveHint); socrata_get_dataset (destructiveHint, openWorldHint); …tools.token_costabout 2,418 tokens to load every tooltools.api_dumptools are not a one-to-one API dumpstability.changesno tool changes in 30 daysstability.rug_pullno tool changed its meaning under the same namedeps.known_vulns, deps.mcp_sdk_version, deps.resolvabledeps.dev does not know @cyanheads/[email protected], @cyanheads/[email protected]No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.
Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.
+repository +namespace-matches-repo +reachable +uptime-100% +updated-15d-ago
Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.
@cyanheads/[email protected] npmthis version is not known to the dependency resolver
@cyanheads/[email protected] npmthis version is not known to the dependency resolver
Dependency graphs from deps.dev; advisories from OSV.dev, including the GitHub Advisory Database and the PyPI Advisory Database; all CC BY 4.0. The graph is what a clean install of this version resolves today; nothing was installed or run. How it is checked.
| remote | auth | reachable | uptime 30d | p50 | protocol | last ok |
|---|---|---|---|---|---|---|
https://socrata.caseyjhand.com/mcp streamable-http | none | yes | 100% | 179 ms | 2026-07-28 | 2026-10-19 |
| package | registry | version | runtime | secrets |
|---|---|---|---|---|
@cyanheads/socrata-mcp-server | npm | 0.3.0 | npx | |
@cyanheads/socrata-mcp-server | npm | 0.3.0 | npx |
socrata_dataframe_describeread-only | 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_queryread-only | 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 — compare times with CAST(date AS TIMESTAMP). Only works when CANVAS_PROVIDER_TYPE=duckdb is set. Use socrata_dataframe_describe to see registered tables and their schemas. |
socrata_find_datasetsread-only | 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 column schema before writing queries — column_names carry no type information. |
socrata_get_datasetread-only | 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'). |
socrata_list_portalsread-only | 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 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_datasetread-only | 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 name (field_name from socrata_get_dataset, e.g. cuisine_description), never the display label. All SODA 2.1 row values are strings even for numeric columns — check data_type 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 limit, up to 50,000 matching rows spill to a DataCanvas table whatever the limit: list its columns with socrata_dataframe_describe, then run SQL with socrata_dataframe_query. |
Schemas: list_tools.
And 136 more from this publisher.
{
"name": "io.github.cyanheads/socrata-mcp-server",
"$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
"remotes": [
{
"url": "https://socrata.caseyjhand.com/mcp",
"type": "streamable-http"
}
],
"version": "0.3.0",
"packages": [
{
"version": "0.3.0",
"transport": {
"type": "stdio"
},
"identifier": "@cyanheads/socrata-mcp-server",
"runtimeHint": "npx",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"environmentVariables": [
{
"name": "SOCRATA_APP_TOKEN",
"format": "string",
"description": "Socrata app token (X-App-Token header). Without a token, requests share a throttled pool per source IP. Free to register at any Socrata portal."
},
{
"name": "SOCRATA_DEFAULT_DOMAIN",
"format": "string",
"default": "data.seattle.gov",
"description": "Default portal domain when domain is omitted from tool calls (e.g. data.seattle.gov, data.cityofnewyork.us)."
},
{
"name": "SOCRATA_DATAFRAME_DROP_ENABLED",
"format": "boolean",
"default": "false",
"description": "Set to true to enable socrata_dataframe_drop, which deletes staged DataCanvas data. Off, the tool is listed as disabled."
},
{
"name": "MCP_LOG_LEVEL",
"format": "string",
"default": "info",
"description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn')."
}
]
},
{
"version": "0.3.0",
"transport": {
"url": "http://localhost:3010/mcp",
"type": "streamable-http"
},
"identifier": "@cyanheads/socrata-mcp-server",
"runtimeHint": "npx",
"registryType": "npm",
"registryBaseUrl": "https://registry.npmjs.org",
"environmentVariables": [
{
"name": "MCP_TRANSPORT_TYPE",
"value": "http",
"format": "string",
"description": "Selects the HTTP transport."
},
{
"name": "SOCRATA_APP_TOKEN",
"format": "string",
"description": "Socrata app token (X-App-Token header). Without a token, requests share a throttled pool per source IP. Free to register at any Socrata portal."
},
{
"name": "SOCRATA_DEFAULT_DOMAIN",
"format": "string",
"default": "data.seattle.gov",
"description": "Default portal domain when domain is omitted from tool calls (e.g. data.seattle.gov, data.cityofnewyork.us)."
},
{
"name": "SOCRATA_DATAFRAME_DROP_ENABLED",
"format": "boolean",
"default": "false",
"description": "Set to true to enable socrata_dataframe_drop, which deletes staged DataCanvas data. Off, the tool is listed as disabled."
},
{
"name": "MCP_HTTP_HOST",
"format": "string",
"default": "127.0.0.1",
"description": "The hostname for the HTTP server."
},
{
"name": "MCP_HTTP_PORT",
"format": "string",
"default": "3010",
"description": "The port to run the HTTP server on."
},
{
"name": "MCP_HTTP_ENDPOINT_PATH",
"format": "string",
"default": "/mcp",
"description": "The endpoint path for the MCP server."
},
{
"name": "MCP_AUTH_MODE",
"format": "string",
"default": "none",
"description": "Authentication mode to use: 'none', 'jwt', or 'oauth'."
},
{
"name": "MCP_LOG_LEVEL",
"format": "string",
"default": "info",
"description": "Sets the minimum log level for output (e.g., 'debug', 'info', 'warn')."
}
]
}
],
"repository": {
"url": "https://github.com/cyanheads/socrata-mcp-server",
"source": "github"
},
"description": "Search and query government open-data portals (Socrata SODA API)."
}