Skip to content

Commit 1e01a92

Browse files
authored
chore: update mcp server template sql (#6649)
1 parent 252f8c2 commit 1e01a92

File tree

1 file changed

+90
-37
lines changed

1 file changed

+90
-37
lines changed

.erda/ai-proxy/migrations/ai-proxy/20251103-mcp-server-template.sql

Lines changed: 90 additions & 37 deletions
Original file line numberDiff line numberDiff line change
@@ -14,43 +14,96 @@ CREATE TABLE IF NOT EXISTS `ai_proxy_mcp_server_template`
1414
) ENGINE = InnoDB
1515
DEFAULT CHARSET = utf8mb4 COMMENT 'ai-proxy MCP 配置模板表';
1616

17-
INSERT INTO `ai_proxy_mcp_server_template` (`mcp_name`, `version`, `template`)
18-
VALUES ('enterprise-tools', '1.0.0', '[]'),
19-
('html-generator', '2.0.0', '[
20-
{
21-
"default": "",
22-
"description": "生成HTML的额外说明",
23-
"name": "instructions",
24-
"required": false,
25-
},
26-
{
27-
"description": "模型名称",
28-
"name": "model_name",
29-
"required": true,
30-
},
31-
{
32-
"description": "模型发布商",
33-
"name": "model_publisher",
34-
"required": true,
35-
}
36-
]'),
37-
('search-oil', '1.0.0', '[]'),
38-
('pptx-agent', '1.0.0', '[]'),
39-
('mcp-timer', '1.0.0', '[]'),
40-
('mcp-server-baidu-maps', '1.11.0', '[]'),
41-
('playwright', '1.0.0', '[]'),
42-
('office-word-mcp-server', '1.0.0', '[]'),
43-
('mcp-milvus', '1.0.0', '[]'),
44-
('mcp-fetch', '1.0.0', '[]'),
45-
('search-engine', '3.0.0','[]'),
46-
('mcp-python-script', '1.0.0', '[]'),
47-
('mcp-calculator', '1.0.0', '[]'),
48-
('search-engine', '1.0.0', '[]'),
49-
('mcp-ocr', '1.0.0', '[]'),
50-
('mcp-email', '1.0.0','[]'),
51-
('pymupdf4llm-mcp-server', '1.0.0', '[]'),
52-
('12306', '1.0.0', '[]'),
53-
('mcp-exchange-rate', '1.0.0', '[]');
17+
INSERT INTO `ai_proxy_mcp_server_template` (`mcp_name`, `version`, `template`, `description`)
18+
VALUES
19+
('enterprise-tools', '1.0.0', '[
20+
{
21+
"description": "天眼查 Token",
22+
"name": "token",
23+
"required": true,
24+
"type": "string"
25+
}
26+
]', '提供用于查询企业信息和上市公司股票信息的工具'),
27+
('html-generator', '2.0.0', '[
28+
{
29+
"default": "",
30+
"desc": "生成HTML的额外说明",
31+
"name": "instructions",
32+
"required": false,
33+
"type": "string"
34+
},
35+
{
36+
"desc": "模型名称",
37+
"name": "model_name",
38+
"required": true,
39+
"type": "string"
40+
},
41+
{
42+
"desc": "模型发布商",
43+
"name": "model_publisher",
44+
"required": true,
45+
"type": "string"
46+
}
47+
]', '一个简单的HTML生成工具,可帮助用户生成图表等内容'),
48+
('search-oil', '1.0.0', '[]', '一个搜索工具,提供汽油价格和螺纹钢价格查询功能'),
49+
('pptx-server', '1.0.0', '[]', '一个PPT模板生成工具,提供多种模板构建功能'),
50+
('pptx-agent', '1.0.0', '[]', '一个PPT生成工具,可根据用户提供的数据生成PPT'),
51+
('mcp-timer', '1.0.0', '[]', '提供时间戳与日期时间互相转换的两个工具'),
52+
('mcp-server-baidu-maps', '1.11.0', '[]', '百度地图MCP服务器,符合MCP标准的开源LBS解决方案,为开发者和AI代理提供地理位置相关API与工具'),
53+
('playwright', '1.0.0', '[]', '基于Playwright的浏览器自动化与测试工具'),
54+
('office-word-mcp-server', '1.0.0', '[]', '用于创建、读取和操作Microsoft Word文档的MCP服务器'),
55+
('mcp-milvus', '1.0.0', '[]', '提供Milvus向量数据库的访问功能'),
56+
('mcp-fetch', '1.0.0', '[]', '网页内容抓取工具'),
57+
('search-engine', '3.0.0', '[]', '为大语言模型(LLM)提供联网搜索功能的工具'),
58+
('mcp-python-script', '1.0.0', '[]', '提供远程执行Python脚本的功能'),
59+
('mcp-stock', '1.0.0', '[]', '用于查询中国上市公司股票、财务和市场信息的工具'),
60+
('mcp-calculator', '1.0.0', '[]', '一个MCP计算器,可计算数学表达式,如 2+5*3-(5-2)'),
61+
('search-engine', '1.0.0', '[]', '为大语言模型(LLM)提供联网搜索功能的工具'),
62+
('mcp-ocr', '1.0.0', '[]', '提供快速准确的光学字符识别(OCR)功能,用于从图片中提取文字'),
63+
('mcp-email', '1.0.0', '[
64+
{
65+
"description": "用户名称",
66+
"name": "user",
67+
"required": true,
68+
"type": "string"
69+
},
70+
{
71+
"description": "用户名密码",
72+
"name": "password",
73+
"required": true,
74+
"type": "string"
75+
},
76+
{
77+
"description": "IMAP 服务器地址(收件)",
78+
"name": "imap_host",
79+
"required": true,
80+
"type": "string"
81+
},
82+
{
83+
"description": "IMAP 服务器端口",
84+
"name": "imap_port",
85+
"required": true,
86+
"type": "integer"
87+
},
88+
{
89+
"description": "SMTP 服务器地址(发件)",
90+
"name": "smtp_host",
91+
"required": true,
92+
"type": "string"
93+
},
94+
{
95+
"description": "SMTP 服务器端口",
96+
"name": "smtp_port",
97+
"required": true,
98+
"type": "integer"
99+
}
100+
]', '提供邮件发送功能的工具'),
101+
('google-maps', '1.0.0', '[]', '提供谷歌地图服务的工具'),
102+
('pymupdf4llm-mcp-server', '1.0.0', '[]', '用于将PDF文件转换为Markdown格式以供LLM使用的MCP服务器'),
103+
('12306', '1.0.0', '[]', '12306火车票查询服务MCP服务器'),
104+
('mcp-exchange-rate', '1.0.0', '[]', '提供实时汇率查询功能的工具'),
105+
('pptx-server', '2.0.0', '[]', '一个PPT模板生成工具,提供多种模板构建功能');
106+
54107

55108

56109
CREATE TABLE IF NOT EXISTS `ai_proxy_mcp_server_config_instance`

0 commit comments

Comments
 (0)