MCP服务器工具集

MCP Demo Server

A collection of Model Context Protocol (MCP) server implementations for databases, files, HTTP APIs, message middleware, and the local Outlook mailbox.

中文文档 | English Documentation

Overview

This repository provides MCP servers you can plug into Cursor or any MCP-compatible client:

• server.js - Basic hello-world MCP server
• server-mysql.js - MySQL query and CRUD-like operations
• server-tdengine.js - TDengine SQL query and data operations via REST
• server-mongodb.js - MongoDB query/insert/update/delete/list collections
• server-read-files.js - File reading tool
• server-axios.js - HTTP GET/POST/PUT/DELETE tools
• server-mqtt.js - MQTT subscribe/publish with runtime topic management
• server-kafka.js - Kafka consume/publish with runtime subscriptions
• server-outlook.js - Read-only access to the local classic Outlook mailbox (Windows)

Requirements

• Node.js 18+
• npm
• server-outlook.js only: Windows with classic Outlook (Microsoft 365 / Office 16) and the mailbox account configured

Installation

npm install
cp .env.example .env

Use a different env file when needed:

set ENV_FILE=.env.beta && node server-mysql.js

Environment Configuration

All database servers load config via dotenv:

• Default: load .env in the project root
• Override: set ENV_FILE to another file path
• Template: see .env.example

The project supports optional SSH jump tunnels for MySQL, MongoDB, TDengine, and Kafka using:

• SSH_JUMPS (global jumps)
• MYSQL_SSH_JUMPS, MONGO_SSH_JUMPS, TDENGINE_SSH_JUMPS, KAFKA_SSH_JUMPS (service-specific jumps)

Tool Matrix

server.js

• say_hello

server-mysql.js (mysql-tools)

• query_mysql
• insert_mysql
• update_mysql
• delete_mysql

server-tdengine.js (tdengine-tools)

• query_tdengine
• insert_tdengine
• update_tdengine
• delete_tdengine

server-mongodb.js (mongo_db-tools)

• query_mongo
• mongo_insert
• mongo_update
• mongo_delete
• list_mongo_collections

server-read-files.js (file-tools)

• readFile

server-axios.js (axios-tools)

• call_api_get
• call_api_post
• call_api_put
• call_api_delete

server-mqtt.js (mqtt-tools)

• mqtt_status
• mqtt_get_messages
• mqtt_publish
• mqtt_subscribe
• mqtt_subscribe_batch
• mqtt_unsubscribe
• mqtt_clear_messages

server-kafka.js (kafka-tools)

• kafka_status
• kafka_publish
• kafka_subscribe
• kafka_get_messages
• kafka_clear_messages

server-outlook.js (outlook-tools)

• outlook_status
• outlook_list_folders
• outlook_list_messages
• outlook_search_messages
• outlook_get_message

Read-only. Talks to the local classic Outlook through COM (scripts/outlook.ps1, run via PowerShell), so it needs Windows and classic Outlook with the mailbox configured. The new Outlook for Windows has no COM API and cannot be used. Folder paths use / (e.g. Projects/Optim 6); inbox, sent, drafts, deleted, junk map to the default folders. Message ids are Outlook EntryIDs returned by list/search.

Outlook tool parameters

A message summary contains id, folder, receivedTime, from, fromAddress (SMTP, also for internal Exchange senders), subject, unread, hasAttachments, categories, messageClass.

• since / until accept ISO dates in local time, e.g. 2026-10-01 or 2026-10-01T09:00.
• query is a case-insensitive substring match (Outlook DASL LIKE).
• Without folder, outlook_search_messages searches the whole mailbox except Deleted Items and Junk Email. Searching a single folder is much faster than the whole mailbox.
• Folder names that contain / are returned as %2F (e.g. Projects/PON%2FWAN) and can be passed back in that form.

Example calls:

{ "tool": "outlook_list_messages", "arguments": { "folder": "inbox", "unreadOnly": true, "limit": 10 } }
{ "tool": "outlook_search_messages", "arguments": { "query": "Health Score", "field": "subject", "since": "2026-10-01" } }
{ "tool": "outlook_search_messages", "arguments": { "query": "ORC", "folder": "Projects/Optim 6", "includeSubfolders": true } }
{ "tool": "outlook_get_message", "arguments": { "id": "<EntryID from a list/search result>", "maxBodyChars": 5000 } }

