Skip to main content
Glama
Doraitto5

MCP Student Assistant

by Doraitto5
OverviewSchemaRelated ServersScoreDiscussions
Python
Local

MCP Student Assistant

A beginner-friendly real-world mini project using Model Context Protocol (MCP) + Python + MySQL.

What it does

The MCP server exposes database operations as tools:

  • get_student_marks

  • get_attendance

  • get_pending_assignments

  • get_timetable

A client connects to the MCP server, discovers the tools, and calls them.

Related MCP server: SMU Schedule MCP Server

Architecture

Student -> MCP Client -> MCP Server -> MySQL -> MCP Response

Tech Stack

  • Python

  • MCP Python SDK

  • MySQL

  • VS Code

  • Git/GitHub

1. Create virtual environment

Windows PowerShell

python -m venv .venv
.venv\Scripts\Activate.ps1

macOS/Linux

python3 -m venv .venv
source .venv/bin/activate

2. Install packages

pip install -r requirements.txt

3. Configure MySQL

Create the database and sample data:

mysql -u root -p < database/student.sql

Or open database/student.sql in MySQL Workbench and run it.

Copy .env.example to .env and set your MySQL password.

4. Run the demo client

python client/ai_client.py

You should see the available MCP tools and a sample attendance result.

5. GitHub

git init
git add .
git commit -m "Initial MCP Student Assistant project"
git branch -M main
git remote add origin YOUR_GITHUB_REPOSITORY_URL
git push -u origin main

Important

Do not commit .env. It is already included in .gitignore.

Future upgrades

  • Connect an LLM to the MCP client for natural-language questions.

  • Add a web UI.

  • Add authentication.

  • Add teacher/admin tools.

  • Add assignment reminders.

This server cannot be installed

RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd
F
license - not found
Not graded
quality - not tested
C
maintenance

How are these scores calculated?

Maintenance

0Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Related MCP Connectors

Related MCP Servers

  • MySQL MCP Server

    bertshim
    -
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables interaction with MySQL databases through MCP tools for querying table structures, searching data across single or multiple tables, and managing database information. Built with FastMCP framework for secure database operations using environment-based configuration.

  • SMU Schedule MCP Server

    hwruchan
    F
    license
    Not graded
    quality
    Not graded
    maintenance
    Enables management of Sangmyung University academic information including schedules, meals, notices, and exam details. Provides tools to query, search, add, and delete university data through a MySQL database connection.

  • MCP-Server-CollageAI

    tanojrahul
    F
    license
    Not graded
    quality
    C
    maintenance
    Provides tools for querying student academic data such as subjects, marks, performance reports, timetable, exams, fees, events, holidays, and assignments via natural language.

  • College AI Assistant

    Abhi122005
    F
    license
    Not graded
    quality
    C
    maintenance
    Provides MCP tools for searching student profiles, viewing marks/attendance, and finding low-attendance students. Enables AI assistants like Gemini to interact with college student data through natural language.

View all related MCP servers

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/Doraitto5/MCP-Student-Assistant'

If you have feedback or need assistance with the MCP directory API, please join our Discord server