SMU Schedule MCP Server

A Model Context Protocol (MCP) server for managing SMU (Sangmyung University) schedules, meals, notices, and exam information.

Features

Tools

• now_kr: Get current date/time in Asia/Seoul timezone
• query_smu_meals_by_date_category: Query SMU meals by date and category (breakfast/lunch/dinner)
• query_smu_meals_by_keyword: Search SMU meals by keyword
• query_smu_notices_by_keyword: Search SMU notices by keyword in title
• query_smu_exam: Search SMU exam information by subject name and optional professor
• query_smu_schedule_by_keyword: Search SMU schedule by keyword in content
• query_special_keywords: Get predefined responses for special keywords
• add_smu_schedule_structured: Add a new schedule to SMU schedule database
• delete_smu_schedule_by_content: Delete schedules by content keyword

Prompts

• default_prompt: Default system prompt for SMU chat assistant with timezone handling

Requirements

• Python 3.11+
• MySQL database with SMU data
• Required environment variables:
  • DB_HOST: MySQL database host
  • DB_USER: MySQL database user
  • DB_PASSWORD: MySQL database password (required)
  • DB_NAME: MySQL database name
  • DB_PORT: MySQL database port (default: 3306)

Usage

Local Development

# Install dependencies
pip install -r requirements.txt

# Set environment variables
export DB_HOST="your-db-host"
export DB_USER="your-db-user"
export DB_PASSWORD="your-db-password"
export DB_NAME="your-db-name"

# Run the server
python lastdance1008.py

Docker

# Build image
docker build -t smu-schedule-mcp .

# Run container
docker run -e DB_HOST=your-host \
           -e DB_USER=your-user \
           -e DB_PASSWORD=your-password \
           -e DB_NAME=your-db \
           smu-schedule-mcp

Database Schema

The server expects the following tables:

• smu_meals: Meal information with date, category, and meal content
• smu_notices: Notice information with title and URL
• smu_exam: Exam information with subject_name and professor
• smu_schedule: Schedule information with start_date, end_date, and content

License

MIT

Author

hwruchan