With its unique object-based architecture and fast consensus, the Sui blockchain is a compelling platform for decentralized applications and on-chain innovation. To fully explore what’s happening on-chain, developers and analysts need robust, accessible data tools.
That’s where Chainbase shines — offering flexible solutions to tap into Sui’s raw data. Across this series, we highlight three key methods to access MoveCall
transactions:
Through Manuscript-GUI
Via Manuscript-CLI
Using Chainbase DataCloud
This article focuses on the third method: querying Sui data using Chainbase’s DataCloud, a browser-based platform for writing and executing SQL against live blockchain datasets — no setup or coding required.
For a low-code SQL experience, use Chainbase’s DataCloud Console.
Go to Console
Run SQL Here is a example of using SQL to fetch MoveCall
data:
select
*
from
(
select
transaction_digest,
transaction,
timestamp,
checkpoint,
JSON_QUERY (transaction, '$.MoveCall.module') as module,
JSON_QUERY (transaction, '$.MoveCall.package') as package
from
(
select
transaction_digest,
timestamp,
checkpoint,
transaction_col.value as transaction
from
(
select
transaction_digest,
from_unixtime (
CAST(JSON_QUERY (raw_data, '$.timestampMs') as BIGINT)/1000,
'yyyy-MM-dd HH:mm:ss'
) as timestamp,
JSON_QUERY (raw_data, '$.checkpoint') as checkpoint,
JSON_QUERY (
raw_data,
'$.transaction.data.transaction.transactions'
) as transactions_arr,
raw_data AS transactions
from
paimon.sui.sui_transactions
where
raw_data like '%module%'
) aa,
LATERAL JSON_EACH (aa.transactions_arr) as transaction_col
) as tt
) ttt
where
module <> ''
or package <> ''
Save SQL
Create task API
Copy script and deploy task API locally
vim sui_move_call_task.sh
/bin/bash sui_move_call_task.sh
DataCloud is ideal for teams and individuals who want to query Sui data on demand, without maintaining infrastructure. With built-in SQL support, data preview, and API integrations, you can go from insight to action in just minutes. It’s the fastest way to get started with Sui data exploration — and a must-have in your blockchain analytics toolkit.
Over 5k subscribers