Treasure Data MCP Server

MCP (Model Context Protocol) server for Treasure Data, enabling AI assistants to query and interact with Treasure Data through a secure, controlled interface.

🚀 Public Preview

This MCP server is currently in a public preview. We're excited for you to try it out and welcome your feedback to help us improve the service.

Please note: During this preview period, use of the server is free. However, we plan to introduce a usage-based pricing model in the future, which will be based on the number of queries issued. We will provide ample notice and detailed pricing information before any charges are implemented.

Your feedback during this phase is invaluable and will help us shape the future of this tool. Thank you for being an early adopter!

Features

• 🔍 Query databases, tables, and schemas through information_schema
• 📊 Execute SQL queries with automatic result limiting for LLM contexts
• 🔒 Security-first design with read-only mode by default
• 🌍 Multi-site support (US, JP, EU, AP regions)
• 🚀 Zero-install execution via npx
• 🎯 CDP (Customer Data Platform) integration for segment and activation management (Experimental)
• 🔄 Workflow monitoring and control - view execution status, logs, and retry failed workflows
• 📝 Comprehensive audit logging for all operations

Prerequisites

Node.js Installation

This MCP server requires Node.js version 18.0.0 or higher. If you don't have Node.js installed:

1. Download Node.js from nodejs.org

   • Choose the LTS (Long Term Support) version
   • The installer includes npm and npx

2. Verify installation by running:

node --version  # Should show v18.0.0 or higher
npx --version   # Included with npm 5.2+

3. Alternative installation methods:
   • macOS: brew install node (using Homebrew)
   • Windows: Use the installer from nodejs.org or winget install OpenJS.NodeJS
   • Linux: Use your distribution's package manager or NodeSource repositories

Installation

Using npx (recommended)

No installation needed! Configure your MCP tool to run @treasuredata/mcp-server directly via npx:

npx @treasuredata/mcp-server

What is npx? npx is a package runner that comes with npm 5.2+. It downloads and runs packages without installing them globally, ensuring you always use the latest version.

Global installation

If you prefer a traditional installation:

npm install -g @treasuredata/mcp-server

Configuration

Add to your MCP client configuration (e.g., Claude Desktop):

{
  "mcpServers": {
    "treasuredata": {
      "command": "npx",
      "args": ["@treasuredata/mcp-server"],
      "env": {
        "TD_API_KEY": "your_api_key",
        "TD_SITE": "us01",
        "TD_ENABLE_UPDATES": "false",
        "TD_DATABASE": "sample_datasets"
      }
    }
  }
}

Configuration Options

• TD_API_KEY (required): Your Treasure Data API key
• TD_SITE (optional): Region endpoint - us01 (default), jp01, eu01, ap02, ap03, dev
• TD_ENABLE_UPDATES (optional): Enable write operations (execute tool) - false (default), true
• TD_DATABASE (optional): Default database for queries (e.g., sample_datasets)

Claude Code Integration

Claude Code provides built-in support for MCP servers through the claude mcp add command. To use this MCP server with Claude Code:

claude mcp add td -e TD_API_KEY=$TD_API_KEY -- npx @treasuredata/mcp-server

This command:

• Adds the server with the name "td"
• Sets the TD_API_KEY environment variable to your API key value
• Configures Claude Code to use npx @treasuredata/mcp-server (always uses latest version)

Additional Configuration

You can also specify additional environment variables:

claude mcp add td \
  -e TD_API_KEY=$TD_API_KEY \
  -e TD_SITE=us01 \
  -e TD_DATABASE=sample_datasets \

... [View full README on GitHub](https://github.com/treasure-data/td-mcp-server#readme)