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

| Variable | Default | Description | |----------|---------|-------------| | TD_API_KEY | (required) | API key | | TD_SITE | us01 | Region: us01, jp01, eu01, ap02, ap03 | | TD_DATABASE | - | Default database | | TD_ENABLE_UPDATES | false | Enable write operations |

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