Skip to main content
Glama

Water Bar Email MCP Server

by DRBATA

Water Bar Email# Case File: Hydration

Another late night in the data district.

Supabase had the records.
React wrote the story.
Resend delivered the goods.

This isn't just another email server — it's an MCP crew working together to solve the hydration case.


The Demo

Watch the case unfold (add your video link)


The Evidence

  • Supabase MCP → Pulls the booking (neat, precise)

  • React Email → Dresses it up sharp (timeline, purple gradient, paired drinks)

  • Resend MCP → Slips it into the inbox (no middlemen)

  • Supabase logs → Keeps the receipts (sent, delivered, timestamped)

Case closed.


Fork This Case

Prerequisites:

Setup:

# Clone the case file git clone https://github.com/yourusername/case-file-hydration cd case-file-hydration # Install dependencies npm install

2. Build

npm run build

3. Configure Windsurf

Add to ~/.codeium/windsurf/mcp_config.json:

{ "mcpServers": { "waterbar-emails": { "command": "node", "args": ["C:\\Users\\azamb\\OneDrive\\Desktop\\THE.WATER.BAR\\mcp-waterbar-emails\\build\\index.js"], "env": { "RESEND_API_KEY": "re_your_api_key_here" } } } }

4. Refresh MCP in Windsurf

Click the hammer icon → Refresh MCP servers

Demo: AOI Booking Confirmation

In Windsurf chat, try:

Use the waterbar-emails MCP. Call send_waterbar_email with this: { "flow": "aoi-booking-confirmation", "to": "azambata.1984@gmail.com", "data": { "customerName": "Dr Azam", "bookingDate": "2025-07-06", "venue": "AOI - Al Quoz, Dubai", "totalAmount": "AED 180.00", "paymentUrl": "https://buy.stripe.com/test_xxx", "bookings": [ { "time": "08:30", "experience": "Ice Bath", "duration": 10, "preDrink": "Ginger Shot", "explanation": "Ice Bath sharply awakens your system through noradrenaline release." }, { "time": "09:10", "experience": "AOI Air PRO Implosion Dome", "duration": 50, "duringDrink": "Humantra Electrolytes", "explanation": "Immersive light and sound enhance cognitive clarity and focus." }, { "time": "10:10", "experience": "Infrared Sauna", "duration": 30, "afterDrink": "METÉ Sparkling Water", "explanation": "Gentle warmth opens circulation, preparing you for integration." } ] } }

Available Flows

  • aoi-booking-confirmation - AOI experience bookings with timeline

  • water-bar-order-confirmation - Water Bar order receipts

  • water-bar-followup - Post-visit thank you

  • water-bar-missed-you - Event no-show followup

Hackathon Demo Script

Opening:

"I built an AI-orchestrated wellness booking system that chains Supabase + OpenAI + Stripe + Resend to automate multi-venue experience confirmations."

Show:

  1. User books Ice Bath + Air PRO + Sauna on AOI site

  2. AI suggests paired drinks based on physiology

  3. Windsurf calls send_waterbar_email MCP tool

  4. Beautiful branded email arrives with timeline + drinks

Emphasize:

  • Multi-MCP orchestration (4 services)

  • Real business value (actual bookings)

  • AI-driven content (drink pairings, explanations)

  • Repeatable (React Email templates = editable)


?? Planned Future Flows (Beyond Hackathon Demo)

This repo currently showcases Flow 1: AOI Booking Confirmation.
We’ve also designed (not demoed here) additional flows:

  • ?? Hydration plan generation (Supabase ? Resend)

  • ?? On-venue orchestration (timeline + paired drinks)

  • ?? Combined experience recap (Stripe ? Resend ? Supabase)

These are detailed in docs/Confidential/APPENDIX_CASE_NOTES.md,
but only Flow 1 is guaranteed to work out-of-the-box for hackathon judges.

-
security - not tested
A
license - permissive license
-
quality - not tested

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/DRBATA/case-file-hydration'

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