parent_segment_sql
Get the SQL statement for a parent segment.
How to use it
Project documentation lists parent_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-serverOther tools in Td MCP Server (22)
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.
List all tasks within an attempt with their execution status.
Get details of a specific parent segment.
Get detailed information about a specific segment, including its rules and metadata.
Get all attempts for a specific session.
Retrieve logs for a specific task within an attempt.
Request cancellation of a running attempt.
List all activations (syndications) for a specific segment.
List all databases in your Treasure Data account.
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.
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.
Get the SQL statement for a segment with filtering conditions applied to the parent segment.
Switch the current database context for subsequent queries.