Provides tools for querying and managing Sangmyung University (SMU) data including schedules, meals, notices, and exam information stored in a MySQL database.
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 hostDB_USER: MySQL database userDB_PASSWORD: MySQL database password (required)DB_NAME: MySQL database nameDB_PORT: MySQL database port (default: 3306)
Usage
Local Development
Docker
Database Schema
The server expects the following tables:
smu_meals: Meal information with date, category, and meal contentsmu_notices: Notice information with title and URLsmu_exam: Exam information with subject_name and professorsmu_schedule: Schedule information with start_date, end_date, and content
License
MIT
Author
hwruchan
This server cannot be installed
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Enables management and querying of Sangmyung University schedules, meal plans, notices, and exam information through a MySQL database connection with timezone-aware operations.