Weather‑Smart Merchandiser: Using Notion MCP + Claude to Turn DIY Sales & Weather Data into Layout Actions

This is a submission for the Notion MCP Challenge What I Built I built Weather‑Smart Merchandiser , a weather‑driven merchandising tool that analyses historical sales–weather data, forecasts demand by temperature bucket, and then generates store layout‑change suggestions for a DIY store. Under the hood, it’s a Python project exposed as an MCP server , so AI assistants (like Claude Desktop) can call high‑level tools such as layout_actions or top_categories instead of manually running scripts. The workflow is: the assistant looks at recent DIY sales and temperatures, classifies upcoming days as cold / mild / warm, and then proposes concrete layout moves (e.g., “move garden tools to front endcap for the warm weekend” or “highlight insulation at the entrance for a cold spell”). On top of that, I use a Notion workspace as the control center : A “Sales & Weather (Daily)” database holds the input data. A “DIY Categories & Layout” database describes where each category currently lives in the s