Weekly Report Checker MCP Server

What is Weekly Report Checker MCP Server?

A Model Context Protocol (MCP) server that checks weekly report submissions in a Google Sheet ("週報"). It is intended for teams that need to track who has or hasn’t submitted their weekly reports.

How to use Weekly Report Checker MCP Server?

Install the package with pip install -e . and optionally register it in Claude Desktop using ./install_server.sh or mcp install mcp_server.main --name "週報檢查器". Run in development mode with ./run_server.sh or mcp dev mcp_server.main, or directly with python -m mcp_server.main. An example client is provided in example_usage.py.

Key features of Weekly Report Checker MCP Server

• Checks who hasn’t submitted their weekly reports
• Provides detailed status for a specific person
• Shows submission statistics
• Lists all team members who should submit reports
• Exposes resources and tools via MCP

Use cases of Weekly Report Checker MCP Server

• Automating weekly report submission tracking in a code‑friendly way
• Querying submission status for a single team member
• Getting an overview of team submission compliance
• Integrating with Claude Desktop for natural‑language report checks

FAQ from Weekly Report Checker MCP Server

What prerequisites are needed to run the server?

Python 3.10 or higher, a Google Sheets service account JSON file (service_account.json), and access to the "週報" Google Sheet.

How do I install and configure the server?

Install the package with pip install -e . and optionally install it in Claude Desktop using the provided install_server.sh script or the mcp install command.

What resources and tools does the server expose?

Resources include weekly-report://status, weekly-report://stats, weekly-report://all-members, and weekly-report://person/{name}. Tools include check_missing_reports, check_person_report, and get_submission_stats.

How do I run the server in development mode?

Use ./run_server.sh or mcp dev mcp_server.main. For direct execution, run python -m mcp_server.main or the weekly-report-server command.

Where does the data come from and what authentication is required?

Data is read from a Google Sheet named "週報". Authentication uses a service account JSON file (service_account.json) placed in the project directory.