MCP 模型上下文协议：从原理到实践，AI 时代的统一连接标准

# MCP Server端代码：SQLite数据库连接器
from typing import Any
import sqlite3
from mcp.server import Server, types
server = Server("sqlite-connector")
@server.list_tools()
async def list_tools() -> list[types.Tool]:
    return [
        types.Tool(
            name="query-db",
            description="Execute SQL query on local SQLite database",
            inputSchema={
                "type": "object",
                "properties": {
                    "query": {"type": "string", "description": "SQL query to execute"},
                },
                "required": ["query"]
            }
        )
    ]
@server.call_tool()
async def query_database(name: str, arguments: dict) -> Any:
    if name != "query-db":
        raise ValueError("Unknown tool")
    query = arguments["query"]
    conn = sqlite3.connect('example.db')
    cursor = conn.cursor()
    cursor.execute(query)
    if query.strip().lower().startswith("select"):
        return cursor.fetchall()
    else:
        conn.commit()
        return {"status": "success", "rows_affected": cursor.rowcount}

// MCP Client端代码：GitHub操作集成
import { Client, StdioClientTransport } from '@modelcontextprotocol/client';
async function setupGitHubClient() {
    const transport = new StdioClientTransport({
        command: 'python',
        args: ['github_mcp_server.py']
    });
    const client = new Client({
        name: "github-client",
        version: "1.0.0"
    });
    await client.connect(transport);
    return client;
}
// 创建Pull Request的示例
async function createPR(client: Client, params: {
    repo: string;
    title: string;
    body: string;
    head: string;
    base: string;
}) {
    return await client.request({
        method: "tools/call",
        params: {
            tool: "github-create-pr",
            arguments: params
        }
    });
}

# 快速体验MCP Inspector调试工具
npx @modelcontextprotocol/inspector