DatahubMCP Server

Provides access to MySQL data and Google Workspace through an MCP server for education program management.

python

5

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "yucheuan-datahubmcp": {
      "command": "uv",
      "args": [
        "--directory",
        "/path/to/DatahubMCP",
        "run",
        "datahubmcp.py"
      ]
    }
  }
}

DatahubMCP is an Education Data Integration Server that lets you connect an LLM-based Desktop App to your MySQL databases and Google Workspace, enabling unified querying, data analysis, and automated workflow creation for education program management. It streamlines access to attendance, lesson plans, DRDP records, and Google Sheets/Forms/Drive, with built-in templates to generate analyses and reports.

How to use

You interact with DatahubMCP through your MCP client by selecting the datahub MCP you configured and issuing natural language queries. Use it to: pull attendance or DRDP records by site, classroom, or child ID; generate data-driven reports; read and write Google Sheets or create Forms; and convert form responses into sheet data. The prompts simplify common tasks such as analyzing sheet data, creating professional reports, or routing form responses into spreadsheets. Start by ensuring your credentials are loaded and your client is pointed at the DatahubMCP server.

How to install

Prerequisites: you need Python 3.13 on your system and access to run the MCP runtime tool. You also need a text editor to edit configuration files.

Install and configure the server locally using the following steps.

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

Additional sections

Configuration and security follow standard MCP practices. Credentials for MySQL and Google Workspace are managed via environment-based configuration. Do not commit credentials into version control. Use a dedicated .env file and add it to your .gitignore. The project uses a modular architecture with a separate data layer for DB access, a Google API layer for OAuth and Sheets/Forms/Drive interactions, and an MCP layer that exposes tool-enabled endpoints.

Example prompts included with the server cover common workflows: analyze_sheet_data for full-sheet analytics, create_report_template for polished reports, and form_to_sheet to map form responses into a spreadsheet. These prompts are available as part of the built-in templates to accelerate setup and usage.

If you encounter issues, verify that your environment variables are loaded correctly, ensure that your database user has the necessary permissions, and confirm that Google OAuth credentials are valid and not expired. Use descriptive error messages to guide troubleshooting and adjust your .env file as needed.

Available tools

analyze_sheet_data

Comprehensive analytics template for evaluating and summarizing spreadsheet data within Google Sheets or exported sheet data.

create_report_template

Template to generate professional, ready-to-share reports from data analyses and summaries.

form_to_sheet

Workflow that routes form responses into a Google Sheet for storage, tracking, and further processing.