Dev MCP 服务测评：开启AI与工具无缝连接的未来

# 1. 克隆项目仓库
git clone https://github.com/example/mcp-server.git
cd mcp-server

# 2. 安装依赖
npm install

# 3. 构建项目
npm run build

# 4. 配置环境变量
$env:API_BASE_URL="https://your-api-endpoint.com"
$env:API_TOKEN="your-secret-token"

# 5. 开发模式运行
npm run dev

# 1. 克隆项目
git clone https://github.com/example/mcp-server.git
cd mcp-server

# 2. 安装依赖
npm install

# 3. 设置环境变量
export API_BASE_URL="https://your-api-endpoint.com"
export API_TOKEN="your-secret-token"

# 4. 构建并运行
npm run build && npm start

# 1. 使用npx直接运行（推荐新手）
npx --yes example-mcp-server

# 2. 或从源码安装
git clone https://github.com/example/mcp-server.git
cd mcp-server
npm install
npm run build

# 3. 设置为系统服务（高级用户）
sudo cp mcp-service.service /etc/systemd/system/
sudo systemctl daemon-reload
sudo systemctl enable mcp-service

{
  "mcpServers": {
    "dev-mcp-server": {
      "command": "npx",
      "args": ["--yes", "dev-mcp-server"],
      "env": {
        "API_BASE_URL": "https://your-api-endpoint.com",
        "API_TOKEN": "your-secret-token"
      }
    }
  }
}

// database-mcp-server.js
const { McpServer } = require("@modelcontextprotocol/sdk");
const { Pool } = require("pg");

const server = new McpServer({
  name: "ProjectDatabase",
  version: "1.0.0"
});

// 数据库连接池
const pool = new Pool({
  host: process.env.DB_HOST || "localhost",
  port: process.env.DB_PORT || 5432,
  database: process.env.DB_NAME || "project_management",
  user: process.env.DB_USER || "postgres",
  password: process.env.DB_PASSWORD || "postgres"
});

// 工具：获取项目统计
server.tool(
  "get_project_stats",
  "获取项目的综合统计信息，包括问题数量、完成率和成员工作量",
  {
    projectId: {
      type: "string",
      description: "项目ID"
    },
    timeRange: {
      type: "string",
      description: "时间范围（7d、30d、all）",
      enum: ["7d", "30d", "all"],
      default: "all"
    }
  },
  async ({ projectId, timeRange }) => {
    try {
      // 构建时间过滤条件
      let dateFilter = "";
      if (timeRange !== "all") {
        const days = parseInt(timeRange);
        dateFilter = `AND created_at >= NOW() - INTERVAL '${days} days'`;
      }
      
      // 查询项目统计
      const query = `
        SELECT 
          p.name as project_name,
          COUNT(i.id) as total_issues,
          SUM(CASE WHEN i.status = 'completed' THEN 1 ELSE 0 END) as completed_issues,
          AVG(CASE WHEN i.status = 'completed' THEN 1.0 ELSE 0 END) * 100 as completion_rate,
          COUNT(DISTINCT i.assignee_id) as active_members
        FROM projects p
        LEFT JOIN issues i ON p.id = i.project_id
        WHERE p.id = $1 ${dateFilter}
        GROUP BY p.id, p.name
      `;
      
      const result = await pool.query(query, [projectId]);
      
      if (result.rows.length === 0) {
        return {
          content: [{
            type: "text",
            text: `未找到项目 ${projectId} 的统计信息`
          }]
        };
      }
      
      const stats = result.rows[0];
      
      return {
        content: [{
          type: "text",
          text: `项目统计报告：${stats.project_name}
          
📊 问题统计：
• 总问题数：${stats.total_issues}
• 已完成：${stats.completed_issues}
• 完成率：${stats.completion_rate.toFixed(1)}%

👥 团队情况：
• 活跃成员：${stats.active_members}人

💡 分析建议：${stats.completion_rate > 80 ? "项目进展良好" : "需要关注未完成任务"}`
        }]
      };
      
    } catch (error) {
      return {
        content: [{
          type: "text",
          text: `查询失败：${error.message}`
        }]
      };
    }
  }
);

// 工具：搜索问题
server.tool(
  "search_issues",
  "根据关键词搜索项目问题",
  {
    projectId: {
      type: "string",
      description: "项目ID"
    },
    keyword: {
      type: "string",
      description: "搜索关键词"
    },
    maxResults: {
      type: "number",
      description: "最大返回结果数",
      default: 10
    }
  },
  async ({ projectId, keyword, maxResults }) => {
    try {
      const query = `
        SELECT 
          id, title, status, priority, assignee_id,
          created_at, updated_at
        FROM issues 
        WHERE project_id = $1 
          AND (title ILIKE $2 OR description ILIKE $2)
        ORDER BY 
          CASE priority 
            WHEN 'high' THEN 1
            WHEN 'medium' THEN 2  
            WHEN 'low' THEN 3
            ELSE 4
          END,
          updated_at DESC
        LIMIT $3
      `;
      
      const result = await pool.query(query, [
        projectId, 
        `%${keyword}%`,
        maxResults
      ]);
      
      if (result.rows.length === 0) {
        return {
          content: [{
            type: "text",
            text: `未找到包含"${keyword}"的问题`
          }]
        };
      }
      
      const issuesList = result.rows.map(issue => 
        `• [${issue.status.toUpperCase()}] ${issue.title} (优先级:${issue.priority})`
      ).join('\n');
      
      return {
        content: [{
          type: "text",
          text: `找到 ${result.rows.length} 个相关问题：\n\n${issuesList}`
        }]
      };
      
    } catch (error) {
      return {
        content: [{
          type: "text", 
          text: `搜索失败：${error.message}`
        }]
      };
    }
  }
);

// 启动服务器
async function main() {
  try {
    await pool.connect();
    console.log("数据库连接成功");
    
    await server.start();
    console.log("MCP服务器运行中...");
  } catch (error) {
    console.error("启动失败:", error);
    process.exit(1);
  }
}

process.on('SIGINT', async () => {
  await pool.end();
  process.exit(0);
});

main();