Indexer

Decoded Solana DEX activity in ClickHouse: 21 tables across Pump.fun, PumpSwap, Raydium, Meteora and Jito, queryable with plain SQL. Flat $300/mo.

// updated 2026-08-22

Decoded Solana DEX transactions, indexed in real time and queryable with plain SQL. Run your own ClickHouse queries against the database, or have a recurring one deployed as a REST endpoint.

NOTE

Skip the indexer, write queries. Swaps, launches, migrations, transfers and tips are already decoded into typed columns - you write SQL instead of parsing transactions.

What's covered

Protocol	Tables
Pump.fun	token creation, bonding-curve swaps, v2 swaps (including failed), AMM migrations, creator fee distributions, admin creator changes
PumpSwap	swaps with pool reserves before/after, every fee component, creator / cashback / buyback fields, virtual quote reserves
Raydium	AMM swaps, CPMM swaps, Launchpad swaps, Launchpad token creation, migrations into AMM and CPMM pools
LetsBonk.fun	lands in the Raydium Launchpad tables
Meteora	DLMM swaps, Dynamic Bonding Curve swaps
Jito	transaction tips
Helper tables	SPL and Token-2022 transfers, native SOL transfers, block index, high-precision transaction timestamps, precomputed peak market caps

Full column lists are in the Table reference.

Scale

Snapshot from 16 August 2026 - the database grows continuously.


Tables	21
Columns	463
Largest table	`pumpswap_all_swaps` - 5.06 billion rows, 1.6 TB
Deepest history	`pumpfun_token_creation` - from 17 January 2024
Validation latency	~15 seconds from block confirmation

Key technical specs

Engine: ClickHouse, MergeTree family, daily partitioning, default database.
Confirmed data only - never processed-level rows that can revert.
Retention is per table, from 14 days on the timing tables to full history on the Pump.fun core - see Schema conventions.
Amounts are raw base units - lamports for SOL, the mint's own base unit for tokens.
Nanosecond timestamps captured at our Amsterdam shred receiver, exposed through tx_timestamps.

Two ways to query

Direct ClickHouse

Production analytics, scheduled jobs, full SQL access.

Custom REST API

A recurring query deployed as a stable endpoint.

Use cases

Launch-cohort and creator-quality analysis on Pump.fun and Raydium Launchpad.
Liquidity monitoring, pool reserve reconstruction, and fee-flow accounting.
Whale identification, wallet funding traces, and follow-the-leader strategies.
Splitting organic flow from aggregator-routed flow via parent_program.
MEV and market-microstructure work using sub-slot timing.
Cross-referencing on-chain swaps with off-chain market data.

How to get access

NOTE

v1 access is request-based, not self-service. We review and provision manually.

1
Request access
Message @supanode_tgs on Telegram.
2
We provision your account
You receive your x-token plus a database username and password.
3
Connect and query
See Access for connection details and code samples.

Pricing

$300/mo flat. Full schema access, direct ClickHouse queries, and unlimited query volume within reason. Billed as its own subscription with the same duration slider as the Bundles (1 hour to 30 days).

Custom REST endpoints and Python ETL flows are quoted per scope on top of the base $300/mo. Contact @supanode_tgs.

Free trial

Up to 24 hours, no card, with full schema access. Activate via Telegram: @supanode_tgs.

Where to next

Access

Connection, authentication, code samples.

Schema conventions

Shared columns, units, partitions, retention.

Table reference

All 21 tables, column by column.

Query examples

Working SQL you can paste.

Nanosecond timestamps

Sub-slot timing for MEV research.