DatahubMCP - Education Data Integration Server

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

Python 3.13+ License: MIT

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