Skip to main content
Glama
ASHITA2005

BrewBoard CRM MCP Server

by ASHITA2005

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

Related MCP server: mcp-postgres-query

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

F
license - not found
-
quality - not tested
B
maintenance

Maintenance

Maintainers
Response time
Release cycle
Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/ASHITA2005/crm_mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server