CATALOG of the databases raw SQL can reach — the SHOW DATABASES equivalent. For each database:
what it holds, which tool runs SQL against it, how to see its tables, and which specialized
tools answer the same questions without SQL. Call it before writing raw SQL against an
unfamiliar database. Takes no parameters and answers instantly.
trading_rt comes first: DEX trades, OHLC / volume bars, prices and supply for every trading
chain over the last ~30 days — query it with execute_sql, browse it with list_tables,
describe_table and search_columns. The per-chain databases (eth_api, bsc_api, matic_api,
arbitrum_api, base_api, optimism_api, robinhood_api, arc_api, tron_api, solana, bitcoin, bitcoin_flow,
ripple, ripple_flow, cardano, cardano_flow, altcoin, altcoin_flow - Litecoin, Dogecoin and Dash
in one database, rows told apart by blockchain_id - bitcash, bitcash_flow for Bitcoin Cash, and
stellar) hold transfers, calls, events, transactions and balances; browse them with
chain_list_tables, chain_describe_table and chain_search_columns (pass the database name) and
query each one with that chain's <chain>_transfers_raw_sql tool (xrp_, ada_, ltc_ / doge_ /
dash_, bch_ and xlm_transfers_raw_sql for the ones above after bitcoin_flow). zcash and
zcash_flow are queried with zec_transfers_raw_sql but the schema browser does not cover them:
that tool's description lists their tables. stellar_flow is not browsable either - it starts
in December 2023 and misses some ledgers, so query stellar instead. Address labels have no SQL
access at all — use the label tools. Prefer a specialized tool whenever one answers the question: it already filters
on the right keys and is far cheaper than hand-written SQL.