td-mcp-server
Verified Safeby treasure-data
Overview
Provides a secure, controlled interface for AI assistants to query and interact with Treasure Data (Trino SQL, CDP, and Workflow APIs) via the Model Context Protocol.
Installation
npx @treasuredata/mcp-serverEnvironment Variables
- TD_API_KEY
- TD_SITE
- TD_ENABLE_UPDATES
- TD_DATABASE
- TD_LLM_API_BASE
- TD_DEFAULT_PROJECT_NAME
- TD_DEFAULT_AGENT_ID
- TD_MCP_LOG_TO_CONSOLE
Security Notes
The server is designed with security in mind, defaulting to read-only operations unless 'TD_ENABLE_UPDATES=true' is explicitly set. It includes a `QueryValidator` to enforce read/write restrictions and prevent SQL injection through identifier/string escaping. All SQL queries are subjected to validation, including checking for write operations within 'WITH' clauses in read-only mode. API keys are masked in all error messages. An `AuditLogger` tracks all query executions (success/failure, query type, duration, affected rows) for monitoring. Input schemas for CDP tools are validated using Zod. Network communication with Treasure Data APIs uses HTTPS. Overall, strong security practices are evident.
Similar Servers
DBchat
Transforms a database into an intelligent conversational partner, enabling natural language queries, instant answers, and data visualizations via MCP clients.
powerdrill-mcp
An MCP server for AI-driven data analysis by providing tools to interact with Powerdrill datasets using natural language questions and managing data sources, jobs, and sessions.
cratedb-mcp
CrateDB MCP Server enables natural-language Text-to-SQL and documentation retrieval for CrateDB database clusters, bridging AI assistants with database interaction.
DatabaseMcpServer
Provides a robust and secure database access layer for AI assistants, supporting 19 types of databases with single-instance multi-database dynamic switching and over 50 tools for data and schema management.