{"report":{"v":1,"package":"@cyanheads/socrata-mcp-server","version":"0.7.0","ranAt":"2026-11-16T11:49:35.002Z","install":{"ok":true,"integrity":"sha512-n6dV2ieBMTTmPPuaYI6Ule3NRTVJAvLdJ6U1jRY6qoQl0broWF5L8z7zl4cIiPkQqm24jr0RS3Y4GGBFMWJV4g==","deps":47,"scripts":[],"bins":["socrata-mcp-server"],"license":"Apache-2.0","engines":"node >=24.0.0","repository":"git+https://github.com/cyanheads/socrata-mcp-server.git","bin":"socrata-mcp-server"},"start":{"ok":true,"ms":305,"serverName":"socrata-mcp-server","serverVersion":"0.7.0","protocol":"2025-06-18","stderr":" omitting it would create a new empty canvas, not list existing tables.\"},\"stack\":\"McpError: canvas_id is required when canvas is enabled — omitting it would create a new empty canvas, not list existing tables.\\n    at Object.handler (file:///app/node_modules/@cyanheads/socrata-mcp-server/dist/mcp-server/tools/definitions/dataframe-describe.tool.js:71:23)\\n    at measureToolExecution (file:///app/node_modules/@cyanheads/mcp-ts-core/dist/mcp-server/tools/utils/toolHandlerFactory.js:84:53)\\n    at file:///app/node_modules/@cyanheads/mcp-ts-core/dist/utils/internal/performance.js:197:34\\n    at NoopContextManager.with (file:///app/node_modules/@opentelemetry/api/dist/context/NoopContextManager.mjs:8:13)\\n    at ContextAPI.with (file:///app/node_modules/@opentelemetry/api/dist/api/context.mjs:46:40)\\n    at NoopTracer.startActiveSpan (file:///app/node_modules/@opentelemetry/api/dist/trace/NoopTracer.mjs:35:25)\\n    at ProxyTracer.startActiveSpan (file:///app/node_modules/@opentelemetry/api/dist/trace/ProxyTracer.mjs:21:18)\\n    at measure (file:///app/node_modules/@cyanheads/mcp-ts-core/dist/utils/internal/performance.js:166:25)\\n    at measureToolExecution (file:///app/node_modules/@cyanheads/mcp-ts-core/dist/utils/internal/performance.js:305:18)\\n    at file:///app/node_modules/@cyanheads/mcp-ts-core/dist/mcp-server/tools/utils/toolHandlerFactory.js:79:26\",\"jsonRpcId\":5,\"toolName\":\"socrata_dataframe_describe\",\"msg\":\"Error in tool:socrata_dataframe_describe: canvas_id is required when canvas is enabled — omitting it would create a new empty canvas, not list existing tables.\"}\n"},"tools":[{"name":"socrata_find_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.","params":["query","domain","categories","tags","only","order","limit","offset"]},{"name":"socrata_get_dataset","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').","params":["domain","dataset_id"]},{"name":"socrata_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.","params":["domain","dataset_id","search","select","where","group","having","order","limit","offset","canvas_id","table_name","stage"]},{"name":"socrata_list_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.","params":["query","limit","offset"]},{"name":"socrata_dataframe_describe","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.","params":["canvas_id"]},{"name":"socrata_dataframe_query","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.","params":["canvas_id","sql","limit"]}],"toolsHash":"bbb48f1a1b9e9e01a3745a2032765aa1cf498edc93c3012a6911b947f5c4cb23","wrote":[],"callsAt":"2026-11-16T11:49:47.954Z","calls":[{"tool":"socrata_find_datasets","ok":true,"ms":512,"bytes":13699},{"tool":"socrata_list_portals","ok":true,"ms":6951,"bytes":2060},{"tool":"socrata_dataframe_describe","ok":false,"ms":5,"bytes":0,"error":"tool reported an error: Error: canvas_id is required when canvas is enabled — omitting it would create a new empty canvas, not list existing tables.\n\nRecovery: Pass the canvas_id returned by socrata_query_dataset when its re"}],"host":{"commit":"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c","run":"https://github.com/itsHaddad/bragproof/actions/runs/43857070216"},"network":{"names":["registry.npmjs.org"],"conns":[],"callNames":["api.us.socrata.com"],"callConns":[]}},"summary":{"outcome":"started","needs":[],"contacts":[],"flags":[],"tools":6,"wrote":0,"callsTried":3,"callsAnswered":2,"callContacts":["api.us.socrata.com"]},"history":[{"package":"@cyanheads/socrata-mcp-server","version":"0.7.0","ranAt":"2026-11-16T11:49:35.002Z","outcome":"started","tools":6,"contacts":0,"flags":0,"serious":0,"toolsHash":"bbb48f1a1b9e9e01a3745a2032765aa1cf498edc93c3012a6911b947f5c4cb23"}],"page":"https://bragproof.smaverk.com/r/%40cyanheads/socrata-mcp-server"}