Skip to main content

​
Overview

The SQL API allows you to create custom queries to pull real-time and historical onchain data from Base. In this quickstart, you will learn how to:
  • Read and use the tables in CDP’s curated schema.
  • Pull data from the Base blockchain with a SQL query. ​

​
Prerequisites

Sign in to the CDP Portal.
Using the SQL Playground? No API keys needed!Using the API programmatically? Create a free CDP Client API key for the cURL example below.

​
1. Try it in the playground

Use our SQL API to query onchain data in milliseconds. With SQL API, you can:
  • Query transactions, events, blocks, and transfers across Base with < 500ms latency
  • Join data across tables for complex analytics
  • Track token flows, smart contract activity, and wallet behavior
The fastest way to query onchain data is through the SQL Playground in CDP Portal.
1

Open SQL Playground

Navigate to the SQL Playground in Portal.
2

Try a query

Copy this query to see recent USDC transfers on Base:
SELECT 
  parameters['from'] AS sender,
  parameters['to'] AS to,
  parameters['value'] AS amount,
  address AS token_address
FROM base.events
WHERE 
  event_signature = 'Transfer(address,address,uint256)'
  AND address = '0x833589fcd6edb6e08f4c7c32d4f71b54bda02913'
LIMIT 10;
See results in milliseconds! ⚡
SQL Playground query results showing USDC transfers

​
2. Run a query programmatically

The SQL API /run endpoint accepts your query as a string value. Before running, replace $CLIENT_TOKEN with your CDP Client API key.
curl -H "Authorization: Bearer $CLIENT_TOKEN" -H "Content-Type: application/json" -X POST "https://api.cdp.coinbase.com/platform/v2/data/query/run" -d '{"sql": "SELECT * FROM base.events LIMIT 1"}'
After running the above, you should see a similar response to the following:
{
  "metadata": {
    "cached": false,
    "executionTimeMs": 17,
    "rowCount": 1
  },
  "result": [
    {
      "action": "added",
      "address": "0x09c7bad99688a55a2e83644bfaed09e62bdcccba",
      "block_hash": "0xed367272b150a98953cb5a1fe725742373432f89c848852e6ebe8319c4bf901f",
      "block_number": "6728",
      "block_timestamp": "2023-06-15T04:20:03.000Z",
      "event_name": "AdminChanged",
      "event_signature": "AdminChanged(address,address)",
      "log_id": "9f33b5afc2f2ade4bcdcefd3077945dc",
      "log_index": 0,
      "parameter_types": {
        "newAdmin": "address",
        "previousAdmin": "address"
      },
      "parameters": {
        "newAdmin": "0x76a737dac0c4eb926bd7d2d68b958a1ae6ad6993",
        "previousAdmin": "0x0000000000000000000000000000000000000000"
      },
      "topics": [
        "0x7e644d79422f17c01e4894b5f4f588d331ebfa28653d42ae832dc59e38c9798f"
      ],
      "transaction_from": "0x0cf966857325db9a9b4dada66e80ce581c18aca1",
      "transaction_hash": "0x08ecc43f4394eb6a7c0c7bf89d4c95c2ba67a7d3ce9f08dc09c5f8c29b1e5de3",
      "transaction_to": "0x4e59b44847b379578588920ca78fbf26c0b4956c"
    }
  ]
}
⌘I