# Optimize Model

> 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.

- Skill: `ethpandaops/optimize-model` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add ethpandaops/optimize-model`
- Raw SKILL.md: https://api.skillmd.com/api/skills/ethpandaops/optimize-model/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: ethpandaops (https://skillmd.com/u/ethpandaops)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/ethpandaops/optimize-model

---


# Optimize Model (Agent Skills Adapter)

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

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