Cover photo

How to Access Sui Blockchain Data with Chainbase DataCloud

Introduction

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.

Method 3: Using Chainbase DataCloud

For a low-code SQL experience, use Chainbase’s DataCloud Console.

Steps:

  1. Go to 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 <> ''
    
post image
  1. Save SQL

post image
post image
  1. Create task API

    post image
  2. Copy script and deploy task API locally

    post image
    vim sui_move_call_task.sh
    /bin/bash sui_move_call_task.sh
    
    post image
Play Video

Conclusion

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.