Query contract state with SQL
Call an EVM contract function from SQL, pin the read to one block, and use a column as the function argument.
Open guideRunnable EVM workflows
Each guide is a runnable notebook for a complete workflow. Run it as written, then change the SQL or inputs.
Open a linked function when you need its exact signatures, argument types, return values, or examples.
Guides
Analyze ERC-20 transfers for a UTC day
Fetch ERC-20 Transfer logs for one UTC day and query the decoded rows with SQL.
Open guideCompare Uniswap V3 and V4 routes
Compare Uniswap V3, V4, and split ETH → USDC routes at one pinned block. Simulate family leaders, rank after gas, and inspect every check and rejection reason.
Open guide