Databook
activeopen governmentAn award-winning transparency tool that combines over 50 official NYC open datasets — agencies, people, jobs, capital projects, schools, districts and procurement — into one searchable picture of how city government works.
Added a new admin page at /admin/datatables to display database table statistics.
Added a /table-stats API endpoint with accurate row counts and source URLs. Introduced a newsletter generator with link validation, template fixes, and new dependencies. Expanded the MCP tools to include school search, statistics, and datasets for jobs, payroll, facilities, budget, contracts, and solicitations.
Added a new admin index page with a menubar header across all admin views. Introduced an admin datatables page featuring DataTables.js, configured to display all rows by default, use reqOCE for full responses, and include a Source column showing full URLs.
Added the Model Context Protocol (MCP) service and chatbot, with documentation for the remote endpoints.
This update integrates Model Context Protocol (MCP) logging, session tracking, and Google Sheets log exports. It mounts MCP at /mcp, fixes capital projects queries, adds an async import for the CROL dataset, and makes MCP links clickable in rate limit messages.
Added a new Model Context Protocol (MCP) documentation page at /mcp, including native Claude Desktop connector instructions. Additionally, integrated a chat widget featuring a squirrel icon into the main layout.