Skip to content
OnchainQueries

OQ — S30 · For developers & data teams

OnchainQueries is a read-only SQL service with a CLI, a control API and two result transports. It is designed to sit upstream of your warehouse, not replace it.

Transports
2
Parameter types
13
Checksum
SHA-256
Request limit
2 MiB
OQ — S30·1What you get

Everything the CLI does is available over the same public control API.

Scriptable CLI

query sql --file

Run a .sql file with typed parameters, follow the job and write verified results to disk in one command.

Resumable jobs

query attach

A submitted query survives your shell. Attach later to download it, or cancel to release its capacity.

Checksums in CI

manifest.json

Assert on row counts, source coverage and per-part SHA-256 in a pipeline instead of trusting a copy.

Arrow Flight

port 8091

Stream result batches into your process without serialising through JSON.

Explicit failures

named errors

Every rejection identifies the stage and the feature, so pipeline failures are diagnosable rather than mysterious.

Deterministic sizing

--engine

Pin an engine class when formatting-independent selection matters for a scheduled job.

OQ — S30·3Example

A single-table projection with no grouping, ordering or joins, that includes ts, can be split into independent daily tasks. That is the fastest way to move a lot of rows.

export.sql
SELECT  ts,  slot,  sig,  mint,  sol_amountFROM pump_fun.trade_eventWHERE ts >= {{start_time}}  AND ts < {{end_time}};
OQ — S30·4Questions

Can I run this on a schedule?

Yes. The CLI is a normal binary that exits nonzero on failure, so cron, Airflow, Dagster or GitHub Actions all work. Pin an explicit engine class so selection does not change when someone reformats the SQL.

How do I keep credentials out of CI logs?

CARBON_ENDPOINT and CARBON_API_TOKEN are read from the environment. Use your platform's secret store; never put a token in a committed script.

What is the largest query I can submit?

Submit requests, including SQL and parameter JSON, are capped at 2 MiB. Execution time is bounded by the engine class — up to 6 hours on large.

Typed parameters, verified parts, and a manifest you can assert on.

Start queryingRead the docs