Suggested

Query EVM state. Simulate EVM calls.

Query simulation inputs, results, observations, and state changes together.

Read current or historical EVM state. Simulate calls against pinned or modified state. Query the inputs, results, observations, and state changes with SQL.

Start with a runnable guide. Use the function, type, and table references for exact SQL syntax.

Start here

Call an EVM contract from SQL

Run this notebook to read the latest ETH/USD price from Chainlink on Ethereum mainnet.

Determica decodes latestRoundData into typed SQL values. Format the price and timestamp here, or use them in another query.

Open the contract state guide
read_contract get_logs 
-- Chainlink ETH/USD, read live from Ethereum mainnet.
WITH feed AS (
  SELECT read_contract(
    $client,
    '0x5f4eC3Df9cbd43714FE2740f5E3616155c5b8419'::ADDRESS,
    $feed_abi,
    'latestRoundData'
  ) AS data
)
SELECT
  format_units((data).answer, 8) AS eth_usd,
  to_timestamp((data).updatedAt) AS updated_at
FROM feed;
Loading cached snapshot · 1 rows

Workflows

Choose a workflow

Open a function for one operation or a 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 Handle for live, pinned, or retained execution state PROGRAM Sequential, non-atomic EVM program manifest
View all types