Xata · Example Payload

Xata Sql Response Example

DatabasePostgresServerlessDeveloper ToolsBranchingAI Agent

Xata Sql Response Example is an example object payload from Xata, with 1 top-level field. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

results

Example Payload

{
  "results": [
    {
      "columns": [
        {
          "name": "id",
          "type": "text"
        },
        {
          "name": "name",
          "type": "text"
        },
        {
          "name": "created_at",
          "type": "timestamptz"
        }
      ],
      "rows": [
        [
          "usr_01",
          "Alice",
          "2025-01-15T10:00:00Z"
        ],
        [
          "usr_02",
          "Bob",
          "2025-02-20T14:30:00Z"
        ]
      ]
    },
    {
      "columns": [
        {
          "name": "count",
          "type": "int8"
        }
      ],
      "rows": [
        [
          "5"
        ]
      ]
    }
  ]
}

Work with this as data

Every example 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 examples

4 MCP tools reach this

find_examplesBrowse and filter every example 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 example

curl "https://apis.io/api/v1/examples/xata-sql-response-example"

All examples

curl "https://apis.io/api/v1/examples?limit=25"

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

Get an API key

Free tier, no email required.

GitHub Google LinkedIn

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