Peaka · Schema

QueryExecuteRequest

Executes a query using the query builder. The from field is required.

Minimal example:

 { "from": [ { "catalogName": "peaka", "schemaName": "query", "tableName": "samplequery" } ] }

With columns, filters, limit, offset, and orderBy:

 { "columns": ["amount"], "from": [ { "catalogName": "wilderman_green", "schemaName": "payment", "tableName": "charges" } ], "filters": { "and": [ [ { "column": { "catalogName": "wilderman_green", "schemaName": "payment", "tableName": "charges", "columnName": "amount" } }, ">", [150] ] ] }, "limit": 50, "offset": 0, "orderBy": ["amount DESC"] }

CompanyData IntegrationAI-ReadyGovernanceAnalytics

Properties

Name	Type	Description
columns	array	Columns to select. If omitted, all columns (`*`) are returned.
from	array	Tables to query from. At least one entry is required.
limit	integer	Maximum number of rows to return.
offset	integer	Number of rows to skip before returning results.
orderBy	array	Ordering specifications. Each entry is a column name optionally followed by `ASC` or `DESC`. Example: `["amount DESC", "created_at ASC"]`.
filters	object	Filter conditions. Supports `and`/`or` logic with column comparisons.
timeout	integer	Query timeout in seconds. A query that runs longer is stopped and the request fails with error code 102. Omitted or 0: no limit. Negative values are rejected.

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "https://raw.githubusercontent.com/api-evangelist/peaka/main/json-schema/peaka-query-execute-request-schema.json",
  "title": "QueryExecuteRequest",
  "description": "Executes a query using the query builder. The <code>from</code> field is required.\n\n <p>Minimal example:\n <pre>\n {\n     \"from\": [\n         {\n             \"catalogName\": \"peaka\",\n             \"schemaName\": \"query\",\n             \"tableName\": \"samplequery\"\n         }\n     ]\n }\n </pre>\n\n <p>With columns, filters, limit, offset, and orderBy:\n <pre>\n {\n     \"columns\": [\"amount\"],\n     \"from\": [\n         {\n             \"catalogName\": \"wilderman_green\",\n             \"schemaName\": \"payment\",\n             \"tableName\": \"charges\"\n         }\n     ],\n     \"filters\": {\n         \"and\": [\n             [\n                 { \"column\": { \"catalogName\": \"wilderman_green\", \"schemaName\": \"payment\", \"tableName\": \"charges\", \"columnName\": \"amount\" } },\n                 \">\",\n                 [150]\n             ]\n         ]\n     },\n     \"limit\": 50,\n     \"offset\": 0,\n     \"orderBy\": [\"amount DESC\"]\n }\n </pre>",
  "x-generated": "2026-10-21",
  "x-method": "derived",
  "x-generator": "derive-json-schema.py",
  "x-source": "openapi/_original/peaka-api-openapi.json#/components/schemas/QueryExecuteRequest",
  "type": "object",
  "properties": {
    "columns": {
      "type": "array",
      "description": "Columns to select. If omitted, all columns (<code>*</code>) are returned.",
      "items": {
        "type": "string"
      }
    },
    "from": {
      "type": "array",
      "description": "Tables to query from. At least one entry is required.",
      "items": {
        "$ref": "#/$defs/TableForQuery"
      }
    },
    "limit": {
      "type": "integer",
      "description": "Maximum number of rows to return.",
      "format": "int64"
    },
    "offset": {
      "type": "integer",
      "description": "Number of rows to skip before returning results.",
      "format": "int64"
    },
    "orderBy": {
      "type": "array",
      "description": "Ordering specifications. Each entry is a column name optionally followed by <code>ASC</code> or <code>DESC</code>.\n Example: <code>[&quot;amount DESC&quot;, &quot;created_at ASC&quot;]</code>.",
      "items": {
        "type": "string"
      }
    },
    "filters": {
      "type": "object",
      "additionalProperties": true,
      "description": "Filter conditions. Supports <code>and</code>/<code>or</code> logic with column comparisons."
    },
    "timeout": {
      "type": "integer",
      "description": "Query timeout in seconds. A query that runs longer is stopped and the request fails with error code 102.\n Omitted or 0: no limit. Negative values are rejected.",
      "format": "int32"
    }
  },
  "$defs": {
    "TableForQuery": {
      "type": "object",
      "properties": {
        "catalogId": {
          "type": "string"
        },
        "catalogName": {
          "type": "string"
        },
        "schemaName": {
          "type": "string"
        },
        "tableName": {
          "type": "string"
        }
      }
    }
  }
}

Work with this as data

Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for schemas

4 MCP tools reach this

find_json_schemasBrowse and filter every JSON Schema in the catalog.
apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
resolveTurn a domain, URL or GitHub org into the provider it belongs to.
find_cohortsEvery scored population of providers in the catalog.

All 92 tools →

Call it yourself

curl for this page

This JSON Schema

curl "https://apis.io/api/v1/json-schemas/peaka-query-execute-request"

All schemas

curl "https://apis.io/api/v1/json-schemas?limit=25"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.