Database

PostgreSQL stores canonical block/event provenance and product projections. The migration runner applies each file in a single transaction and requires the exact continuous sequence 001 through 014.

Migration range	Main capability
`001`–`003`	Blocks, events, checkpoints, tokens, curves, trades, fees, graduation, metadata, V3-only transition
`004`–`008`	Holder balances, analytics, discovery, OHLC, and social metadata
`009`–`011`	V3 graduation plane, Uniswap V3 trades, and application exclusions
`012`	CTO treasuries, proposals, token state, checkpoints, transfers, and fee pulls
`013`	Trade/chart normalization and fixed token-decimal constraint
`014`	Creator-bound metadata claims and wallet-holdings indexes

Amounts use PostgreSQL NUMERIC columns and are exposed as decimal strings. Canonical flags and block hashes retain reorg provenance. Derived rows are application views; the chain and contracts remain authoritative for balances and execution. The repository proves the migration set and runner behavior. It does not prove which migrations are installed in an unspecified remote database.

Overview

Protocol

Using Cooket

Developers

API Reference

Security

Reference