A
licenseA
qualityD
maintenanceConnects Claude to any PostgreSQL database, enabling schema exploration, query execution, and performance analysis through natural conversation.
7
6 npm
1
MIT
BrewBoard CRM MCP Server
by ASHITA2005
Provides tools to access BrewBoard café analytics (revenue, peak hours, orders, etc.) and send simulated post-visit customer messages via the Supabase database.
Click on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@BrewBoard CRM MCP ServerShow me yesterday's revenue summary"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
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
Clone this repo
npm installCopy
.env.exampleto.envand fill in valuesRun the Supabase migration in
Section 4of the implementation docnpm start
Related MCP server: jotae-mcp
Tools exposed
Tool | Type | Description |
| READ | Total revenue, orders, AOV for a date range |
| READ | Order volume by hour of day |
| READ | Orders and revenue per table number |
| READ | Top items by quantity sold |
| READ | Order count by day of week |
| READ | Avg session duration per table |
| READ | Daily AOV trend |
| READ | Kitchen completion time stats |
| 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 CRMURL:
https://your-railway-url.up.railway.app/sseAuth header:
Authorization: Bearer YOUR_MCP_API_KEY
This server cannot be deployed
Maintenance
ActivityInactive
ResponsivenessNo issues
Related MCP Connectors
Talk to your live-events CRM (campaigns, analytics, paid ads, segments) in Claude and ChatGPT.
Connect Claude to Fathom meeting recordings, transcripts, and summaries
Connect Claude to your Intervals.icu watch data for fitness, workout review, and plan writing.
Connect Claude or any MCP client to Thread Otter, a GTM agent for founders. Free tools with no key: find_buyer_threads (give it a website URL and get recent Reddit threads where that product's buyers are asking for it, report in ~3 minutes), reddit_demand_board (weekly demand across 40 communities with thread receipts), and subreddit_rules (promotion posture for 2,000+ profiled subreddits). With an API key: read your buying-intent mentions across Reddit, X, LinkedIn, and Bluesky, check your pipeline, and propose posts and reply drafts in your voice. Propose-only by design: nothing sends without your approval flow. Keys at threadotter.com/connect.
Related MCP Servers
- AlicenseBqualityDmaintenanceConnects Claude to Jotae for creating events, configuring WhatsApp and email automations, and reading metrics through natural language.215 npmMIT
- AlicenseCqualityDmaintenanceEnables Claude to fully manage self-hosted Supabase instances, covering authentication, database, storage, edge functions, and more.423MIT
- AlicenseNot gradedqualityBmaintenanceEnables natural language queries, CRUD operations, and analytics on a PostgreSQL database (Neon) via Claude, supporting customers, tickets, products, and analytics.MIT