MCP.so
登录

School Database MCP Server

@eoinmooremath

代码仓库

关于 School Database MCP Server

MCP server for a school database

#school-db#mcp-server#database-management

基本信息

分类

数据库

运行时

python

传输方式

stdio

发布者

eoinmooremath

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "school-db-mcp-server": {
      "command": "python",
      "args": [
        "school_db_mcp.py"
      ]
    }
  }
}

工具

7

Inspect database structure and relationships

Run SQL queries safely

Record new behavior incidents

Classify behavior after LLM analysis

List unclassified behavior notes

Check if students need behavior alerts

Send automated email alerts

概览

What is School Database MCP Server?

A Model Context Protocol server for managing a mock school database with automated behavior tracking and alert system. It uses SQLite for storage and integrates with Gmail and LLM systems for notifications and classification.

How to use School Database MCP Server?

Install Python 3.12+, dependencies (mcp>=1.9.2), then run python school_db_mcp.py. The server communicates via stdio using the MCP protocol and provides tools for database inspection, query execution, behavior recording, classification, and alert sending.

Key features of School Database MCP Server?

  • Schema inspection with table relationships
  • Safe SQL query execution with parameter binding
  • Record and classify student behavior incidents
  • Automated behavior alert system with email notifications
  • LLM integration for behavior classification

Use cases of School Database MCP Server?

  • Manage student and teacher records
  • Track and classify behavior incidents
  • Generate automated alerts for concerning patterns
  • Serve as a backend data service for school systems

FAQ from School Database MCP Server

What is this MCP server used for?

It provides tools for managing a mock school database, recording and classifying student behavior incidents, and sending automated email alerts.

What are the dependencies and runtime requirements?

Python 3.12+, SQLite3, and the mcp>=1.9.2 Python package.

Where is the data stored?

Data is stored locally in an SQLite database file (school_data) created on the first run.

What transport and authentication does it use?

The server uses stdio for MCP communication; authentication is not covered, as it is a demonstration project.

Is this server intended for production use?

No, it is a demonstration/toy project using mock data for educational purposes.

评论

数据库 分类下的更多 MCP 服务器

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K

MCP MongoDB Server

kiliczsh

A Model Context Protocol Server for MongoDB

281

mcp_mysql_server

xwb602625136

Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展

245

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K