Td MCP

Treasure Data MCP Server

Setup

export TD_API_KEY="your_api_key"

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

Requires Node.js 18+.

Configuration

Regional Setup:

# Tokyo
claude mcp add td -e TD_API_KEY=$TD_API_KEY -e TD_SITE=jp01 -- npx @treasuredata/mcp-server

# EU
claude mcp add td -e TD_API_KEY=$TD_API_KEY -e TD_SITE=eu01 -- npx @treasuredata/mcp-server

Enable Write Mode:

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

Available Tools

Data Exploration

• list_databases - List all databases
• list_tables - List tables in database
• describe_table - Show table schema
• current_database / use_database - Database context

Query Execution

• query - Read-only SQL (default 40 row limit, max 10,000)
• execute - Write operations (requires TD_ENABLE_UPDATES=true)

CDP (Experimental)

• list_parent_segments, get_parent_segment
• list_segments, get_segment
• list_activations
• parent_segment_sql, segment_sql

Workflows (Experimental)

• list_projects, list_workflows, list_sessions

Usage in Claude Code

"List all my TD databases"
"Describe the nasdaq table"
"Query top 10 symbols from nasdaq"
"Show yesterday's events from user_events"

Multiple Environments

claude mcp add td-prod -e TD_API_KEY=$TD_PROD_KEY -- npx @treasuredata/mcp-server
claude mcp add td-staging -e TD_API_KEY=$TD_STAGING_KEY -e TD_ENABLE_UPDATES=true -- npx @treasuredata/mcp-server

Verify Installation

claude mcp list   # Should show 'td'

Resources

• https://github.com/treasure-data/td-mcp-server