td-mcp

TD MCP server setup for Claude Code integration. Covers installation, regional configuration (us01, jp01, eu01), available tools (query, list_databases, describe_table), and write mode.

⭐3stars🔀4forks📁View on GitHub🕐Updated Dec 31, 2025⬇️1downloads

When & Why to Use This Skill

This Claude skill integrates Treasure Data's Customer Data Platform (CDP) directly into Claude Code, enabling seamless interaction with cloud data warehouses. It allows users to perform data exploration, execute SQL queries, and manage CDP segments or workflows using natural language, significantly streamlining the data analysis and management process for developers and data engineers.

Use Cases

  • Data Schema Exploration: Quickly list databases, tables, and describe schemas to understand data structures without leaving the terminal or switching to a SQL client.
  • Ad-hoc SQL Analysis: Execute read-only or write-enabled SQL queries to fetch top records, aggregate metrics, or update data directly through Claude.
  • CDP Operations: Access and manage parent segments, activations, and segment-specific SQL for marketing and customer data operations.
  • Workflow Monitoring: List and track Treasure Data projects, workflows, and sessions to monitor the status of data pipelines and automated tasks.
nametd-mcp
descriptionTD MCP server setup for Claude Code integration. Covers installation, regional configuration (us01, jp01, eu01), available tools (query, list_databases, describe_table), and write mode.

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