Loading...
Loading...
ByteHouse Slow Query Analysis and Performance Optimization Tool, used to identify and analyze slow queries, provide query performance optimization suggestions, view query execution plans, and analyze query historical trends. Use this Skill when you need to identify and analyze slow queries in ByteHouse database, get query performance optimization suggestions, view query execution plans, or analyze query historical trends.
npx skill4agent add bytedance/agentkit-samples byted-bytehouse-slow-query"ByteHouse" - Volcano Engine Cloud-Native Data Warehouse: Fast, Stable, Secure, Easy to UseThis Skill is based on ByteHouse MCP Server and provides comprehensive slow query analysis and performance optimization capabilities
/root/.local/bin/uvbytehouse-mcpbytehouse-mcpbytehouse-mcpbytehouse-mcpbytehouse-mcpexport BYTEHOUSE_HOST="<ByteHouse-host>"
export BYTEHOUSE_PORT="<ByteHouse-port>"
export BYTEHOUSE_USER="<ByteHouse-user>"
export BYTEHOUSE_PASSWORD="<ByteHouse-password>"
export BYTEHOUSE_SECURE="true"
export BYTEHOUSE_VERIFY="true"cd /root/.openclaw/workspace/skills/bytehouse-slow-query
# Set environment variables first (reuse bytehouse-mcp configuration)
export BYTEHOUSE_HOST="<ByteHouse-host>"
export BYTEHOUSE_PORT="<ByteHouse-port>"
export BYTEHOUSE_USER="<ByteHouse-user>"
export BYTEHOUSE_PASSWORD="<ByteHouse-password>"
export BYTEHOUSE_SECURE="true"
export BYTEHOUSE_VERIFY="true"
# Run slow query analysis
uv run slow_query_analyzer.pyoutput/slow_queries_{timestamp}.jsonquery_stats_{timestamp}.jsonoptimization_suggestions_{timestamp}.json{
"analysis_time": "2026-03-12T21:00:00",
"total_queries": 10000,
"slow_queries": 150,
"top_slow_queries": [
{
"query_id": "query-12345",
"query_text": "SELECT * FROM large_table WHERE ...",
"duration_ms": 15000,
"start_time": "2026-03-12T20:55:00",
"read_rows": 1000000,
"read_bytes": 104857600
}
]
}