Slack bot for managers (engineering/project) for querying project tracking system

 Slack bot for managers (engineering/project) for querying project tracking system

Deployed a production Slack bot that gives engineering managers instant visibility into sprint work items across teams. Instead of manually querying our project tracking system or waiting for reports, managers can now get on-demand status updates directly in Slack.

The Problem: Engineering/Project managers need quick answers about team progress during sprints—which work items are in progress, what's blocked, who's working on what—but querying our internal systems directly is cumbersome and not integrated into daily workflows.

The Solution: A Slack bot that accepts natural language queries like /build-report <release #> managers=<comma separate> or /build-report <release #> teams=<comma separated> and returns formatted reports with work item
status, priorities, and assignees.

Tech Stack:
- Backend: Python + FastAPI for webhook handling
- Slack Integration: Slack Bolt SDK with Block Kit for rich formatting
- Data Layer: Salesforce CLI + SOQL queries for work item data
- Deployment: Heroku with enterprise-grade secrets management
- Architecture: REST API design with automatic token refresh workflow
- My coding boss/partner - Claude CLI

Key Features:
✅ Manager-based queries (auto-resolves "me" to Slack user email)
✅ Team-based queries with flexible filtering
✅ Status filtering (active/all) for relevant work items
✅ Channel posting or ephemeral DMs
✅ Graceful token expiration handling with user-friendly error messages

I write to highlight how easy it is now with Claude CLI (or AI tools) to build/deploy. 

Cannot paste the entire screenshot (due to privacy issues) but here goes how the summary looks like