Query EVM state with Determica

The chain records what happened. Execute alternatives.

Determica is EVM execution and analysis software built on DuckDB and evmone. Use SQL for historical chain analysis and local EVM execution, keeping the declared inputs, returned rows, and execution evidence visible together.

Start with a runnable guide. Use the function, type, and table references for catalog-backed details.

Start here

Read a contract with SQL

Run the notebook to call latestRoundData on Chainlink’s ETH/USD feed on Ethereum mainnet.

read_contract returns ABI-decoded SQL values. The query formats the oracle answer and converts the update time to a timestamp.

Read guide
read_contract get_logs
1
-- Chainlink ETH/USD, read live from Ethereum mainnet.
2
WITH feed AS (
3
SELECT read_contract(
4
$client,
5
'0x5f4eC3Df9cbd43714FE2740f5E3616155c5b8419'::ADDRESS,
6
$feed_abi,
7
'latestRoundData'
8
) AS data
9
)
10
SELECT
11
format_units((data).answer, 8) AS eth_usd,
12
to_timestamp((data).updatedAt) AS updated_at
13
FROM feed;
Notebook ready in readonly mode.

Workflows

Choose a workflow

Use the linked functions for individual operations. Open the guide for a runnable notebook.

Reference

Find a function or type

Functions by task

Create an HTTP transport http_transport Read a contract read_contract Query event logs get_logs Parse a token amount parse_units Format a raw balance format_units Build calldata encode_function_data Resolve one exact block pin Build a program step execute_call Query transfer events get_logs Run candidate programs run Compute a CREATE2 address create2_predict Mine CREATE2 salts create2_mine

Common types

ADDRESS 20-byte Ethereum address stored as raw bytes BYTES Dynamic-length raw byte array BYTES32 Fixed 32-byte raw value UINT256 Unsigned 256-bit EVM integer INT256 Signed 256-bit EVM integer TRANSPORT Typed JSON transport configuration CLIENT Live, pinned, or execution-checkpoint state identity PROGRAM Sequential, non-atomic EVM program manifest
View all types