# 安装 io.github.motherduckdb/mcp-server-motherduck

- 类型: MCP 工具
- 说明: 连接 MotherDuck 执行 SQL 分析与数据工程任务，支持 AI 助手高效处理数据。
- 仓库: https://github.com/motherduckdb/mcp-server-motherduck

## 方式一 · 一键代装（复制提示词让 AI 代劳）

### Claude Code
```
请帮我安装 askskill 上的 "io.github.motherduckdb/mcp-server-motherduck" MCP 服务：
执行：claude mcp add 'io-github-motherduckdb-mcp-server-motherduck' -- npx -y mcp-server-motherduck
```

### Codex
```
请帮我安装 askskill 上的 "io.github.motherduckdb/mcp-server-motherduck" MCP 服务：
在 ~/.codex/config.toml 中添加：
[mcp_servers.io-github-motherduckdb-mcp-server-motherduck]
command = "npx"
args = ["-y","mcp-server-motherduck"]
然后重启 Codex 生效
```

### Cursor
```
请帮我安装 askskill 上的 "io.github.motherduckdb/mcp-server-motherduck" MCP 服务：
在 .cursor/mcp.json 的 "mcpServers" 中添加：
"io-github-motherduckdb-mcp-server-motherduck": { "command": "npx", "args": ["-y","mcp-server-motherduck"] }
然后在 Cursor 设置 > MCP 中启用
```

## 方式二 · 命令行安装（原生命令与配置）

### Claude Code
```bash
claude mcp add --env MOTHERDUCK_TOKEN=YOUR_VALUE --env HOME=YOUR_VALUE --env AWS_ACCESS_KEY_ID=YOUR_VALUE --env AWS_SECRET_ACCESS_KEY=YOUR_VALUE --env AWS_SESSION_TOKEN=YOUR_VALUE --env AWS_DEFAULT_REGION=YOUR_VALUE --env AWS_ENDPOINT=YOUR_VALUE --transport stdio io-github-motherduckdb-mcp-server-motherduck -- npx -y mcp-server-motherduck
```
需要环境变量：MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT

### Codex
```bash
codex mcp add --env MOTHERDUCK_TOKEN=YOUR_VALUE --env HOME=YOUR_VALUE --env AWS_ACCESS_KEY_ID=YOUR_VALUE --env AWS_SECRET_ACCESS_KEY=YOUR_VALUE --env AWS_SESSION_TOKEN=YOUR_VALUE --env AWS_DEFAULT_REGION=YOUR_VALUE --env AWS_ENDPOINT=YOUR_VALUE io-github-motherduckdb-mcp-server-motherduck -- npx -y mcp-server-motherduck
```
配置文件 ~/.codex/config.toml：
```toml
[mcp_servers.io-github-motherduckdb-mcp-server-motherduck]
command = "npx"
args = ["-y","mcp-server-motherduck"]

[mcp_servers.io-github-motherduckdb-mcp-server-motherduck.env]
MOTHERDUCK_TOKEN = "YOUR_VALUE"
HOME = "YOUR_VALUE"
AWS_ACCESS_KEY_ID = "YOUR_VALUE"
AWS_SECRET_ACCESS_KEY = "YOUR_VALUE"
AWS_SESSION_TOKEN = "YOUR_VALUE"
AWS_DEFAULT_REGION = "YOUR_VALUE"
AWS_ENDPOINT = "YOUR_VALUE"
```
需要环境变量：MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT

### Cursor
配置文件 .cursor/mcp.json：
```json
{
  "mcpServers": {
    "io-github-motherduckdb-mcp-server-motherduck": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-server-motherduck"
      ],
      "env": {
        "MOTHERDUCK_TOKEN": "YOUR_VALUE",
        "HOME": "YOUR_VALUE",
        "AWS_ACCESS_KEY_ID": "YOUR_VALUE",
        "AWS_SECRET_ACCESS_KEY": "YOUR_VALUE",
        "AWS_SESSION_TOKEN": "YOUR_VALUE",
        "AWS_DEFAULT_REGION": "YOUR_VALUE",
        "AWS_ENDPOINT": "YOUR_VALUE"
      }
    }
  }
}
```
一键安装：cursor://anysphere.cursor-deeplink/mcp/install?name=io-github-motherduckdb-mcp-server-motherduck&config=eyJjb21tYW5kIjoibnB4IiwiYXJncyI6WyIteSIsIm1jcC1zZXJ2ZXItbW90aGVyZHVjayJdLCJlbnYiOnsiTU9USEVSRFVDS19UT0tFTiI6IllPVVJfVkFMVUUiLCJIT01FIjoiWU9VUl9WQUxVRSIsIkFXU19BQ0NFU1NfS0VZX0lEIjoiWU9VUl9WQUxVRSIsIkFXU19TRUNSRVRfQUNDRVNTX0tFWSI6IllPVVJfVkFMVUUiLCJBV1NfU0VTU0lPTl9UT0tFTiI6IllPVVJfVkFMVUUiLCJBV1NfREVGQVVMVF9SRUdJT04iOiJZT1VSX1ZBTFVFIiwiQVdTX0VORFBPSU5UIjoiWU9VUl9WQUxVRSJ9fQ
需要环境变量：MOTHERDUCK_TOKEN, HOME, AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, AWS_SESSION_TOKEN, AWS_DEFAULT_REGION, AWS_ENDPOINT
