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.
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.
| name | td-mcp |
|---|---|
| description | 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. |
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 databaseslist_tables- List tables in databasedescribe_table- Show table schemacurrent_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_segmentlist_segments,get_segmentlist_activationsparent_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'