td-mcp-server

treasure-data/td-mcp-server

3.3

If you are the rightful owner of td-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

Treasure Data MCP Server provides a secure interface for AI assistants to interact with Treasure Data.

The Treasure Data MCP Server is a Model Context Protocol server designed to facilitate secure and controlled interactions between AI assistants and Treasure Data. Currently in public preview, this server allows users to query databases, execute SQL queries, and manage workflows through a read-only interface by default. It supports multiple regions and integrates with Treasure Data's Customer Data Platform (CDP) for segment and activation management. The server is easy to set up with zero-install execution via npx, making it accessible for developers and data analysts. As the service evolves, a usage-based pricing model will be introduced, but it remains free during the preview period.

Features

  • 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)
  • CDP integration for segment and activation management (Experimental)

Usages

usage with Claude Desktop

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

Tools

  1. list_databases

    List all databases in your Treasure Data account.

  2. list_tables

    List all tables in a specific database.

  3. describe_table

    Get schema information for a specific table.

  4. query

    Execute read-only SQL queries.

  5. execute

    Execute write operations (requires TD_ENABLE_UPDATES=true).