Properties
| Name | Type | Description |
|---|---|---|
| sql | string | SQL query to execute |
| project | string | Project name to query |
| offset | integer | Result offset for pagination |
| limit | integer | Maximum number of results |
| acceptPartial | boolean | Accept partial results if query times out |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/apache-kylin/refs/heads/main/json-schema/rest-api-query-request-schema.json",
"title": "QueryRequest",
"description": "SQL query request",
"type": "object",
"properties": {
"sql": {
"type": "string",
"description": "SQL query to execute",
"example": "SELECT count(*) FROM kylin_sales"
},
"project": {
"type": "string",
"description": "Project name to query",
"example": "learn_kylin"
},
"offset": {
"type": "integer",
"description": "Result offset for pagination",
"example": 0
},
"limit": {
"type": "integer",
"description": "Maximum number of results",
"example": 50000
},
"acceptPartial": {
"type": "boolean",
"description": "Accept partial results if query times out",
"example": true
}
},
"required": [
"sql",
"project"
]
}
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.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/rest-api-query-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.
A second provider on the same verified email joins the account you already have.