tdwm-mcp
If you are the rightful owner of tdwm-mcp 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.
The Teradata Workload Management MCP Server provides tools for managing and orchestrating workloads, queues, sessions, and resources in a Teradata environment.
The Teradata Workload Management MCP Server is a Model Context Protocol (MCP) server implementation designed to facilitate interaction and orchestration of workload management (TDWM) in Teradata environments. It offers a comprehensive suite of tools for managing workloads, queues, sessions, and system resources, enabling administrators to optimize performance and ensure efficient resource utilization. The server supports various operations such as listing workloads, monitoring system resources, managing delayed requests, and handling user sessions. It is a versatile solution for maintaining the health and efficiency of Teradata systems.
Features
- Comprehensive workload management tools for summarizing and listing workloads.
- Queue management capabilities for handling delayed requests and managing delay queues.
- Session management tools for monitoring and controlling user sessions.
- Resource monitoring tools for tracking system resources and AMP load.
- Support for integration with Claude Desktop for streamlined operations.
Tools
show_tdwm_summary
Shows workloads summary information
list_WD
Lists workloads (WD)
list_active_WD
Lists active workloads (WD)
show_trottle_statistics
Shows throttle statistics for different components
list_delayed_request
Lists all of the delayed queries
display_delay_queue
Displays delay queue by type
release_delay_queue
Releases a request or utility session in the queue
abort_delayed_request
Aborts a delayed request on a specific session
show_sessions
Shows current sessions
show_sql_steps_for_session
Shows SQL steps for a session
show_sql_text_for_session
Shows SQL text for a session
abort_sessions_user
Aborts sessions for a user
identify_blocking
Identifies blocking users
show_physical_resources
Monitors system resources
monitor_amp_load
Monitors AMP load
monitor_awt
Monitors AWT (Amp Worker Task) resources
monitor_config
Monitors virtual config
list_utility_stats
Lists statistics for utility use on the system
