pnpm add @modelcontextprotocol/sdk

{
  "mcpServers": {
    "clickhouse": {
      "command": "npx",
      "args": ["-y", "@dotdo/mcp-server"],
      "env": {
        "DO_API_KEY": "your-api-key"
      }
    }
  }
}

{
  "name": "clickhouse/invoke",
  "description": "Cloud-native analytical database",
  "inputSchema": {
    "type": "object",
    "properties": {
      "operation": {
        "type": "string",
        "description": "Operation to perform"
      },
      "parameters": {
        "type": "object",
        "description": "Operation parameters"
      }
    },
    "required": ["operation"]
  }
}

// ~/Library/Application Support/Claude/claude_desktop_config.json
{
  "mcpServers": {
    "clickhouse": {
      "command": "npx",
      "args": ["-y", "@dotdo/mcp-server", "--tool=clickhouse"],
      "env": {
        "DO_API_KEY": "undefined"
      }
    }
  }
}

# Custom GPT configuration
tools:
  - type: mcp
    server: clickhouse
    operations:
      - invoke
      - query
      - execute

import { Client } from '@modelcontextprotocol/sdk/client/index.js'
import { StdioClientTransport } from '@modelcontextprotocol/sdk/client/stdio.js'

const transport = new StdioClientTransport({
  command: 'npx',
  args: ['-y', '@dotdo/mcp-server', '--tool=clickhouse'],
})

const client = new Client(
  {
    name: 'clickhouse-client',
    version: '1.0.0',
  },
  {
    capabilities: {},
  }
)

await client.connect(transport)

// Call tool
const result = await client.callTool({
  name: 'clickhouse/invoke',
  arguments: {
    operation: 'clickhouse',
    parameters: {},
  },
})

{
  "tools": [
    {
      "name": "clickhouse/invoke",
      "description": "Invoke clickhouse.do",
      "inputSchema": {
        /* ... */
      }
    },
    {
      "name": "clickhouse/query",
      "description": "Query clickhouse.do resources",
      "inputSchema": {
        /* ... */
      }
    },
    {
      "name": "clickhouse/status",
      "description": "Check clickhouse.do status",
      "inputSchema": {
        /* ... */
      }
    }
  ]
}

{
  "resources": [
    {
      "uri": "clickhouse://config",
      "name": "Clickhouse Configuration",
      "mimeType": "application/json"
    },
    {
      "uri": "clickhouse://docs",
      "name": "Clickhouse Documentation",
      "mimeType": "text/markdown"
    }
  ]
}

{
  "prompts": [
    {
      "name": "clickhouse-quick-start",
      "description": "Quick start guide for clickhouse.do",
      "arguments": []
    },
    {
      "name": "clickhouse-best-practices",
      "description": "Best practices for clickhouse.do",
      "arguments": []
    }
  ]
}

// AI model calls tool via MCP
mcp call clickhouse/query

// Call with parameters
await mcp.callTool('clickhouse/invoke', {
  operation: 'process',
  parameters: {
    // Operation-specific parameters
  },
  options: {
    timeout: 30000,
  },
})

try {
  const result = await mcp.callTool('clickhouse/invoke', {
    operation: 'process',
  })
  return result
} catch (error) {
  if (error.code === 'TOOL_NOT_FOUND') {
    console.error('Clickhouse tool not available')
  } else {
    throw error
  }
}

// AI agent uses clickhouse.do in workflow
const workflow = {
  steps: [
    {
      tool: 'clickhouse/invoke',
      operation: 'analyze',
      input: 'user-data',
    },
    {
      tool: 'clickhouse/process',
      operation: 'transform',
      input: 'analysis-result',
    },
  ],
}

User: "I need to process this data"

AI: "I'll use the clickhouse tool to:
1. Validate the data format
2. Process it through clickhouse.do
3. Return the results

Let me start..."

[Calls: mcp call clickhouse/query]

import { Server } from '@modelcontextprotocol/sdk/server/index.js'
import { StdioServerTransport } from '@modelcontextprotocol/sdk/server/stdio.js'

const server = new Server(
  {
    name: 'clickhouse-server',
    version: '1.0.0',
  },
  {
    capabilities: {
      tools: {},
      resources: {},
      prompts: {},
    },
  }
)

// Register tool
server.setRequestHandler('tools/call', async (request) => {
  if (request.params.name === 'clickhouse/invoke') {
    // Handle clickhouse.do operation
    return {
      content: [
        {
          type: 'text',
          text: JSON.stringify(result),
        },
      ],
    }
  }
})

const transport = new StdioServerTransport()
await server.connect(transport)