{"data":{"name":"io.github.cyanheads/socrata-mcp-server","title":null,"description":"Search and query government open-data portals (Socrata SODA API).","version":"0.3.0","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/socrata-mcp-server","remotes":[{"url":"https://socrata.caseyjhand.com/mcp","type":"streamable-http"}],"packages":[{"version":"0.3.0","identifier":"@cyanheads/socrata-mcp-server","runtimeHint":"stdio","registryType":"npm","runtimeArguments":null,"environmentVariables":null},{"version":"0.3.0","identifier":"@cyanheads/socrata-mcp-server","runtimeHint":"streamable-http","registryType":"npm","runtimeArguments":null,"environmentVariables":null}],"status":"active","isLatest":true,"publishedAt":"2026-10-04T05:59:58.745Z","updatedAt":"2026-10-04T05:59:58.745Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":null,"source":"official-registry","sourceId":"io.github.cyanheads/socrata-mcp-server","updatedAt":"2026-10-04T05:59:58.745Z","confidence":100,"websiteUrl":null,"description":"Search and query government open-data portals (Socrata SODA API).","verification":"official","repositoryUrl":"https://github.com/cyanheads/socrata-mcp-server"}],"toolIndex":{"tools":[{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_dataframe_describe","title":"Describe DataCanvas Tables","description":"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. Meaningful when the server has a DataCanvas. Use after socrata_query_dataset spills a large result set to canvas.","inputSchema":{"type":"object","properties":{"canvas_id":{"description":"Canvas ID returned by socrata_query_dataset when a large result spills to canvas. Required in practice when canvas is enabled — canvases cannot be enumerated, so omitting it fails with canvas_id_required instead of listing tables.","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"54128cc490d8eed383572c90a6331bb2178564b89c68bbb943c9dee26727575f","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_dataframe_query","title":"Query DataCanvas Table","description":"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). Works when the server has a DataCanvas. Use socrata_dataframe_describe to see registered tables and their schemas.","inputSchema":{"type":"object","properties":{"canvas_id":{"type":"string","pattern":"^[A-Za-z0-9_-]{10}$","description":"Canvas ID returned from socrata_query_dataset or socrata_dataframe_describe."},"sql":{"type":"string","description":"SELECT-only SQL to run against registered canvas tables. DDL, DML, file paths, file-reading functions, and any name spelled like a DuckDB metadata view (pg_type, duckdb_tables, sqlite_master), even as a column alias or CTE name, are rejected. Use table names from socrata_dataframe_describe."},"limit":{"default":1000,"maximum":50000,"description":"Max rows to return (1–50,000). One call returns at most 10,000 rows: a larger limit is served as 10,000, with a notice naming how to page through the rest when more rows match. Default 1000.","type":"integer","minimum":1}},"required":["canvas_id","sql"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"5c10c5808fb81453694aa3c8085eb88e36e8c0190ba4dc1feb62998ee71c9127","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_find_datasets","title":"Find Socrata Datasets","description":"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.","inputSchema":{"type":"object","properties":{"query":{"description":"Full-text search across dataset names and descriptions. Omit to browse without filtering.","type":"string"},"domain":{"description":"Scope search to a single portal by bare hostname (e.g. data.seattle.gov, data.cityofnewyork.us); URL forms like https://data.seattle.gov/ are accepted and reduced to the host. Omit to search all portals. Required with categories or tags.","type":"string"},"categories":{"description":"Filter by the portal's own categories (e.g. [\"Public Safety\", \"Transportation\"]). Requires domain: each portal assigns its own categories. Multiple values are ORed: a dataset in any listed category matches. Across portals, search with query instead.","type":"array","items":{"type":"string"}},"tags":{"description":"Filter by the portal's own tags (e.g. [\"covid19\", \"permits\"]). Requires domain: each portal assigns its own tags. Multiple values are ORed: a dataset carrying any listed tag matches. Across portals, search with query instead.","type":"array","items":{"type":"string"}},"only":{"description":"Filter by asset type. Omit to include all types. Usually \"datasets\" is what you want.","type":"string","enum":["datasets","maps","files","calendars","stories"]},"order":{"description":"Sort order. Defaults to relevance. Use updated_at to surface recently-refreshed datasets.","type":"string","enum":["relevance","page_views_total","created_at","updated_at"]},"limit":{"default":10,"maximum":10000,"description":"Number of results to return (1–10,000). One call returns at most 100 results: a larger limit is served as 100, with a notice naming the offset that continues. Default 10.","type":"integer","minimum":1},"offset":{"default":0,"description":"Pagination offset. Default 0. Must be below 10,000: the Discovery catalog serves only the first 10,000 matches of a search.","type":"integer","minimum":0,"maximum":9007199254740991}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true},"definitionHash":"6578ce9438a33cbff3b7fc06eceb34cc9aaec07b380cab1fee2b3d035d821979","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_get_dataset","title":"Get Dataset Schema","description":"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').","inputSchema":{"type":"object","properties":{"domain":{"description":"Portal the dataset lives on, as a bare hostname (e.g. data.cityofnewyork.us); URL forms like https://data.cityofnewyork.us/ are accepted and reduced to the host. Pass the domain from the same socrata_find_datasets result as dataset_id. Defaults to SOCRATA_DEFAULT_DOMAIN or data.seattle.gov, which is wrong for another portal’s ID.","type":"string"},"dataset_id":{"type":"string","pattern":"^[A-Za-z0-9]{4}-[A-Za-z0-9]{4}$","description":"Four-by-four dataset ID matching pattern like kzjm-xkqj. IDs are portal-scoped: take it from socrata_find_datasets together with that result’s domain."}},"required":["dataset_id"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true},"definitionHash":"57e9a021f3af53967b2901075799c2875ec2667c39cf61d9f46e789be5498995","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_list_portals","title":"List Socrata Portals","description":"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.","inputSchema":{"type":"object","properties":{"query":{"description":"Keyword to filter portal names or organization names (case-insensitive substring match). Omit to list all portals.","type":"string"},"limit":{"default":50,"description":"Max portals to return (1–200). Default 50.","type":"integer","minimum":1,"maximum":200},"offset":{"default":0,"description":"Pagination offset. Default 0.","type":"integer","minimum":0,"maximum":9007199254740991}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true},"definitionHash":"6b8516456250cddf15c191bd3a62179d1cc02d9f88e2be0bfffae4486c60ee85","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/socrata-mcp-server","endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","name":"socrata_query_dataset","title":"Query Dataset","description":"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 the server has a canvas and more rows match past a full page, 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. Pass stage false to return the page alone, without staging.","inputSchema":{"type":"object","properties":{"domain":{"description":"Portal the dataset lives on, as a bare hostname (e.g. data.cityofnewyork.us); URL forms like https://data.cityofnewyork.us/ are accepted and reduced to the host. Pass the domain from the same socrata_find_datasets result as dataset_id. Defaults to SOCRATA_DEFAULT_DOMAIN or data.seattle.gov, which is wrong for another portal’s ID.","type":"string"},"dataset_id":{"type":"string","pattern":"^[A-Za-z0-9]{4}-[A-Za-z0-9]{4}$","description":"Four-by-four dataset ID (e.g. kzjm-xkqj). IDs are portal-scoped: take it from socrata_find_datasets together with that result’s domain."},"search":{"description":"Full-text search across all text columns ($q). For field-specific filtering, use where instead.","type":"string"},"select":{"description":"SoQL SELECT clause — API field names (field_name from socrata_get_dataset, not display labels), aliases, aggregates: \"state, sum(deaths) as total_deaths\". Omit for all columns.","type":"string"},"where":{"description":"SoQL WHERE clause over API field names (field_name from socrata_get_dataset). Check column data_type there first — Number columns: year=2023, Text columns: year='2023'; an unquoted text value is read as a column name. Operators: =, !=, >, <, LIKE, IN(...), BETWEEN, IS NULL, starts_with(), contains(), AND, OR, NOT.","type":"string"},"group":{"description":"SoQL GROUP BY clause over API field names (field_name from socrata_get_dataset). Requires an aggregate function in select.","type":"string"},"having":{"description":"SoQL HAVING clause. Filters on aggregated results, e.g. count > 100.","type":"string"},"order":{"description":"SoQL ORDER BY clause over API field names or select aliases, e.g. \"total_deaths DESC\" or \"date ASC\".","type":"string"},"limit":{"default":100,"maximum":50000,"description":"Max rows to return (1–50,000). One call returns at most 5,000 rows: a larger limit is served as 5,000, with a notice naming the offset that continues when more rows match. Default 100. Use with offset for pagination. When the server has a canvas and more rows match past a full page, up to 50,000 matching rows are staged on it whatever the limit — pass a small limit (e.g. 10) to stage a large match without a large inline page, or stage false to return the page without staging.","type":"integer","minimum":1},"offset":{"default":0,"description":"Row offset for pagination. Default 0.","type":"integer","minimum":0,"maximum":9007199254740991},"canvas_id":{"description":"Optional 10-char DataCanvas token from a prior socrata_query_dataset or socrata_dataframe_describe call. Omit on first call to mint a fresh canvas. Large result sets spill here automatically unless stage is false.","type":"string","pattern":"^[A-Za-z0-9_-]{10}$"},"table_name":{"description":"Name for the canvas table a spill stages: letters, digits, and underscores, starting with a letter or underscore, 63 characters at most; lowercased, and not a SQL keyword such as select or order. Defaults to a name derived from dataset_id (ijzp_q8t2_rows). A spill under a name the canvas already holds replaces that table, so give each extract its own name, with the same canvas_id, to keep several on one canvas.","type":"string","pattern":"^[A-Za-z_][A-Za-z0-9_]{0,62}$"},"stage":{"default":true,"description":"Stage the matching rows on a canvas when more rows match past this page and the server has a canvas. Default true. Pass false to return the page alone, skipping the staging request; canvas_id and table_name then go unused.","type":"boolean"}},"required":["dataset_id"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":true},"definitionHash":"194d33abb52b48910781835f4c74295f21ec8110294f4b0c474eec67d752ee71","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T08:46:18.179Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"16893f3f0fd14461721690ad52170d735e578bf057bf5fd415da4c28ad36b8af","protocol":"streamable-http","status":"indexed","toolCount":6,"observedAt":"2026-11-19T08:46:18.179Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"io.github.cyanheads/socrata-mcp-server":{"url":"https://socrata.caseyjhand.com/mcp"}}},"Cursor":{"mcpServers":{"io.github.cyanheads/socrata-mcp-server":{"url":"https://socrata.caseyjhand.com/mcp"}}},"VS Code":{"servers":{"io.github.cyanheads/socrata-mcp-server":{"type":"http","url":"https://socrata.caseyjhand.com/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://socrata.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/socrata-mcp-server","registryType":"npm","version":"0.3.0"},{"protocol":"mcp","package":"@cyanheads/socrata-mcp-server","registryType":"npm","version":"0.3.0"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:io.github.cyanheads%2Fsocrata-mcp-server","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/io.github.cyanheads%2Fsocrata-mcp-server","name":"io.github.cyanheads/socrata-mcp-server","description":"Search and query government open-data portals (Socrata SODA API).","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://socrata.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/socrata-mcp-server","registryType":"npm","version":"0.3.0"},{"protocol":"mcp","package":"@cyanheads/socrata-mcp-server","registryType":"npm","version":"0.3.0"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/socrata-mcp-server","version":"0.3.0"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"io.github.cyanheads/socrata-mcp-server","status":"online","lastCheckedAt":"2026-11-20T04:16:52.672Z","lastSuccessfulCheck":"2026-11-20T04:16:52.672Z","latencyMs":265,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T04:16:52.672Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T04:16:52.672Z"},"security":null,"timestamps":{"createdAt":"2026-10-04T05:59:58.745Z","updatedAt":"2026-10-04T05:59:58.745Z","observedAt":"2026-11-20T04:16:52.672Z"},"compatibility":{"serverVersion":"0.3.0","protocolVersions":[{"protocol":"mcp","version":null}]}}}}