optimize-model

Name: Optimize Model
Author: ethpandaops

// Deeply optimize a Xatu CBT transformation model query using live ClickHouse evidence. Use when performance analysis is requested for `models/transformations/*.sql`, including dependency rendering, schema introspection (`SHOW CREATE` with `_local` table checks), cache-aware benchmarking, and high-impact recommendations without editing model files.

Run Skill in Manus

$ git log --oneline --stat

stars:0

forks:1

updated:February 27, 2026 at 07:15

File Explorer

3 files

SKILL.md

readonly

name	optimize-model
description	Deeply optimize a Xatu CBT transformation model query using live ClickHouse evidence. Use when performance analysis is requested for `models/transformations/*.sql`, including dependency rendering, schema introspection (`SHOW CREATE` with `_local` table checks), cache-aware benchmarking, and high-impact recommendations without editing model files.
compatibility	Requires Bash 3.2+, Python 3, jq, HTTP access to ClickHouse on port 8123, and internet access for web research.

Optimize Model (Agent Skills Adapter)

Canonical workflow: ../../.claude/skills/optimize-model/SKILL.md.

Shared resources: ./scripts/, ./references/.

related-skills.json

same repository

optimize-model.md

from "ethpandaops/xatu-cbt"

Deeply optimize a Xatu CBT transformation model query using live ClickHouse evidence. Use when the user wants performance analysis (not code edits) for `models/transformations/*.sql`, including dependency rendering, schema introspection, benchmark runs, and high-impact recommendations.

2026-02-270

package.json