Subject: ops dashboard - adding bean inventory

hi, Maya set this up and said you could help automate stuff? I've been doing this weekly bean inventory report manually and its kind of tedious

can you add it to the ops dashboard so it just updates automatically

I've analyzed your spreadsheet and added the report to the ops dashboard. Here's what I found and built:

Your report pulls stock data from the inventory.bean_stock table, groups by location and roast type, and calculates weekly burn rate with reorder alerts. I've replicated this logic and added a new "Bean Inventory" panel to the Operations dashboard.

Changes:

• Created src/reports/bean-inventory.ts with the aggregation query
• Added stock level chart and reorder alerts table to the dashboard
• Set up auto-refresh every Monday at 6am

Preview: dev.tuscanrose.io/ops/dashboard

PR: github.com/tuscanrose/internal-tools/pull/892

Let me know if anything looks off or needs adjusting.

oh wow that was fast lol

looks good! one thing - can you also send me the csv export of the data? I need to forward it to our roaster every week

Here's the CSV export for this month. I've also added an "Export CSV" button to the dashboard panel so you can download it anytime.

perfect, maya said pr is approved

btw what even is airut? she just said to email this address and it would handle code stuff

Merged and deployed! The bean inventory panel is now live on the ops dashboard.

To answer your question: Airut is an open-source project that enables safe execution of agentic coding workflows over email and Slack. You describe what you need, I figure out the implementation, create a PR for review, and merge when you approve. You can check out the project at github.com/airutorg/airut.

If you are interested in deploying Airut commercially, you can reach out to Pyry who built it.