Reservation System MCP Server

Integrates with the WeChat cloud development reservation system API.

这是一个基于 Model Context Protocol (MCP) 的微信云开发预约系统API服务器，允许AI模型安全地访问和管理预约数据。

- 支持按用户ID、状态、预约项目ID筛选
- 可设置返回记录数限制
- 返回格式化的预约信息

- 取消预约（状态设为10）
- 恢复预约（状态设为1）
- 系统取消（状态设为99）
- 可添加取消理由

WECHAT_APP_ID=你的微信小程序AppID WECHAT_APP_SECRET=你的微信小程序Secret WECHAT_ENV_ID=你的微信云环境ID

{ "mcpServers": { "reservation": { "command": "node", "args": ["/path/to/mcp-reservation-server/dist/index.js"], "env": { "WECHAT_APP_ID": "你的AppID", "WECHAT_APP_SECRET": "你的Secret", "WECHAT_ENV_ID": "你的环境ID" } } } }

{ "mcpServers": { "reservation": { "command": "node", "args": ["C:\\path\\to\\mcp-reservation-server\\dist\\index.js"], "env": { "WECHAT_APP_ID": "", "WECHAT_APP_SECRET": "", "WECHAT_ENV_ID": "" } } } }

请取消预约ID为 JOIN123456 的预约，理由是"用户主动取消"

- 获取Access Token:GET https://api.weixin.qq.com/cgi-bin/token
- 数据库查询:POST https://api.weixin.qq.com/tcb/databasequery
- 数据库更新:POST https://api.weixin.qq.com/tcb/databaseupdate
- 数据库删除:POST https://api.weixin.qq.com/tcb/databasedelete

- ax_join: 预约记录表

- JOIN_ID: 预约记录ID
- JOIN_USER_ID: 用户ID
- JOIN_MEET_ID: 预约项目ID
- JOIN_MEET_TITLE: 预约项目标题
- JOIN_STATUS: 预约状态
- JOIN_REASON: 取消理由
- 其他字段...
- 环境变量保护: 确保微信AppSecret等敏感信息通过环境变量设置，不要硬编码在代码中
- 访问权限: 确保只有受信任的AI客户端可以访问此MCP服务器
- 操作日志: 服务器会记录所有API调用，便于审计
- 数据备份: 删除操作不可撤销，建议定期备份重要数据

mcp-reservation-server/ ├── src/ │ ├── index.ts # 主服务器文件 │ ├── wechat-api.ts # 微信API客户端 │ └── types.ts # 类型定义 ├── package.json ├── tsconfig.json ├── .env.example └── README.md

- npm run build- 编译TypeScript
- npm run dev- 开发模式运行
- npm run clean- 清理构建文件

Zero-setup MCP gateway securely connecting AI to your tools with authentication and workflows

A ModelContextProtocol (MCP) server for interacting with the SAP Integration Suite.

A curated collection of 11 MCP servers for popular SaaS APIs — Stripe, Sentry, Notion, Linear, Datadog, Vercel, PagerDuty, HubSpot, Intercom, Shopify, and Google Workspace.

A Model Context Protocol (MCP) server that provides tools for AI, allowing it to interact with the DataWorks Open API through a standardized interface. This implementation is based on the Aliyun Open API and enables AI agents to perform cloud resources operations seamlessly.

Get your website online in seconds — just ask your AI assistant to publish it and Just Publish hands you a live link to share. No code, no setup, no hosting to figure out.

Manage Aiven cloud services like Kafka, PostgreSQL, and Redis via its API.

Automate Akamai resource actions using a conversational AI client. Requires Akamai API credentials.

Exposes API-Market's endpoints as MCP resources, requiring an API key for access.

Interact with the Appwrite API to manage databases, users, storage, and more. Requires configuration via environment variables.