{"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\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OmJiNmI4ZjViNGM3YTliZjlhMWE4YjhiMjg2YmI2YWQyMjljNmQ1MzdiODkyNDcwZWY4NmY4N2VmNTAxZWQ2ZjYiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTY2MSIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgzMDEwMywiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4Mjk4MDMsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiNGFhYTc4MGMtMTg2OC00NWE1LWFlY2ItNmNhNjc4ZDY2ZWUwIiwibmJmIjoxNzk0ODI5NTAzLCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.KPx0ClxSntcLg5yHs6lmFcktnDims7IZJqPcQ5Gyay8rnisZWMv-6Dxp4TT015Jyn2jY1yvLOLeHUiBrp57b3HPGPQkjjlffDmoRloZQuttCwGcYeTcVxqdE_ml0sm8YAs6oc2c_DBUVVvy5_pfAlo8ndWd4OC_VxlDIMlvlDpQNjQ_XrZQrqHYWox51oHraSveHKCYc5HYMm8TfoERj7bk75OahiOQfpGK2U1a4T13IDJwjTJi7nKtzMayCt9ZiNoICis-JDINxzir4uIoFsyQKiKHBOoHtdKPzuJ58OF-V92Q8qElqyPiVCzS1AMmzlwntjl98GYsodrCieobXug"}