On-Chain SQL Table and Column Schema (All Tables)

omnial/onchain-table-schema-lookup

Takes no input and lists every blockchain and prediction-market data table that can be queried with SQL, 111 in testing: for each, its database, table name, engine type and the name and data type of every column, plus the total number of tables. Covers daily chain activity, DEX trades, token transfers, prices, yields and prediction market tables. Use it to find the right table and column names before writing a query.

activeper callv1

Price

Up to $0.0328 per call; you pay what the call used

The price shown is the price you pay. No monthly minimum. Top-ups start at $5.

Data source

Public blockchains, Kalshi and CoinGecko

Blockchain data from public chains. Prediction-market data from Kalshi. Prices powered by CoinGecko.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

agent

// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "omnial/onchain-table-schema-lookup" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "omnial/onchain-table-schema-lookup" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "omnial/onchain-table-schema-lookup", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "omnial/onchain-table-schema-lookup", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

Charge	Price
Per call	$0.0328

Updated: Oct 15, 2026

Input and output schemas

Input schema

input_schema.json

{
  "type": "object",
  "properties": {},
  "additionalProperties": false
}

Output schema

output_schema.json

{
  "type": "object",
  "properties": {
    "data": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "table": {
            "type": "string",
            "description": "The table's name."
          },
          "engine": {
            "type": "string",
            "description": "The table's engine type."
          },
          "columns": {
            "type": "array",
            "items": {
              "type": "object",
              "properties": {
                "name": {
                  "type": "string",
                  "description": "The column's name."
                },
                "type": {
                  "type": "string",
                  "description": "The column's data type."
                },
                "comment": {
                  "type": "string",
                  "description": "A note on the column, present on some columns."
                }
              }
            },
            "description": "The table's columns, in order."
          },
          "database": {
            "type": "string",
            "description": "The database the table is in."
          }
        }
      },
      "description": "One entry per table."
    },
    "meta": {
      "type": "object",
      "properties": {
        "total": {
          "type": "number",
          "description": "How many tables are listed."
        }
      }
    }
  },
  "description": "The table schemas."
}