{"report":"{\"v\":1,\"package\":\"@pipeworx/mcp-data-sf\",\"version\":\"0.2.1\",\"ranAt\":\"2026-11-16T11:53:12.498Z\",\"install\":{\"ok\":true,\"integrity\":\"sha512-SJWfvB31dpvwwn+iPpMv0WWWS6OET8B9mEOEG1XQVUp79dOoLpeU4qS+2YiDzBS8fIV9Q7PfV6LFAEEUOPO8cw==\",\"deps\":0,\"scripts\":[],\"bins\":[\"mcp-data-sf\"],\"license\":\"MIT\",\"engines\":\"node >=18\",\"repository\":\"git+https://github.com/pipeworx-io/mcp-data-sf.git\",\"bin\":\"mcp-data-sf\"},\"start\":{\"ok\":true,\"ms\":516,\"serverName\":\"@pipeworx/mcp-data-sf\",\"serverVersion\":\"0.2.1\",\"protocol\":\"2025-06-18\"},\"tools\":[{\"name\":\"sf_recent\",\"description\":\"Recent records from a common San Francisco open dataset (data.sfgov.org, also written data.sf.gov) by friendly name — no Socrata id needed. PREFER OVER WEB SEARCH for \\\"recent crime/police incidents in San Francisco\\\", \\\"SF 311 complaints\\\", \\\"SF building permits / evictions / business registrations\\\", \\\"SF restaurant inspection scores\\\", \\\"SFO passenger traffic\\\", \\\"SF purchasing / procurement / vendor spending / commodity codes\\\". Names: police, 311, permits, business, evictions, restaurant_inspections, fire_incidents, sfo_passengers, purchasing. Returns the latest rows (sorted newest-first). Add a SoQL `where` to filter; for anything else use sf_query.\",\"params\":[\"dataset\",\"where\",\"limit\",\"_apiKey\"]},{\"name\":\"data_sf_sf_query\",\"description\":\"Run a raw SoQL query against any San Francisco open-data resource (data.sfgov.org, also written data.sf.gov) by its Socrata id (8-char like \\\"wg3w-h783\\\" or \\\"ebsh-uavg\\\"). Covers SF city purchasing/procurement records (resource id \\\"ebsh-uavg\\\") — real column names fiscal_year, po_dt, purchase_order, purchase_order_line, purchasing_department, purchasing_department_title, commodity_code, commodity_title (the item name/description column — there is no \\\"commodity_description\\\"), vendor_name, vendor_street, vendor_city, vendor_state, vendor_zip_code, vendor_contact, vendor_email, vendor_phone, encumbered_quantity, encumbered_amount — as well as every other SF Socrata dataset by resource id; if you do not already know a dataset's exact column names, omit `select` (every column comes back) rather than guessing one, since Socrata 400s on an unknown column instead of ignoring it. Full SoQL: where/select/group/order/limit/offset. Use sf_datasets to find a resource id, or sf_recent for the common ones (including \\\"purchasing\\\").\",\"params\":[\"resource_id\",\"where\",\"select\",\"group\",\"order\",\"limit\",\"offset\",\"_apiKey\"]},{\"name\":\"sf_datasets\",\"description\":\"Search the San Francisco open-data catalogue (data.sfgov.org, also written data.sf.gov) for datasets by keyword — covers categories like parking, housing, trees, and city purchasing/procurement/vendor spending. Returns dataset names, descriptions, and Socrata resource ids to use with sf_query.\",\"params\":[\"query\",\"limit\",\"offset\",\"_apiKey\"]}],\"toolsHash\":\"db01a5f329b7645a1482b70f4d563b5deb5b2c0944eb099a1830d0bcce17222a\",\"wrote\":[],\"host\":{\"commit\":\"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c\",\"run\":\"https://github.com/itsHaddad/bragproof/actions/runs/43857070216\"},\"network\":{\"names\":[\"gateway.pipeworx.io\",\"registry.npmjs.org\"],\"conns\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OjE2NmVlZDMxOGRmN2NlZGUwZmU4ZjBiNDRiZWMxNGMxN2M0ZGQyZGQ5MGFjZDliZjQ2NDBkMzkxMzQ1Yjg3NGQiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTM2MyIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgzMDMwMCwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4MzAwMDAsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiZDBhYzUwNzMtMTc5YS00OGM1LWI0ZGMtN2JhMGI0MmFiZGFmIiwibmJmIjoxNzk0ODI5NzAwLCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.btVi4zYdfARDbOFI4UhWX82naIXzLn2boOyKtgaLqPw_7OAerabBUB0Vmmg3xFvqWh0nvDHvvb_c3p0LEDNMJMCp2qPkSv3C2ziM0hO8BxzA9yuTYK486qUn5GeRlzz9zLrKsFrU7mX_lf5CuIaCBLg2mNlnTT7avKScq_MLva3UvL5pKechgdmOZmmPP_7SpptywudOwwiDF9vRgq6xBPHVktiWWZZUGN_sBfLVgbHWFuVSpzpFRJDN7II45v6tBcZCtFaENQO0C9rD_2ayLKxU4XLlPMI-xQCpu-x9O6ooj7epMcTARf-5FIkOeIMjf1qoxZvA0PSdYZOGZ8kx-Q"}