# Indexer

> Decoded Solana DEX transactions, indexed in real time, queryable via SQL. ClickHouse with nanosecond timestamps.

Decoded Solana DEX transactions, indexed in real time, queryable via SQL. Run your own ClickHouse queries against our database, or use a custom REST endpoint.

<Note>
**Skip the indexer, write queries.** We've already decoded the swaps, migrations, and token creations - you write SQL.
</Note>

## What's covered

| Protocol | Tables |
|---|---|
| **Pump.fun** | Token creation, all swaps |
| **PumpSwap** | All swaps, AMM migrations |
| **Raydium** | All swaps |
| **LaunchLab** (Raydium launchpad) | Launchpad swaps, graduations |
| **Letsbonk.fun** | Launchpad token swaps |
| **Meteora** | DLMM swaps |
| **Other Solana mints** | New SPL token creations |

For the full schema with column types, see [Database schema](https://supanode.xyz/docs/solana/indexer/database-schema).

## Key technical specs

- **History coverage:** from January 11, 2024.
- **Validation latency:** ~15 seconds (only confirmed transactions are exposed).
- **Engine:** ClickHouse, MergeTree with daily partitioning, 1-year TTL.
- **Nanosecond timestamps** captured at our Amsterdam shred receiver.

## Two ways to query

<CardGroup cols={2}>
  <Card title="Direct ClickHouse" icon="database" href="https://supanode.xyz/docs/solana/indexer/access">
    Production analytics, scheduled jobs, full SQL access.
  </Card>
  <Card title="Custom REST API" icon="webhook" href="https://supanode.xyz/docs/solana/indexer/access#custom-rest-api">
    Specific recurring queries deployed as endpoints.
  </Card>
</CardGroup>

## Use cases

- Liquidity monitoring and token distribution tracking.
- Whale identification and follow-the-leader strategies.
- Custom trading indicators derived from on-chain swap activity.
- MEV / market microstructure analysis (with nanosecond timestamps).
- Cross-reference 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.
</Note>

<Steps>
  <Step title="Request access">
    Request access via Telegram: [@supanode_tgs](https://t.me/supanode_tgs).
  </Step>
  <Step title="We provision your account">
    You receive your `x-token` plus database username/password.
  </Step>
  <Step title="Connect and query">
    See [Access](https://supanode.xyz/docs/solana/indexer/access) for connection details and code samples.
  </Step>
</Steps>

## Pricing

**\$300/mo flat.** Includes full schema access, direct ClickHouse queries, and unlimited query volume within reason. Billed as a separate subscription with its own duration slider (1 hour to 30 days).

Custom REST APIs and Python ETL flows are quoted per scope - those are extras on top of the base \$300/mo. Contact [@supanode_tgs](https://t.me/supanode_tgs).

## Free trial

**Up to 48-hour free trial** with full schema access. Activate via Telegram: [@supanode_tgs](https://t.me/supanode_tgs).

## Where to next

<CardGroup cols={3}>
  <Card title="Access" icon="key" href="https://supanode.xyz/docs/solana/indexer/access">
    Connection and authentication.
  </Card>
  <Card title="Database schema" icon="database" href="https://supanode.xyz/docs/solana/indexer/database-schema">
    Tables and columns.
  </Card>
  <Card title="Nanosecond timestamps" icon="stopwatch" href="https://supanode.xyz/docs/solana/indexer/nanosecond-timestamp">
    For MEV and microstructure analysis.
  </Card>
</CardGroup>