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

Installing the td mcp server

The server is distributed via npm as @treasuredata/mcp-server, so most clients can run it without a manual build step. Add it to your MCP client's configuration and restart the client to pick it up — the copy-paste configs for Claude Desktop, Claude Code and Cursor are on this page.

Configuration

Before the server will start you need to supply 4 environment variables: TD_API_KEY, TD_SITE, TD_ENABLE_UPDATES, TD_DATABASE. Keep credentials in your client's env block or a secrets manager rather than committing them.

Where it fits

Monitoring servers replace the paste-the-stack-trace ritual with an assistant that reads the real event, with all its surrounding context intact. Td sits in that group. Worth comparing against the other monitoring security servers in this directory before you commit to one, since several overlap in scope but differ sharply in setup cost and permissions.

Practical notes

  • This server runs locally, so it operates with whatever access your machine and its credentials already have. Scope that deliberately rather than by default.
  • It will not start until its required credentials are present, so set those before wondering why the tools never appear.
  • Maintained by treasure-data.
  • MCP clients ask for confirmation before each tool call by default. Keep that on while you learn what the td mcp server actually does with your data.
  • Every entry in this directory is reviewed by hand before it goes live, and details are checked against the project's own documentation.

How to install the Td MCP server

{
  "mcpServers": {
    "td": {
      "command": "npx",
      "args": ["-y", "@treasuredata/mcp-server"],
      "env": {
        "TD_API_KEY": "your-value",
        "TD_SITE": "your-value",
        "TD_ENABLE_UPDATES": "your-value",
        "TD_DATABASE": "your-value"
      }
    }
  }
}

Add to claude_desktop_config.json, then restart Claude Desktop.

Configuration

VariableDescriptionRequired
TD_API_KEYCredential the server authenticates with.Yes
TD_SITEConfiguration value read at startup.Optional
TD_ENABLE_UPDATESConfiguration value read at startup.Optional
TD_DATABASEConfiguration value read at startup.Optional

Frequently asked questions

It connects Td to MCP-compatible AI assistants such as Claude and Cursor. Instead of copying data back and forth by hand, the assistant works with Td directly.