Fresh WBR MCP

Dynamic Weekly Business Review (WBR) dashboard generator, deployed as an MCP server. Queries AWS Athena, auto-discovers metrics across multiple reporting lenses, and renders a full-featured interactive HTML dashboard.

Features

• Multi-lens dashboard — Overall, Channel, City, GL, Fresh Express views in one report
• Auto-discovering — new metrics and segments appear automatically from data
• Interactive — collapsible sections, lens filtering, metric focus, theme switcher
• Real per-segment data — each city/channel/GL shows actual values from Athena
• Tamper protection — DOM mutation observer prevents client-side value editing
• Key Movements — auto-generated insights from data
• Top/Bottom Movers — highlights best and worst performing metrics
• No credentials in code — uses ambient AWS credentials via CLI

Quick Start (uvx)

export WBR_ATHENA_DATABASE=your_database
export WBR_ATHENA_VIEW=your_wbr_view
export WBR_ATHENA_OUTPUT_LOCATION=s3://your-athena-results-bucket/
export WBR_ATHENA_REGION=us-east-1

uvx fresh-wbr-mcp

MCP Configuration

{
  "mcpServers": {
    "fresh-wbr": {
      "command": "uvx",
      "args": ["fresh-wbr-mcp"],
      "env": {
        "WBR_ATHENA_DATABASE": "your_database",
        "WBR_ATHENA_VIEW": "your_wbr_view",
        "WBR_ATHENA_OUTPUT_LOCATION": "s3://your-bucket/athena-results/",
        "WBR_ATHENA_REGION": "us-east-1"
      }
    }
  }
}

Tools

generate_wbr

Generate the full leadership WBR dashboard.

generate_wbr()
generate_wbr(output_path="my_report.html")

Dashboard Features

Expected Data Schema

Your Athena view must have these columns:

Environment Variables

Project Structure

fresh_wbr_mcp/
├── __init__.py
├── __main__.py          # MCP server entry point
├── data_fetcher.py      # Athena query builder
├── processor.py         # Data → dashboard format
├── renderer.py          # Injects data into template
├── server.py            # Core generation logic
└── templates/
    └── wbr_leadership.html  # Full dashboard template

License

MIT

Credits

Created by @mondalbh • Owned by CoBRA BIE Team