# brewboard-crm-mcp

CRM MCP server for BrewBoard café app. Connects Claude.ai to the BrewBoard
Supabase database for analytics and post-visit customer messaging.

## Setup

1. Clone this repo
2. `npm install`
3. Copy `.env.example` to `.env` and fill in values
4. Run the Supabase migration in `Section 4` of the implementation doc
5. `npm start`

## Tools exposed

| Tool | Type | Description |
|---|---|---|
| `get_revenue_summary` | READ | Total revenue, orders, AOV for a date range |
| `get_peak_hours` | READ | Order volume by hour of day |
| `get_orders_by_table` | READ | Orders and revenue per table number |
| `get_most_ordered_items` | READ | Top items by quantity sold |
| `get_busiest_days` | READ | Order count by day of week |
| `get_table_turnover` | READ | Avg session duration per table |
| `get_average_order_value` | READ | Daily AOV trend |
| `get_order_completion_time` | READ | Kitchen completion time stats |
| `send_revisit_message` | WRITE | Simulated post-visit message |

## Endpoints

- `GET /health` — health check (no auth)
- `GET /sse` — SSE connection for Gemini/MCP client (requires Bearer token)
- `POST /message?sessionId=X` — MCP tool call handler (requires Bearer token)

## Connect to Gemini / MCP Client

Configure your Gemini/MCP-compatible client with the following details:
- Name: `BrewBoard CRM`
- URL: `https://your-railway-url.up.railway.app/sse`
- Auth header: `Authorization: Bearer YOUR_MCP_API_KEY`