Outlook troubleshooting

• connectionMode is 400 / offline is true: classic Outlook is disconnected from Exchange or in Work Offline mode. Reads still work from the local cache (OST) but may be stale; turn off Send / Receive → Work Offline.
• First call is slow: Outlook is started in the background if it is not already running.
• Only recent mail is found: cached mode only downloads a time window (e.g. 1 year). Change it in File → Account Settings → (account) → Download email for the past.
• Using the new Outlook only: install / open classic Outlook and add the account once; both apps can run side by side.

Kafka environment variables

Kafka + Kubernetes + SSH notes

When Kafka runs inside Kubernetes and MCP runs on your local machine:

1. Use Pod IPs or reachable broker addresses in KAFKA_BROKERS.
2. List all brokers in StatefulSet order (kafka-0 … kafka-N) when using SSH tunnels.
3. Set KAFKA_BROKER_DNS_SUFFIX so advertised listeners like kafka-3.kafka-headless-service.default.svc.cluster.local are remapped through local SSH tunnels.
4. kafka_get_messages returns messages received after subscription (in-memory buffer). Use kafka_subscribe with fromBeginning: true to read historical messages.

Example .env.alpha fragment:

KAFKA_BROKERS=10.10.112.155,10.10.112.158,10.10.193.132,10.10.25.210,10.10.52.138
KAFKA_TOPICS=OC_EVENTS,OC_METRICS,OC_UPDATE
KAFKA_BROKER_DNS_SUFFIX=kafka-headless-service.default.svc.cluster.local
KAFKA_SSH_JUMPS=[{"host":"jump-1.example.com","port":22,"user":"ubuntu","privateKeyPath":"D:/keys/jump1"},{"host":"10.2.2.6","port":22,"user":"ubuntu","privateKeyPath":"D:/keys/jump2"}]

Run Servers

node server.js
node server-mysql.js
node server-tdengine.js
node server-mongodb.js
node server-read-files.js
node server-axios.js
node server-mqtt.js --host alpha --topics "/events/#"
node server-kafka.js --brokers localhost:9092 --topics OC_EVENTS,OC_METRICS
node server-outlook.js

With environment file:

set ENV_FILE=.env.alpha && node server-kafka.js

Cursor MCP Config Example

{
  "mcpServers": {
    "mysql-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-mysql.js"],
      "env": { "ENV_FILE": "D:/projects/mcp-demo-server/.env" }
    },
    "tdengine-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-tdengine.js"],
      "env": { "ENV_FILE": "D:/projects/mcp-demo-server/.env" }
    },
    "mongo-db-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-mongodb.js"],
      "env": { "ENV_FILE": "D:/projects/mcp-demo-server/.env" }
    },
    "outlook-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-outlook.js"]
    },
    "kafka-alpha-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-kafka.js"],
      "env": { "ENV_FILE": "D:/projects/mcp-demo-server/.env.alpha" }
    },
    "kafka-beta-tools": {
      "command": "node",
      "args": ["D:/projects/mcp-demo-server/server-kafka.js"],
      "env": { "ENV_FILE": "D:/projects/mcp-demo-server/.env.beta" }
    }
  }
}

Claude Code Registration Example

claude mcp add outlook-tools --scope user -- node "D:\projects\mcp-demo-server\server-outlook.js"
claude mcp add mysql-alpha-tools --scope user -e ENV_FILE=D:/projects/mcp-demo-server/.env.alpha -- node "D:\projects\mcp-demo-server\server-mysql.js"
claude mcp list

Main Dependencies

• @modelcontextprotocol/sdk
• axios
• dotenv
• kafkajs
• mongodb
• mqtt
• mysql2
• tunnel-ssh
• zod

Security Notes

Before production use:

1. Replace default credentials and rotate secrets.
2. Restrict database privileges for MCP accounts.
3. Limit operation flags in .env (for example disable delete).
4. Restrict filesystem access scope.
5. Enable stronger TLS/certificate verification where applicable.
6. outlook-tools exposes your mailbox content to the MCP client; only register it with clients you trust. It is read-only and has no send / move / delete tools.

License

Provided as-is for demonstration and learning purposes.