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:

1. Through Manuscript-GUI

2. Via Manuscript-CLI

3. 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.

1. Go to Console

   • DataCloud Console

2. 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 <> ''
   

1. Save SQL

1. Create task API

   

2. Copy script and deploy task API locally

   

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.

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:

1. Through Manuscript-GUI

2. Via Manuscript-CLI

3. 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.

1. Go to Console

   • DataCloud Console

2. 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 <> ''
   

1. Save SQL

1. Create task API

   

2. Copy script and deploy task API locally

   

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.