ethpandaops
- 18 skills
- 0 followers
- 15 hours ago last updated
- ▌ Optimize Model 2 · ethpandaops bundleDeeply 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.
- ▌ Eip · ethpandaops bundleAnalyze Ethereum Improvement Proposals by fetching content and optionally deep-diving into implementations
- ▌ Kurtosis Ethereum · ethpandaops bundleRun Ethereum multi-client devnets using Kurtosis and the ethpandaops/ethereum-package. Use for spinning up local devnets, syncing public testnets, validating cross-client interop, testing fork transitions, shadowforks, running assertoor checks, debugging CL/EL client interactions, or verifying new feature implementations across multiple consensus and execution clients.
- ▌ Visualize Any Data · ethpandaops bundleLearn how to visualize data in a sustainable, accurate, and theme aware way.
- ▌
- ▌ Create Investigation · ethpandaopsCreate a new Ethereum data investigation page in the notebooks repo. Use when the user wants to add a new investigation, analysis, or research page that queries Xatu/ClickHouse data and visualizes findings with charts.
- ▌ Create Instructional Image · ethpandaopsCreate an ethPandaOps-style instructional/explainer image for Ethereum concepts. Generates clean whiteboard-aesthetic diagrams following the ethPandaOps/investigations visual style guide.
- ▌ Optimize Model · ethpandaops bundleDeeply 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.
- ▌ Panda · ethpandaopsQuery Ethereum devnet analytics (Xatu ClickHouse chain events, container logs in ClickHouse otel_logs, Prometheus, beacon/exec nodes) by running Python in a sandboxed environment via the panda CLI. Scoped to this devnet.
- ▌ Faucet · ethpandaopsFund an account on this Ethereum devnet using the devnet's PoW faucet (powfaucet).
- ▌ Join Devnet · ethpandaopsHelp a user join this Ethereum devnet: hand them enodes/bootnodes, genesis + chain config, and a ready-to-run client command.
- ▌ Query · ethpandaopsQuery Ethereum network data via ethpandaops CLI or MCP server. Use when analyzing blockchain data, block timing, attestations, validator performance, network health, or infrastructure metrics. Provides access to ClickHouse (blockchain data and OTel logs), Prometheus (metrics), and Dora (explorer APIs).
- ▌ Self Play · ethpandaopsRun schema probing self-play loop to find and fix ClickHouse schema ambiguity in the panda repo. Use when the user wants to improve query reliability by finding where the agent picks different tables for the same question.
- ▌ Install MCP · ethpandaopsInstall panda as an MCP server in AI coding assistants (Claude Code, Claude Desktop, Cursor). Use when setting up panda, configuring MCP, or connecting AI tools to panda. Triggers on: install mcp, setup mcp, configure mcp, register mcp, add mcp server.
- ▌ Investigate · ethpandaopsDebug Ethereum devnet or network issues. Use when diagnosing finality delays, network splits, offline nodes, client bugs, or general network health problems. Works for both local Kurtosis devnets and live public devnets.
- ▌ Create Module · ethpandaopsAdd a new datasource module to ethpandaops/panda. Triggers on: add module, new module, create module, add plugin, new plugin, create plugin, add datasource.
- ▌ Install Panda · ethpandaopsInstall and set up panda from scratch. Use when the user wants to install panda, get started with panda, or set up their environment. Triggers on: install panda, setup panda, get started, getting started.
- ▌ Create Runbook · ethpandaopsAuthor a reusable runbook, or extract one from a completed investigation, following this repo's runbook standard. Use whenever a multi-step procedure, diagnosis, or recipe should be captured so future agents can reuse it.