Need help with your APIs? I offer API discovery, governance & evangelism services. Explore services →
API Evangelist API Evangelist
Discovery
Learnings
Guidance
Toolbox
Alignment
API Evangelist LLC

Xata Gateway API

PostgreSQL connectivity via HTTP SQL, WebSocket wire protocol proxy, and native wire protocol.

Xata Gateway API is one of 12 APIs that Xata publishes on the APIs.io network, described by a machine-readable OpenAPI specification.

Tagged areas include Gateway. The published artifact set on APIs.io includes an OpenAPI specification and API documentation.

This API exposes 2 operations across 2 paths, and defines 6 schemas. It is described by OpenAPI 3.0.0, at version 1.0.

Requests are made against a single base URL, https://api.xata.tech.

2 operations 2 paths 6 schemas 1 GET1 POST

Metadata

The identity and technical contract details declared by the specification.

Specification
OpenAPI 3.0.0
API Version
1.0
Base URL
https://api.xata.tech
Authentication
OpenID Connect, API Key, OAuth 2.0, API Key
Contact
help@xata.io
Resource Areas
1

Authentication & Security 4

Xata Gateway API declares 4 security schemes for authenticating requests. It supports OpenID Connect (oidc) discovered at https://auth.xata.io/realms/xata/.well-known/openid-configuration. An API key is passed in the header as Authorization (apiKey). It supports OAuth 2.0 (xata) using the implicit flow, exposing 13 scopes. An API key is passed in the header as Connection-String (branchConnectionString).

  • apiKey — API key authentication using Bearer token format: Bearer
  • branchConnectionString — Branch PostgreSQL connection string (postgres://user:pass@{branch}.{region}.xata.tech/db), including the embedded password. The hostname selects the target bra…

Paths & Operations 2

Across 2 paths, the API surfaces 2 operations — 1 GET, 1 POST. Each is listed below with its method, path, parameters, and response codes.

Gateway 2

PostgreSQL connectivity via HTTP SQL, WebSocket wire protocol proxy, and native wire protocol.

POST
/sql
Execute SQL query
query 5 params body → 200400401500507
GET
/v2
WebSocket wire protocol proxy
websocket → 101400

Schemas 6

The contract defines 6 schemas that model the data the API accepts and returns. The most detailed are ErrorResponse (17 properties), FieldDefinition (7 properties), QueryResult (5 properties), SQLRequest (4 properties). Each schema is shown below with its type and property counts.

QueryItem
object
A single query within a batch request.
3 properties 1 required
SQLRequest
object
SQL query request. Provide either query for a single query or queries for a batch.
4 properties
ErrorResponse
object
Error response with PostgreSQL error fields.
17 properties 1 required
BatchResponse
object
Response for a batch query execution.
1 property 1 required
FieldDefinition
object
PostgreSQL column metadata from the row description message.
7 properties 7 required
QueryResult
object
Result of a single SQL query execution.
5 properties 5 required

Specification

The full machine-readable OpenAPI contract behind this narrative.

Source

xata-gateway-api-openapi.yml Raw ↑

Other APIs Xata publishes across the network.

Xata API Keys API
Xata Billing API
Xata Branches API
Xata GitHub App API
Xata Logs API
Xata Marketplace API
Xata Metrics API
Xata Organizations API
Xata Projects API
Xata Projects Webhooks API
Xata Webhooks API