広告掲載投稿ログイン

School Database MCP Server

@eoinmooremath

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

eoinmooremath

School Database MCP Server について

MCP server for a school database

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

School Database MCP Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

School Database MCP Server のツール

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

よくある質問

1

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.

2

What are the dependencies and runtime requirements?

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

3

Where is the data stored?

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

4

What transport and authentication does it use?

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

5

Is this server intended for production use?

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

コメント

「データベース」の他のコンテンツ

Dbhub

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

Chroma MCP Server

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

Database Gateway

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

Multi Database MCP Server

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

MongoDB MCP Server

A Model Context Protocol server to connect to MongoDB databases and MongoDB Atlas Clusters.