sql.schema

The public SQL tables and columns

Details

Endpoint: GET /v1/sql/schema
Credits: Free
Rate class: Light. Counts against your light requests per second.

Every public table with its columns and types, grouped by namespace (sui, dex, prices, nft, lending, launchpad, labels, suins, validators, staking, walrus and more). The same list the editor's schema browser shows.

Parameters

This method takes no parameters.

Request

Send your key in the x-api-key header, or leave it out to use the keyless tier.

curl

curl "https://api.tide.ad/v1/sql/schema" \
  -H "x-api-key: YOUR_API_KEY"

TypeScript

const res = await fetch("https://api.tide.ad/v1/sql/schema", {
  headers: {
    "x-api-key": process.env.TIDE_API_KEY!,
  },
});
const data = await res.json();

Response

JSON

{
  "tables": [
    {
      "schema": "dex",
      "table": "aftermath_hourly",
      "description": "Sui DEX volume per UTC hour and venue (project), last 30 days: all decoded swaps (amount_usd, swaps) and the part in transactions that call the Aftermath router (routed_amount_usd, routed_swaps, routed_traders = distinct senders; routed_traders_state merges with uniqCombined64Merge across hours). Aftermath's own pools are project aftermath. The current hour is so far.",
      "columns": [
        {
          "name": "hour",
          "type": "DateTime('UTC')",
          "description": ""
        },
        {
          "name": "project",
          "type": "String",
          "description": ""
        },
        {
          "name": "amount_usd",
          "type": "Float64",
          "description": ""
        }
      ]
    },
    {
      "schema": "dex",
      "table": "aggregator_daily",
      "description": "DEX volume routed through aggregators per UTC day: decoded swap legs (dex.trades, USD at trade time) in transactions where the aggregator emitted its swap event. aggregator is Cetus aggregator, 7k, FlowX or Aftermath router, plus Any aggregator (each routed transaction once) and All swaps (every leg). traders_state merges with uniqCombined64Merge across days.",
      "columns": [
        {
          "name": "block_date",
          "type": "Date",
          "description": ""
        },
        {
          "name": "aggregator",
          "type": "String",
          "description": ""
        },
        {
          "name": "amount_usd",
          "type": "Float64",
          "description": ""
        }
      ]
    },
    {
      "schema": "dex",
      "table": "aggregator_venue_daily",
      "description": "Aggregator-routed DEX volume per UTC day, aggregator and the venue (project) that filled each leg: decoded swap legs (dex.trades) in transactions where the Cetus aggregator, 7k, FlowX or Aftermath router emitted its swap event.",
      "columns": [
        {
          "name": "block_date",
          "type": "Date",
          "description": ""
        },
        {
          "name": "aggregator",
          "type": "String",
          "description": ""
        },
        {
          "name": "project",
          "type": "String",
          "description": ""
        }
      ]
    }
  ]
}

Long lists are cut to a few items here.