Querying Tempo

GET /query?sql&chainId&engine&signature&timeout_ms&limit&live

{
  "ok": true,
  "columns": ["num", "hash", "gas_used"],
  "rows": [[1, "0xabc...", 21000]],
  "row_count": 1,
  "engine": "postgres",
  "query_time_ms": 12.5
}

tidx query --url <url> --chain-id <chain_id> [OPTIONS] <sql>

tidx query --url http://localhost:8080 --chain-id 4217 \
  "SELECT num FROM blocks ORDER BY num DESC LIMIT 5"

# With basic auth (credentials extracted from URL)
tidx query --url http://user:pass@localhost:8080 --chain-id 4217 \
  "SELECT num FROM blocks ORDER BY num DESC LIMIT 5"

# Latest 5 blocks
curl "http://localhost:8080/query?chainId=4217&sql=SELECT num, gas_used FROM blocks ORDER BY num DESC LIMIT 5"

# Block by number
tidx query "SELECT * FROM blocks WHERE num = 1000000"

# Blocks in a time range
tidx query "SELECT num, gas_used FROM blocks WHERE timestamp > now() - interval '1 hour' ORDER BY num DESC LIMIT 100"

# Lookup by hash
tidx query "SELECT * FROM txs WHERE hash = '0x1234...'"

# Transactions from an address (uses `from` index)
curl "http://localhost:8080/query?chainId=4217&sql=SELECT hash, value, gas_used FROM txs WHERE \"from\" = '0xdAC17F958D2ee523a2206206994597C13D831ec7' ORDER BY block_num DESC LIMIT 10"

# Contract creations
tidx query "SELECT hash, \"from\" FROM txs WHERE \"to\" IS NULL ORDER BY block_num DESC LIMIT 10"

# Failed transactions
tidx query "SELECT tx_hash, \"from\", gas_used FROM receipts WHERE status = 0 ORDER BY block_num DESC LIMIT 10"

# Contract deployments
tidx query "SELECT tx_hash, contract_address FROM receipts WHERE contract_address IS NOT NULL ORDER BY block_num DESC LIMIT 10"

# Transactions paid by a fee payer (Tempo-specific)
tidx query "SELECT tx_hash, \"from\", fee_payer FROM receipts WHERE fee_payer IS NOT NULL ORDER BY block_num DESC LIMIT 10"

# Logs by contract address
tidx query "SELECT block_num, tx_hash, data FROM logs WHERE address = '0xABC...' ORDER BY block_num DESC LIMIT 10"

# Logs by event selector
tidx query "SELECT * FROM logs WHERE selector = '0xddf252ad' ORDER BY block_num DESC LIMIT 10"

# CLI
tidx query \
  -s "Transfer(address indexed from, address indexed to, uint256 value)" \
  'SELECT "from", "to", "value" FROM Transfer ORDER BY block_num DESC LIMIT 10'

# HTTP
curl "http://localhost:8080/query?chainId=4217&signature=Transfer(address%20indexed%20from,%20address%20indexed%20to,%20uint256%20value)&sql=SELECT%20%22from%22,%20%22to%22,%20%22value%22%20FROM%20Transfer%20ORDER%20BY%20block_num%20DESC%20LIMIT%2010"

tidx query \
  -s "Transfer(address indexed from, address indexed to, uint256 value)" \
  'SELECT "to", "value" FROM Transfer WHERE "from" = '\''0xdAC17F958D2ee523a2206206994597C13D831ec7'\'' ORDER BY block_num DESC LIMIT 10'

tidx query \
  -s "Transfer(address indexed from, address indexed to, uint256 value)" \
  'SELECT "from", "to", "value" FROM Transfer WHERE address = '\''0xABC...'\'' ORDER BY block_num DESC LIMIT 10'