DatahubMCP - Education Data Integration Server

MCP server enabling LLMs to query MySQL databases and Google Workspace for education program management.

What It Does

Connects LLM Desktop App to:

• MySQL Database: Enterprise database (Attendance, lesson plans, DRDP assessments, etc)

• Google Workspace: Sheets, Forms, Drive integration

• Built-in Templates: Data analysis and report generation prompts

Tech Stack

Backend: Python 3.13, FastMCP, SQLAlchemy
APIs: MySQL, Google OAuth 2.0, Google Sheets/Forms/Drive
Config: Environment variables, credential management
Architecture: Service layer pattern, connection pooling, context managers

Quick Start

# Install dependencies
uv sync

# Configure credentials
cp .env.example .env
# Edit .env with your DB and Google credentials

# Add to Claude Desktop config
{
  "mcpServers": {
    "datahub": {
      "command": "uv",
      "args": ["--directory", "/path/to/DatahubMCP", "run", "datahubmcp.py"]
    }
  }
}

Key Features

Database Tools

• Query attendance logs, lesson plans, DRDP records

• Filter by date range, site, classroom, child ID

• Hierarchical site/classroom listing

Google Workspace Tools

• List/read/write spreadsheets, create forms

• Sheet data as MCP resources

• OAuth authentication flow

Prompts

• analyze_sheet_data: Comprehensive analysis template

• create_report_template: Professional reports

• form_to_sheet: Form-to-spreadsheet workflow

Project Structure

datahubmcp.py      # FastMCP server with tool definitions
database.py        # MySQL session management
google_service.py  # Google OAuth & API builders
models.py          # SQLAlchemy ORM models
.env.example       # Configuration template

Example Usage

Via Claude Desktop App natural language:

"Show attendance for site S001 last week"
"Query DRDP records for child C456"
"List my recent spreadsheets"
"Create a feedback form"

Technical Highlights

• Session Management: Context managers for safe DB/API access

• Type Safety: Full type hints throughout codebase

• Security: Environment-based config, .gitignore for credentials

• Error Handling: Comprehensive validation and user-friendly messages

• Separation of Concerns: Modular architecture (DB/API/MCP layers)

Built for: Education program management
Contact: YC Huang (@yucheuan)