範例資料庫下載位置, 這裡用 world 來測
https://dev.mysql.com/doc/index-other.html
mariadb mcp
https://github.com/mariadb/mcp
mcporter
https://github.com/steipete/mcporter
注意要把 mcporter skill 打開
確保已經安裝 uv, clone 專案並且安裝相依套件
1
2
3
4
5
| # pip install uv
git clone https://github.com/mariadb/mcp.git
cd mcp
uv lock
uv sync
|
建立 .env 在 mcp 這個目錄底下, 實際最好建一個 read only 的 user, 我這裡偷懶
1
2
3
4
5
6
7
8
| DB_HOST=localhost
DB_PORT=3306
DB_USER=root
DB_PASSWORD=root
DB_NAME=world
MCP_READ_ONLY=true
MCP_MAX_POOL_SIZE=10
|
測試
測試 mcporter
1
2
3
| mcporter call --output json \
--stdio "uv --directory /home/openclaw/mcp/src run server.py" \
list_databases
|
手動或是叫龍蝦幫你把路徑寫進去類似這樣的位置 /home/openclaw/.openclaw/workspace/config/mcporter.json
1
2
3
4
5
6
7
8
| {
"mcpServers": {
"mariadb-server": {
"command": "uv --directory /home/openclaw/mcp/src run server.py"
}
},
"imports": []
}
|
如果是 gemini cli 只需要在 .gemini/settings.json 裡面這樣設定就可以用了
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
| {
"security": {
"auth": {
"selectedType": "oauth-personal"
}
},
"mcpServers": {
"mariadb-official": {
"command": "uv",
"args": [
"--directory",
"C:\\Users\\yourusername\\Desktop\\hermes\\mcp",
"run",
"src/server.py"
]
}
}
}
|