Weekly Report Checker MCP Server
An MCP (Model Context Protocol) server that checks weekly report submissions in a Google Sheet.
Features
- Check who hasn't submitted their weekly reports
- Get detailed information about a specific person's report status
- View submission statistics
- Get a list of all team members who should submit reports
Prerequisites
- Python 3.10 or higher
- A Google Sheets service account JSON file (
service_account.json) - Access to the "週報" Google Sheet
Installation
# Install the package
pip install -e .
# Install in Claude Desktop
./install_server.sh
# or
mcp install mcp_server.main --name "週報檢查器"
Usage
# Run in development mode
./run_server.sh
# or
mcp dev mcp_server.main
# Run directly
python -m mcp_server.main
# or
weekly-report-server
Example Client
Run the example client:
python example_usage.py
API Reference
Resources
weekly-report://status- Get who hasn't submitted reportsweekly-report://stats- Get submission statisticsweekly-report://all-members- Get all team membersweekly-report://person/{name}- Get a specific person's status
Tools
check_missing_reports- Check missing reportscheck_person_report- Check a specific person's reportget_submission_stats- Get submission statistics