Products/Data Delivery

QuerybasePublic access coming soon

The full chain history, in SQL

A fast, serverless database of decoded blocks, transactions, logs, transfers and events. Query it from your BI tool, notebook or backend.

Join the Querybase waitlist Use it in a managed solution

Public pricing at launch. Pricing →

Available now for managed solutions.

What it is

Querybase

Querybase is Routescan’s serverless SQL database of decoded blockchain history: blocks, transactions, logs, transfers and events, from the first indexed block to the chain head. Public access is coming soon. Today it is available inside the managed solutions our team runs.

Speed: Under a secondFor aggregations over full history.
Price: On your scopeInside managed solutions until public launch.
Chains: Chains others skipL2s, appchains and custom chains we index.
Compatibility: JDBC, ODBC, HTTPConnect the BI tools and notebooks you already use.

Query and result

Monthly USDC volume, since 2018

HTTPS endpoint: Queries in the ClickHouse SQL dialect, results over HTTPS
Read-only credentials: Scoped per project in the console
Drivers: JDBC and ODBC for BI tools

query.sql

1SELECT DATE_TRUNC('month', block_time) AS month,2       COUNT(*) AS transfers,3       ROUND(SUM(amount) / 1e9, 1) AS volume_b4FROM erc20_transfers5WHERE chain_id = 16  AND token_symbol = 'USDC'7GROUP BY month8ORDER BY month DESC;

result · 98 rows · 0.62 s

1{2  "rows": [3    { "month": "2026-10", "transfers": 8912044, "volume_b": 498.7 },4    { "month": "2026-09", "transfers": 10305218, "volume_b": 571.2 },5    { "month": "2026-08", "transfers": 10688930, "volume_b": 603.9 }6  ],7  "rowCount": 98,8  "scanned": "14.2 GB",9  "seconds": 0.6210}

Capabilities

Decoded history, ready to query

Documented tables of decoded chain data in a serverless database. Read-only, from the tools you already use.

Read the docs →

SQL workspace · read-only0.38 s

1SELECT day, token, volume_b,

2 avg(volume_b) OVER (

3 PARTITION BY token ORDER BY day

4 ROWS 6 PRECEDING) AS avg_7d

5FROM daily_volume WHERE token = 'USDC'

daytokenvolume_bavg_7d

2026-10-22USDC21.821.4

2026-10-21USDC22.621.2

2026-10-20USDC20.921.0

2026-10-19USDC23.120.9

Analytical SQL

Joins, window functions and aggregations across the full indexed history.

query log · project ops-analyticsread-only

SELECT COUNT(*) FROM transactions WHERE …0.21 s

INSERT INTO erc20_transfers VALUES …denied · READONLY

ALTER TABLE logs DELETE WHERE …denied · READONLY

SELECT token, sum(amount) FROM erc20_transfers …0.44 s

SELECT * FROM blocks ORDER BY number DESC …0.09 s

Read-only and isolated

Queries run read-only, isolated from indexing.

DESCRIBE erc20_transfers7 columns

nametype

chain_idINTEGER

block_timeTIMESTAMP

tx_hashVARCHAR

token_addressVARCHAR

token_symbolVARCHAR

amountDECIMAL(38, 18)

fromVARCHAR

Documented tables

Blocks, transactions, logs, transfers and decoded events, per chain.

Full history

From the first indexed block to the chain head, on each chain.

Use cases

Running inside managed solutions

Our team builds these services on Querybase, then runs them for you.

Coverage

24indexed networks

Available for managed solutions on these networks. The most active are listed here.

See all supported chains →

Ethereum
GUNZ
Dexalot
Henesys
Boba Ethereum
Hemi
Beam
Numine

Questions

What teams usually ask us

Can I sign up for Querybase today?

Not on your own yet. Public access is coming soon, and you can join the waitlist. Querybase is available today inside the managed solutions our team runs.

What data can I query with Querybase?

Decoded blocks, transactions, logs, transfers and events, in documented tables per chain, over the full indexed history.

How do I connect to Querybase?

Over HTTPS, or with JDBC and ODBC drivers from your BI tools and notebooks, using read-only credentials scoped per project.

Other products

Built on the same index

Data APIDecoded blockchain data over REST, under 100 ms.Etherscan-compatible APIEtherscan-style endpoints on indexed onchain data.Blockscout-compatible APIA managed backend for your own Blockscout frontend.StreamsLive data to webhooks, queues and databases.MCP ServerOnchain investigations for AI agents.Archive RPCLow-cost archive, debug and trace RPC.

Public access coming soon

Join the waitlist for self-serve access. It already runs in managed solutions today.

Join the Querybase waitlist Use it in a managed solution