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 an AWS App Runner configuration file to the repository.
Updated capital project URLs to a simplified format and fixed broken links, empty data returns, and missing MCP client imports. Added an MCP Logs viewer to the newsletter UI, improved log parsing, and implemented constraints to prevent the AI from hallucinating contract and solicitation IDs.
Added a new /p/{prjId} API route to support simplified, shorter URLs for capital projects. This update allows users to access specific project data more directly.
Added the databook_newsletter repository as a submodule. Created a standalone newsletter application that utilizes the Model Context Protocol (MCP) to fetch and integrate data.
Added a new MCP tool for tracking capital project milestones using the actual milestones table and included ready-to-use Databook URLs in MCP tools. Updated the newsletter template to fix broken links and revised the quick links to feature four preferred destinations.
Launched an AI-driven newsletter generation system with a management dashboard, prompt editor, and MCP tool access. Added a "Mayor's Weekly Briefing" section, enhanced capital project milestones, and implemented a link validation and auto-fix feature. Upgraded the project to Python 3.11 and refined the link requirements documentation.