Announcements

Introducing SQL Explorer: Direct SQL Access to Onchain Data

Trading desks and quant teams building on Hyperliquid spend weeks on data plumbing before they get to the query they actually care about. SQL Explorer replaces that stack with a single interface. No indexer. No pipelines. Just SQL.

Quicknode

Quicknode

— 4 min read
Introducing SQL Explorer: Direct SQL Access to Onchain Data

TL;DR

  • Query Hyperliquid trades, liquidations, funding, positions, and more with standard SQL.
  • 385B+ indexed rows across 37 tables, with 40+ pre-built queries.
  • Turn any SQL query into a programmable REST endpoint. No indexers, no pipelines, no additional vendors.
  • Available now in beta on all paid Quicknode plans.

What SQL Explorer Is

SQL Explorer is a fully indexed SQL interface to billions of rows of blockchain data, accessible through both an in-browser editor and a REST API, without managing any of the underlying infrastructure. It's live in beta with deep Hyperliquid coverage (37 tables, 385B+ indexed rows) with additional chains coming.

It sits alongside RPC, Streams, and Webhooks as part of Quicknode's data access layer. Where RPC and gRPC give you raw chain access, and Streams and Webhooks give you push-based event delivery, SQL Explorer gives you queryable, indexed data on demand. Different access patterns for different problems, all on one unified platform.

The Problem It Solves

If you're running a trading desk, building a quant strategy, or operating data infrastructure on throughput chains, like Hyperliquid, you've hit this wall. You start polling JSON-RPC endpoints. You build a custom indexer when polling isn't enough. You pipe raw data into a warehouse. You write transformation logic. You maintain all of it.

That's a lot of engineering effort spent on plumbing before you even get to the query you actually care about, like understanding which assets are getting liquidated, how funding rates are shifting across markets, or where whale activity is concentrated.

The result is infrastructure overhead that diverts engineering from the systems that generate value, multi-vendor sprawl with fragile integrations, and a gap between "data exists onchain" and "data is queryable in my system" that can take weeks to close.

SQL Explorer replaces that stack with a single interface. No infrastructure to manage. No indexer to run. No warehouse to maintain. You write SQL, you get data.

How It Works: SQL to REST Walkthrough

Say you want to find whale trades on Hyperliquid. Everything over $100K in the last 24 hours, ranked by size. SQL Explorer supports standard SQL syntax, including joins, subqueries, window functions, and aggregations, so that's a single query against the hyperliquid_trades table:

SELECT
  timestamp,
  coin,
  side,
  price,
  size,
  toFloat64(price) * toFloat64(size) AS notional_usd,
  buyer_address,
  seller_address
FROM hyperliquid_trades
WHERE timestamp > now() - INTERVAL 24 HOUR
  AND toFloat64(price) * toFloat64(size) > 100000
ORDER BY notional_usd DESC
LIMIT 100

You can run this in the dashboard's SQL editor, which includes a schema browser, syntax highlighting, and built-in charting, or send it via the REST API:

curl -X POST 'https://api.quicknode.com/sql/rest/v1/query' \
  -H 'accept: application/json' \
  -H 'Content-Type: application/json' \
  -H 'x-api-key: YOUR_API_KEY' \
  -d '{
    "query":"SELECT timestamp, coin, side, price, size, toFloat64(price) * toFloat64(size) AS notional_usd, buyer_address, seller_address FROM hyperliquid_trades WHERE timestamp > now() - INTERVAL 24 HOUR AND toFloat64(price) * toFloat64(size) > 100000 ORDER BY notional_usd DESC LIMIT 100",
    "clusterId": "hyperliquid-core-mainnet"
  }'

The response is structured JSON that your systems can consume directly. No transformation layer, no ETL. Every response includes execution statistics so you can monitor performance and optimize costs:

{
  "data": [
    {
      "timestamp": "2026-04-01 08:17:12.046",
      "coin": "ETH",
      "side": "B",
      "price": 2125,
      "size": 1421.7697,
      "notional_usd": 3021260.6125000003,
      "buyer_address": "0xb8eb97eaed8367079894d2f1bed69bd220ec1dd5",
      "seller_address": "0x004edcd40360e293e4cf260d2ebdf8c7076c1bb8"
    },
    {
      "timestamp": "2026-03-31 20:50:21.436",
      "coin": "xyz:SP500",
      "side": "A",
      "price": 6503,
      "size": 461.329,
      "notional_usd": 3000022.4869999997,
      "buyer_address": "0x354bcb431a332079950d2ce3a4698745e0f66425",
      "seller_address": "0x9657aa2cd45f2cfe77bef47f026bd835edcd165c"
    }
  ],
  "statistics": {
    "elapsed": 0.052795353,
    "rows_read": 3926795,
    "bytes_read": 496898463
  }
}

Connect results directly to your trading systems, dashboards, internal tools, or AI agents. This is one of 40+ pre-built queries available in the dashboard. You can also write anything the schema supports.

What's Available in Beta

SQL Explorer is live now with full Hyperliquid HyperCore coverage:

  • 37 tables spanning trades, orders, fills, funding, market data, blocks, transactions, liquidations, clearinghouse states, oracle prices, staking, ledger updates, bridge events, builder activity, vault equities, sub-accounts, referrals, display names, metrics, and more
  • 385B+ indexed rows with columnar storage and partition-aware query execution
  • 40+ pre-built queries covering trading activity, market analysis, position tracking, infrastructure monitoring, portfolio views, and platform analytics
  • In-browser SQL editor with syntax highlighting, schema browser, charting, and a query builder that generates REST calls from the UI
  • REST API with API key authentication — any query, programmable from anywhere
  • Execution statistics on every response for cost awareness and optimization
  • Credit-based billing from your existing Quicknode account, metered by query execution time and data scanned, with full cost visibility in every API response

Get Started

SQL Explorer is available now on all paid Quicknode plans. No waitlist, no beta form. Just log in and start querying.

Open SQL Explorer in your Quicknode dashboard to start writing queries immediately.

For the full REST API setup, schema reference, and all pre-built queries, read the SQL Explorer documentation.

If you're building with AI agents, install the Quicknode Skill to give your agent full knowledge of SQL Explorer and the broader Quicknode platform:

npx skills add quiknode-labs/blockchain-skills

SQL Explorer takes a workflow that used to require weeks of infrastructure work and reduces it to a query. Hyperliquid is the first dataset. Additional chains are on the roadmap, and the same interface and API will carry forward. What you build today doesn't get thrown away.

If you need Enterprise data access at scale, reach out to our team here.

Trying out SQL Explorer and have feedback? Reach out at product@quicknode.com or join us on Discord. We'd love to hear from you.

About Quicknode

Founded in 2017, Quicknode provides world-class blockchain infrastructure to developers and enterprises. With 99.99% uptime, support for 80+ blockchains, and performance trusted by industry leaders, we empower builders to deploy and scale next-generation applications across Web3.

Start building today at Quicknode.com.

Read more