weekly-report-mcp

weekly-report-mcp

0
databasescloud_platformsdeveloper_tools

This project is an MCP server designed to monitor and validate weekly report submissions in a Google Sheet. It provides functionalities such as tracking submission status, generating statistics, and listing team members who need to submit reports.

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 reports
  • weekly-report://stats - Get submission statistics
  • weekly-report://all-members - Get all team members
  • weekly-report://person/{name} - Get a specific person's status

Tools

  • check_missing_reports - Check missing reports
  • check_person_report - Check a specific person's report
  • get_submission_stats - Get submission statistics