Claude Code MCP 集成实战：连接外部服务、数据库与 API 的完整教程

# 交互式添加
claude mcp add

# 或直接指定
claude mcp add --name github --command "npx @modelcontextprotocol/server-github"

{
  "mcpServers": {
    "github": {
      "type": "stdio",
      "command": "npx",
      "args": ["@modelcontextprotocol/server-github"],
      "env": {
        "GITHUB_PERSONAL_ACCESS_TOKEN": "your_token"
      }
    },
    "postgres": {
      "type": "stdio",
      "command": "npx",
      "args": ["@modelcontextprotocol/server-postgres", "postgresql://localhost/mydb"]
    },
    "pipedream": {
      "type": "http",
      "url": "https://mcp.pipedream.net/v2"
    }
  }
}

{
  "filesystem": {
    "type": "stdio",
    "command": "npx",
    "args": ["@modelcontextprotocol/server-filesystem", "/path/to/allowed/dir"]
  }
}

{
  "github": {
    "type": "stdio",
    "command": "npx",
    "args": ["@modelcontextprotocol/server-github"],
    "env": { "GITHUB_PERSONAL_ACCESS_TOKEN": "ghp_..." }
  }
}

{
  "postgres": {
    "type": "stdio",
    "command": "npx",
    "args": ["@modelcontextprotocol/server-postgres", "postgresql://user:pass@localhost/db"]
  }
}

{
  "brave-search": {
    "type": "stdio",
    "command": "npx",
    "args": ["@modelcontextprotocol/server-brave-search"],
    "env": { "BRAVE_API_KEY": "BSA..." }
  }
}

{
  "slack": {
    "type": "stdio",
    "command": "npx",
    "args": ["@modelcontextprotocol/server-slack"],
    "env": { "SLACK_BOT_TOKEN": "xoxb-..." }
  }
}

# 配置好 postgres MCP 后
claude
> 查询 orders 表，分析过去 30 天的销售趋势，找出下单量最高的时间段和最受欢迎的商品类别

> 读取 #234 Issue 的内容，在 feature/fix-234 分支上实现需求，然后创建 PR 并关联这个 Issue

> 检查我的邮件，找出过去一周未回复的客户邮件，为每封写一个草稿回复

claude mcp list          # 查看已配置的服务器
claude mcp add          # 添加服务器
claude mcp remove name  # 删除服务器
claude mcp get name     # 查看单个配置