Query any EVM chain with SQL

The open-source alternative to commercial blockchain indexers. Sync any EVM chain into a local SQLite database and explore blocks, transactions, and logs with plain SQL. No infrastructure, no vendor lock-in, no APIs - just your data, queried locally.

Sample queries

Total gas the jaredfromsubway.eth MEV bot burned across its transactions in the last day, in ETH and USD.

mevlog query -b 7200:latest --sql mainnet

SELECT format_usd(convert_usd(
         u256_sum(u256_mul(gas_used, effective_gas_price)),
         {NATIVE_TOKEN_PRICE()})) AS gas_spent
FROM transactions
WHERE from_address = {RESOLVE_ENS("jaredfromsubway.eth")}

gas_spent $48,210.34

Try a live query → Read the docs

EVM-native SQL functions

Plain SQLite cannot sum U256 values. mevlog adds the missing pieces: 256-bit math, ERC20 decoding, and display helpers that turn raw wei into readable ETH, gwei, and live USD prices.

SQL query using format_usd, convert_usd, and u256_mul to compute per-transaction gas cost in USD

Chain selector listing Arbitrum networks

Every chain, and you own the data

No hosted APIs, rate limits, or per-request fees. Index blockchain data into a local SQLite database that stays on your machine. The web demo uses Ethereum mainnet, while the mevlog-rs CLI works with any ChainList-supported network or your own node.

Open-source and free to use

Built on the MIT-licensed Rust crate mevlog-rs. The same query engine powers the web demo and CLI, making it easy to move from experimentation to local analysis.

The web demo indexes Ethereum mainnet over public RPCs sourced from ChainList, and the Rust CLI is instrumented by the hotpath.rs profiler.

The project received grants from the Ethereum Foundation Ecosystem Support Program and the ENS PG Builder Grants.