SQL

query.list

Browse saved queries

Details

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

Public queries sorted by trending (stars, forks, views and runs this week), new, top or updated. Filter by owner (address), q (text in name, description or tags) or starred=1 (what you starred). Pages with limit and offset.

Parameters

Name	Type	Description
sort	string	One of "trending", "new", "top", "updated".
owner	string
q	string
starred	string
limit	integer
offset	integer

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/queries?sort=trending&limit=10" \
  -H "x-api-key: YOUR_API_KEY"

TypeScript

const res = await fetch("https://api.tide.ad/v1/queries?sort=trending&limit=10", {
  headers: {
    "x-api-key": process.env.TIDE_API_KEY!,
  },
});
const data = await res.json();

Response

JSON

{
  "items": [
    {
      "query_id": 57,
      "name": "Aftermath transactions and users by product",
      "description": "Per day: Sui user transactions whose main package (the package with the most Move calls) belongs to each Aftermath product, and the distinct senders of those transactions.",
      "owner": "0x0000000000000000000000000000000000000000000000000000000074696465",
      "dialect": "tide",
      "parameters": [],
      "visualization_types": [
        "bar",
        "bar",
        "table"
      ],
      "tags": [
        "starter:af-products-daily",
        "aftermath",
        "products"
      ],
      "is_private": false,
      "is_archived": false,
      "forked_from": null,
      "stars": 0,
      "forks": 0,
      "runs": 15,
      "starred": false,
      "last_execution_id": "0101A1A4B65B08681B8EB3326459C05918",
      "last_run_at": "2026-11-04T03:59:36.714Z",
      "created_at": "2026-11-03T22:31:02.530Z",
      "updated_at": "2026-11-03T23:55:12.287Z"
    },
    {
      "query_id": 52,
      "name": "Aftermath share of Sui activity, last 24 hours",
      "description": "Aftermath's share of all Sui user transactions, senders and gas over the last 24 hours, under two definitions: the transaction calls any Aftermath package, or Aftermath is the main protocol (the package with the most Move calls in the transaction is Aftermath's). Shares are of user transactions.",
      "owner": "0x0000000000000000000000000000000000000000000000000000000074696465",
      "dialect": "tide",
      "parameters": [],
      "visualization_types": [
        "counter",
        "counter",
        "counter"
      ],
      "tags": [
        "starter:af-share-windows",
        "aftermath",
        "share"
      ],
      "is_private": false,
      "is_archived": false,
      "forked_from": null,
      "stars": 0,
      "forks": 0,
      "runs": 15,
      "starred": false,
      "last_execution_id": "0101A1A4B65A8321440F3E33F1FB98C757",
      "last_run_at": "2026-11-04T03:59:36.583Z",
      "created_at": "2026-11-03T22:31:02.528Z",
      "updated_at": "2026-11-03T23:55:12.284Z"
    },
    {
      "query_id": 77,
      "name": "Aftermath perps traders on other venues",
      "description": "Of the account owners who placed a perpetuals trade over the last 7 days, the share that also swapped on each Sui DEX venue in the same window.",
      "owner": "0x0000000000000000000000000000000000000000000000000000000074696465",
      "dialect": "tide",
      "parameters": [],
      "visualization_types": [
        "bar"
      ],
      "tags": [
        "starter:af-users-overlap",
        "aftermath",
        "users"
      ],
      "is_private": false,
      "is_archived": false,
      "forked_from": null,
      "stars": 0,
      "forks": 0,
      "runs": 15,
      "starred": false,
      "last_execution_id": "0101A1A4B65B2D4A3BF5B32C7DB4D66D41",
      "last_run_at": "2026-11-04T03:59:36.750Z",
      "created_at": "2026-11-03T22:31:02.536Z",
      "updated_at": "2026-11-03T23:55:12.298Z"
    }
  ],
  "next_offset": 10
}

Long lists are cut to a few items here.