EN 日本語中文

segment_sql

MCP tool from Td MCP Server by treasure-data

Get the SQL statement for a segment with filtering conditions applied to the parent segment.

How to use it

Project documentation lists segment_sql for the Td MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Td MCP Server

$npx @treasuredata/mcp-server

FULL TD MCP SERVER LISTING

Other tools in Td MCP Server (22)

current_database

Get the current database context being used for queries.

Get schema information for a specific table.

Execute write operations (UPDATE, INSERT, DELETE, etc.) - requires TDENABLEUPDATES=true.

get_attempt_tasks

List all tasks within an attempt with their execution status.

get_parent_segment

Get details of a specific parent segment.

Get detailed information about a specific segment, including its rules and metadata.

get_session_attempts

Get all attempts for a specific session.

Retrieve logs for a specific task within an attempt.

Request cancellation of a running attempt.

list_activations

List all activations (syndications) for a specific segment.

List all databases in your Treasure Data account.

list_parent_segments

List all parent segments in your CDP account.

List all workflow projects.

List all segments under a specific parent segment.

List workflow execution sessions with filtering options.

List all tables in a specific database.

List workflows, optionally filtered by project name.

parent_segment_sql

Get the SQL statement for a parent segment.

Execute read-only SQL queries (SELECT, SHOW, DESCRIBE).

Retry a specific attempt with resume capabilities.

Retry a session from the beginning or a specific task.

Switch the current database context for subsequent queries.