Cherry Studio 配置MySql

1,014 阅读1分钟

在Cherry Studio 中配置Mysql 的mcp server,每个添加完成后都无法连接,因此需要先下载一个本地的mysql mcp server,参考:juejin.cn/post/748331… clone github.com/designcompu… src\mysql_mcp_server目录下执行uv run server.py,首次执行会提示"missing database configuration", 需要把server.py中的内容修改:

def get_db_config():
    """Get database configuration from environment variables."""
    config = {
        "host": os.getenv("MYSQL_HOST", "localhost"),
        "port": int(os.getenv("MYSQL_PORT", "3306")),
        "user": "useradmin",
        "password": "password123",
        "database": "databasename"  
    }

uv run server.py可以正常执行后配置Cherry Studio MCP Server: { "mcpServers": { "mysql": { "name": "mysql", "type": "stdio", "description": "local mysql mcp server", "isActive": true, "registryUrl": "", "command": "uv", "args": [ "--directory", "F:\workspace\mysql_mcp_server", "run", "mysql_mcp_server" ], "env": { "MYSQL_HOST": "localhost", "MYSQL_PORT": "3306", "MYSQL_USER": "useradmin", "MYSQL_PASSWORD": "password123", "MYSQL_DATABASE": "databasename" } } } } 此时配置完成后即可开启mysql 的mcp server了,

image.png