What is Mcpconnect

MCPConnect is a multi-system connection demonstration project that facilitates interaction between various services such as CRM, ERP, and payment systems through a unified interface.

Use cases

Use cases for MCPConnect include creating and managing CRM users, processing ERP orders, executing SQL queries for data retrieval, and analyzing customer information for better sales strategies.

How to use

To use MCPConnect, initialize the database by running ‘python init_db.py’, start the services in separate terminals, and configure the MCP services in JSON format. You can then call the services using predefined tools for creating users, orders, and transactions.

Key features

Key features of MCPConnect include multi-system service integration, automated database queries, user-friendly service invocation tools, and the ability to handle various service types such as SSE and STDIO.

Where to use

MCPConnect can be used in various fields including enterprise resource planning, customer relationship management, and payment processing, making it suitable for businesses that require seamless integration of multiple systems.

MCPConnect

介绍

mcp多系统连接演示项目

multi_sys_calls 模拟系统使用mcp调用

运行流程

1. 初始化数据库：

python init_db.py

2. 启动各服务（分别在不同终端运行）：

python mcp_service.py
python crm_service.py
python erp_service.py
python payment_service.py

3. 添加mcp服务：

{
  "mcpServers": {
    "multi_sys_calls": {
      "name": "multi_sys_calls",
      "type": "sse",
      "description": "",
      "isActive": true,
      "provider": "jiangcheng",
      "providerUrl": "https://gitee.com/john213/MCPConnect",
      "baseUrl": "http://localhost:5000/sse"
    }
  }
}

4. 调用服务：

可用工具：

• create crm user

  创建crm用户mcp，如果用户没有提供姓名和邮箱请勿执行该工具，提示用户完善对应内容 参数:name姓名和email必填，不允许编造

• get crm user

  获取crm用户信息mcp 参数:user id

• create erp order

  创建erp订单mcp 参数:product,quantity

• create payment transaction

  创建payment支付mcp 参数:amount,currency

测试问题：

• 创建用户，用户名是11，邮箱是[email protected]
• 获取id为6的用户信息
• 创建订单Laptop，数量为2
• 创建支付信息，金额为2

database_calls 模拟mcp调用数据库自动查询

1. 初始化数据库：

进入mysql服务后执行sql文件sqlserver_mcp.sql

2. 添加mcp服务：

{
  "mcpServers": {
    "database_calls": {
      "name": "database_calls",
      "type": "stdio",
      "description": "",
      "isActive": true,
      "provider": "jiangcheng",
      "providerUrl": "https://gitee.com/john213/MCPConnect",
      "command": "xxx\\miniforge3\\envs\\MCPConnect\\python.exe",
      "args": [
        "xxx\\database_calls\\sqlserver_mcp.py"
      ]
    }
  }
}

3. 调用服务：

可用工具：

• describe table

  查询表详情 :return:

• list tables

  列出CRM数据库中的所有表 返回: 表名列表及其描述

• execute query

  执行SQL查询并返回结果 参数: query:要执行的SQL查询字符串 返回: 查询结果列表，每行作为一个字典

• get customer info

  获取指定客户的详细信息 参数: customer id: 客户ID 返回: 客户信息字典

• search customers

  搜索客户 参数: search_term:搜索关键词(会在姓名、邮箱和电话中搜索)limit: 返回结果的最大数量(默认10)返回.……

测试问题：

• 显示我们所有的VIP客户信息
• 哪些潜在客户最有可能转化?根据销售机会的阶段和概率分析
• 分析一下上海数字科技集团的消费情况，并对比他们购买的主要产品类别
• 哪些潜在客户最有可能转化?根据销售机会的阶段和概率分析
• 绘制过去一年中主要产品类别的销售收入占比变化趋势，使用堆面积图和数据标签展示

参与贡献

1. Fork 本仓库
2. 新建 Feat_xxx 分支
3. 提交代码
4. 新建 Pull Request