Welcome to Bilinear Labs! Query blockchain events with SQL. Get Started.
Getting Started

Getting Started

Get up and running with Bilinear Labs in minutes.

Create an Account

Sign up at app.bilinearlabs.com and create your API key from the dashboard.

Your First Query (UI)

  1. Open the Query Editor from the sidebar.
  2. Enter a SQL query:
SELECT *
FROM ethereum.events
WHERE event_name = 'Transfer'
LIMIT 10;
  1. Click Run to execute.

Your First Query (API) 

curl -X POST http://localhost:3000/api/v1/query \
  -H "Authorization: Bearer YOUR_API_KEY" \
  -H "Content-Type: application/json" \
  -d '{"query": "SELECT * FROM ethereum.events WHERE event_name = '\''Transfer'\'' LIMIT 10"}'

Response:

{
  "data": [
    {
      "block_number": 19845123,
      "tx_hash": "0xabc...def",
      "event_name": "Transfer",
      "contract_address": "0x6b17...1a2f",
      "args": {"from": "0x...", "to": "0x...", "value": "1000000"}
    }
  ],
  "meta": {
    "rows_returned": 10,
    "execution_time_ms": 142
  }
}

Next Steps