BrewBoard CRM Server

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