Xata · Schema
SQLRequest
SQL query request. Provide either `query` for a single query or `queries` for a batch.
DatabasePostgresServerlessDeveloper ToolsBranchingAI Agent
Properties
| Name | Type | Description |
|---|---|---|
| query | string | SQL query to execute (single query mode). |
| params | array | Positional parameters for the query (`$1`, `$2`, ...). |
| queries | array | Array of queries for batch execution within a single transaction. |
| arrayMode | boolean | Override array mode for this query (single query mode only). |
JSON Schema
{
"$schema": "http://json-schema.org/draft-07/schema#",
"title": "SQLRequest",
"description": "SQL query request. Provide either `query` for a single query or `queries` for a batch.",
"type": "object",
"properties": {
"query": {
"description": "SQL query to execute (single query mode).",
"type": "string"
},
"params": {
"description": "Positional parameters for the query (`$1`, `$2`, ...).",
"type": "array",
"items": {}
},
"queries": {
"description": "Array of queries for batch execution within a single transaction.",
"type": "array",
"items": {
"$ref": "#/components/schemas/QueryItem"
}
},
"arrayMode": {
"description": "Override array mode for this query (single query mode only).",
"type": "boolean"
}
}
}
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/xata-sqlrequest"
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.