Wedding Planner Server

A Model Context Protocol (MCP) server that connects AI assistants to a Google Sheets wedding planner template. Manage your wedding budget, guest list, schedule, and more — all through natural language via any MCP-compatible client.

✨ Features

📋 To-Do & Coordination

Tool	Description
get_todos	Get all to-do items
add_todo	Add a new to-do item
update_todo	Update an existing to-do
delete_todo	Delete a to-do item
get_coordination	Get vendor coordination data
update_coordination	Update vendor coordination

📅 Schedule

Tool	Description
get_schedule	Get the wedding day schedule
update_schedule	Update a schedule entry
delete_schedule	Clear a schedule entry

💰 Budget (Full CRUD + Category Management)

Tool	Description
get_budget_summary	Budget estimator overview
get_detailed_budget	All items from Detailed budget
add_budget_category	Create new category (auto-clones formatting & formulas)
update_budget_category	Rename category and/or update estimate
delete_budget_category	Delete custom category (with protection for built-in categories)
add_budget_item	Add item to a category (smart row insertion)
update_budget_item	Update an existing budget item
delete_budget_item	Delete a budget item

👥 Guest List

Tool	Description
get_guest_list	Get all guests with details
add_guest	Add a new guest
update_guest	Update guest info by row
delete_guest	Delete a guest
search_guests	Search by name, invitedBy, or any field
get_guest_summary	Stats: total, attending, responses, by invitedBy

💌 Invitations

Tool	Description
get_invitations	Get summary counts and vendor list
add_invitation_vendor	Add a new vendor
update_invitation_vendor	Update vendor details
delete_invitation_vendor	Delete a vendor

📆 Google Calendar

Tool	Description
list_calendar_events	List upcoming or filtered calendar events
get_calendar_event_information	Get detailed information for one event
create_calendar_event	Create a timed or all-day calendar event
create_detailed_calendar_event	Create an event with attendees, recurrence, reminders, visibility, color, and guest permissions
update_calendar_event	Patch an existing calendar event
add_attendees_to_calendar_event	Add attendees without removing existing attendees
delete_calendar_event	Delete a calendar event

🛠 Prerequisites

• Node.js ≥ 22
• Google Cloud Service Account with Sheets API and Calendar API access
• A Google Sheets spreadsheet based on the wedding planner template
• A Google Calendar shared with the service account if using a non-delegated service account

⚡ Quick Start

1. Clone & Install

git clone https://github.com/kiboud/weddingplanner_mcp.git
cd weddingplanner_mcp
npm install

2. Configure

Create a .env file:

SPREADSHEET_ID=your_google_spreadsheet_id_here
CALENDAR_ID=your_google_calendar_id_here
CALENDAR_TIME_ZONE=Asia/Jakarta
GOOGLE_APPLICATION_CREDENTIALS=./gcp-service-account.json
PORT=8080

Place your GCP service account credentials as gcp-service-account.json in the project root.

CALENDAR_ID is optional and defaults to primary. For service accounts, it is usually better to create or choose a Google Calendar, share it with the service account email, and set that calendar's ID here.

3. Build & Run

npm run build
npm start

The server will start on http://localhost:8080 with:

• MCP endpoint: http://localhost:8080/mcp (Streamable HTTP transport)

🐳 Docker

Build & Run

docker compose up -d --build

Build & Run without Compose

docker build -t weddingplanner-mcp .
docker stop weddingplanner-mcp || true
docker rm weddingplanner-mcp || true
docker run -d \
  --name weddingplanner-mcp \
  --restart unless-stopped \
  -p 8080:8080 \
  --env-file .env \
  -v /path/to/gcp-service-account.json:/root/.openclaw/workspace-mimi/gcp-service-account.json:ro \
  weddingplanner-mcp

docker-compose.yml

The included docker-compose.yml mounts the GCP credentials and exposes port 8080. Adjust the volume path to match your credential location:

volumes:
  - /path/to/gcp-service-account.json:/root/.openclaw/workspace-wedding/gcp-service-account.json:ro

🔗 Connect to an MCP Client

Gemini CLI / Antigravity

Add to your MCP config:

{
  "mcpServers": {
    "wedding-planner": {
      "url": "http://localhost:8080/mcp"
    }
  }
}

Claude Desktop

Add to claude_desktop_config.json:

{
  "mcpServers": {
    "wedding-planner": {
      "url": "http://localhost:8080/mcp"
    }
  }
}

📁 Project Structure

weddingplanner_mcp/
├── src/
│   ├── index.ts           # MCP server + tool registry
│   └── google-sheets.ts   # Google Sheets API service layer
├── build/                 # Compiled JS (gitignored)
├── Dockerfile
├── docker-compose.yml
├── tsconfig.json
├── package.json
└── .env                   # Config (gitignored)

🔒 Security Notes

• .env and gcp-service-account.json are gitignored — never commit secrets
• Built-in budget categories (Ceremony, Reception, etc.) are protected from deletion
• Duplicate category names are rejected

📄 License

ISC