Coinbase Brings Its SQL API to Solana in Beta, No Indexer Required

Coinbase Developer Platform has launched its SQL API on Solana in beta, letting developers query token transfers and instruction-level activity with plain SQL instead of running their own indexing infrastructure. It's the same product CDP already offers Base builders, now pointed at Solana, with pay-as-you-go pricing and a free tier of 1,000 queries per month.

Solana's speed is the reason teams build there, and it's also the reason the chain is miserable to index. The ledger grows fast, application state is scattered across program-derived accounts (PDAs, the accounts Solana programs use to store data). CDP's answer is to host the indexed data itself and put a SQL interface in front of it. You write a query, you get rows back, and the ledger-sized storage problem stays on Coinbase's side of the API.

Two tables, scoped to the token programs

The beta ships with two datasets:

solana.transfers: token movements from SPL Token, Token-2022, and native SOL, decoded from transfer and transferChecked instructions.
solana.instructions: decoded instruction calls for the SPL Token and Token-2022 programs.

CDP covers three well-known program IDs rather than promising every program on day one: SPL Token, Token Extensions (Token-2022), and the System program for native SOL. It's the token surface most applications touch first, and it covers the obvious jobs:

Tracking SPL and Token-2022 transfers for a specific mint, wallet, or program
Reconstructing instruction-level activity for the token programs
Powering portfolio views, payment flows, analytics, and ops dashboards
Joining, filtering, and aggregating across it all with standard SQL

The CDP docs note that roughly three months of history is retained, counting from the August 2026 launch, and that schema and coverage may evolve during the beta. Arbitrary program decoding beyond the token programs isn't available yet. If your app needs custom program data or deep history, you'll still need something else.

How do you query Solana with SQL?

The SQL Playground in the CDP Portal runs queries straight from the browser, which is the fastest way to poke at the schema. For production, there's a REST API to query against.

A wallet history query looks like the SQL you'd write against any database:

SELECT block_time, mint, amount, destination_owner FROM solana.transfers WHERE source_owner = 'YourWalletAddressHere' AND action = 1 ORDER BY block_time DESC LIMIT 100;

Coinbase quotes 200ms call latency and 500ms freshness to the tip of the chain. Most hosted query products for blockchain data are built for analytics, where data lands minutes or hours behind the chain. Half a second of freshness is fast enough for user-facing features like a portfolio balance or a payment confirmation screen.

SQL API operates on a pay-as-you-go model:

1,000 free queries every month
$0.0083 per query after the free tier
Rate limit of 2 queries every second per project

Where this fits in the Solana data stack

Token data covers payments, portfolios, and most dashboards, but DeFi position tracking, NFT activity, and anything touching custom program state sits outside the two tables for now. CDP shipping Solana support at all, after starting with Base, suggests the coverage list is meant to grow.

To try it, sign into the CDP Portal, open the SQL Playground, and run a query. The CDP SQL API on Solana is in beta, so expect the occasional schema change, and keep an eye on the docs before you build anything for production.