{"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":[]}},"summary":{"outcome":"started","needs":[],"contacts":["gateway.pipeworx.io"],"flags":[],"tools":3,"wrote":0,"callsTried":0,"callsAnswered":0,"callContacts":[]},"history":[{"package":"@pipeworx/mcp-data-sf","version":"0.2.1","ranAt":"2026-11-16T11:53:12.498Z","outcome":"started","tools":3,"contacts":1,"flags":0,"serious":0,"toolsHash":"db01a5f329b7645a1482b70f4d563b5deb5b2c0944eb099a1830d0bcce17222a"}],"page":"https://bragproof.smaverk.com/r/%40pipeworx/mcp-data-sf"}