SQL

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": "daily",
      "description": "",
      "columns": [
        {
          "name": "blockchain",
          "type": "String",
          "description": ""
        },
        {
          "name": "block_date",
          "type": "Date",
          "description": ""
        },
        {
          "name": "project",
          "type": "String",
          "description": ""
        }
      ]
    },
    {
      "schema": "dex",
      "table": "hourly",
      "description": "",
      "columns": [
        {
          "name": "blockchain",
          "type": "String",
          "description": ""
        },
        {
          "name": "block_hour",
          "type": "DateTime('UTC')",
          "description": ""
        },
        {
          "name": "project",
          "type": "String",
          "description": ""
        }
      ]
    },
    {
      "schema": "dex",
      "table": "pools",
      "description": "DEX pools: venue and coin types.",
      "columns": [
        {
          "name": "pool",
          "type": "FixedString(32)",
          "description": ""
        },
        {
          "name": "project",
          "type": "String",
          "description": ""
        },
        {
          "name": "coin_type_a",
          "type": "String",
          "description": ""
        }
      ]
    }
  ]
}

Long lists are cut to a few items here.