AI相关-MCP (TRAR,codex)配置 MCP访问mysql、sqlserver数据库记录)
多个同类数据库配置说明
mcp_servers.mysql57_40_40的mysql57_40_40就是我们自定义的名称，比如有多个mysql库，可以定义 mysql57_40_40,mysql57_13_31 代表mysql服务器的后两个ip，方便区分,注意使用_下划线隔开，不要使用 . ，
TOML 里点号 . 不是普通字符，它会被解析成层级，所以这里不要用 . 改成下划线最稳
一.codex
1.1mysql
1.1.1 mysql mcp 配置
config.toml 增加配置
[mcp_servers.mysql57_40_40] command = "npx" args = ["-y", "@benborla29/mcp-server-mysql"] [mcp_servers.mysql57_40_40.env] MYSQL_HOST = "xx.xx.40.40" MYSQL_PORT = "3306" MYSQL_USER = "xxx" MYSQL_PASS = "xxxxxxx" MYSQL_DB = "bswhss410businesscrppe"1.1.2 mysql mcp 测试效果
直接输入 ：请使用 mysql57_40_40 mcp查询 下tj_yypt_yyjlb 有多少数据
1.2 sqlserver
1.2.1 sqlserver mcp 配置
[mcp_servers.sqlserver2008_40_31] command = "npx" args = ["-y", "@bilims/mcp-sqlserver"] [mcp_servers.sqlserver2008_40_31.env] SQLSERVER_HOST = "xx.xx.40.31" SQLSERVER_PORT = "1433" SQLSERVER_USER = "sa" SQLSERVER_PASSWORD = "xxxxxx" SQLSERVER_DATABASE = "bs_tjxt_xx" SQLSERVER_ENCRYPT = "false" SQLSERVER_TRUST_CERT = "true"1.2.2 sqlserver 测试效果
二.trae
2.1 mysql
2.1.1 mysql mcp 配置
{"mcpServers":{"mysql57_40_40":{"command":"npx","args":["-y","@benborla29/mcp-server-mysql"],"env":{"MYSQL_HOST":"xx.xx.40.40","MYSQL_PORT":"3306","MYSQL_USER":"xxxx","MYSQL_PASS":"xxxxx","MYSQL_DB":"bswhss410businesscrppe"}}}}2.2.2 mysql mcp 测试效果
直接问：请使用 sqlserver2008_40_31 mcp查询 下tj_tjdjb 有多少数据
2.2 sqlserver
2.2.1sqlserver mcp 配置
{
“mcpServers”: {
“sqlserver2008_40_31”: {
“command”: “npx”,
“args”: [“-y”, “@bilims/mcp-sqlserver”],
“env”: {
“SQLSERVER_HOST”: “xx.xx.40.31”,
“SQLSERVER_PORT”: “1433”,
“SQLSERVER_USER”: “sa”,
“SQLSERVER_PASSWORD”: “xxxxx”,
“SQLSERVER_DATABASE”: “bs_tjxt_xxx”,
“SQLSERVER_ENCRYPT”: “false”,
“SQLSERVER_TRUST_CERT”: “true”
}
}
}
}
2.2.2 sqlserver 测试效果
直接问：请使用 sqlserver2008_40_31 mcp查询 下tj_tjdjb 有多少数据
