Td MCP Server

MCP server for Treasure Data - Query and interact with TD through Model Context Protocol

Local serverstdio

What is the Td MCP Server?

Td mcp server connects Td to AI assistants that speak the Model Context Protocol. MCP server for Treasure Data - Query and interact with TD through Model Context Protocol.

What Td does

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

Key capabilities

  • 🔍 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

Practical notes

  • Maintained by treasure-data.

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

ToolWhat it does
sqlstring, required): SQL statement to execute
limitnumber, optional): Maximum bytes to retrieve (default: 1MB)
td_intervaltime, '-1h/now') - Last hour
td_time_rangetime, '2024-01-01', '2024-01-31') - Specific date range

How to install the Td MCP Server

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

From the project documentation. Replace placeholders and example paths before connecting.

Configuration

VariableDescriptionRequired
TD_API_KEYDeclared in the maintainer’s client configuration.Yes
TD_SITEDeclared in the maintainer’s client configuration.Optional
TD_ENABLE_UPDATESDeclared in the maintainer’s client configuration.Optional
TD_DATABASEDeclared in the maintainer’s client configuration.Optional

Frequently asked questions

MCP server for Treasure Data - Query and interact with TD through Model Context Protocol Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.