Query the chain · Query with SQL

Query the Bitcoin blockchain with plain SQL

To query the Bitcoin blockchain with SQL, you normally have to run a node, build an indexer, and write your own ETL just to get tables to query. BitcoinDatabase has done that for you. The whole chain since the 2009 genesis block is modeled as clean tables, blocks, transactions, inputs, outputs, addresses, balances, UTXOs, labels and metrics, that you query in plain SQL.

Join transactions to addresses, aggregate flows, build a custom metric, or slice the rich list by balance band, all in a familiar query language. The same data is also available via REST and dashboards. It is informational on-chain data only, not financial or investment advice.

or try it below ↓

REST API · SQL · dashboards · indexed from genesis

Query Console

BTC address or sample query

btc

try:

Hit Run to query the fully-indexed Bitcoin blockchain.

BTC

30-day trend

informational on-chain data · not financial advice

REST API · SQL · dashboards, one indexed dataset. Querying the indexed Bitcoin blockchain ...

REST API SQL DASHBOARDS WEBHOOKS CSV EXPORT

Indexed from genesis queryable in seconds

On-chain data not financial advice

Why it works

What you get with query with sql

The chain as tables

Blocks, transactions, inputs, outputs, addresses, UTXOs, labels and metrics are modeled as clean tables you can join and aggregate in plain SQL.

No node, no ETL

Skip running Bitcoin Core, building an indexer and writing pipelines. The chain is already parsed and reconciled, so you start with a query.

Analyst-ready

Use the SQL you already know to trace flows, build custom metrics or slice the rich list, then drill into the exact rows behind any result.

What it handles

The indexed Bitcoin chain, queryable your way

Look up an address, a transaction, a UTXO, the rich list or an on-chain metric, by REST API, SQL or dashboard. The same authoritative data, reconciled block-by-block against the canonical chain, without running a node.

Query blocks, transactions and addresses as tables
Join inputs and outputs to trace flows
Aggregate UTXOs and balances at scale
Build custom on-chain metrics in SQL
Skip running a node, indexer or ETL

GET /v1/address/{addr} query result

200 · JSON

{
  "address": "bc1qxy2k…l0wdv8",
  "balance_btc": 68432.10,
  "balance_usd": 4612165420,
  "tx_count": 1284,
  "unspent_outputs": 37,
  "first_seen": "2014-02-09"
}

indexed from genesis · to the satoshi ✓ reconciled block-by-block

Why BitcoinDatabase

One platform, queryable three ways

Not a raw node to sync, not an indexer to build, and not five vendors to stitch together. The fully-indexed Bitcoin blockchain, available as a REST API, as SQL, and as dashboards, on one authoritative dataset.

REST API

Typed JSON for addresses, transactions, balances, UTXOs and metrics. Drop it into apps, wallets, explorers and agents with curl, Python or our SDKs.

SQL access

Run SQL directly against the indexed Bitcoin dataset for ad-hoc analysis, cohorts and exports, the same data the API and dashboards read from.

Compliance-first

Informational on-chain data and analytics only. Entity labels and flow tracing are framed as tooling to support a regulated team's own review, not accusations.

Good questions

Questions about query with sql

Blocks, transactions, inputs, outputs, addresses, balances, UTXOs, entity labels and precomputed metrics, all from the fully-indexed chain. You write standard SQL to join and aggregate them, with no node or ETL on your side.

A node gives you raw block data you still have to index and model. BitcoinDatabase delivers the chain pre-indexed as queryable SQL tables. It is informational on-chain data only and not investment advice.

Read every Bitcoin API question

Explore more

See every use case See pricing Back to the Bitcoin API

Stop running a node. Just query Bitcoin.

Run your first query now and get on-chain data back by REST API, SQL or dashboard, indexed from the genesis block. Informational on-chain data only, not financial advice.

See pricing

Indexed from genesis · REST · SQL · dashboards · addresses, transactions, UTXOs, metrics