CrateDB HTTP SQL Endpoint

CrateDB's native developer interface: a JSON-over-HTTP SQL endpoint. Clients POST a JSON body ({"stmt": "...", "args": [...], "bulk_args": [[...]]}) to /_sql (default port 4200) and receive cols/rows/rowcount/col_types. PostgreSQL wire protocol is also supported. Errors return a structured {"error": {"code": N, "message": "..."}} envelope with codes in the 4000-5035 range.

API entry from apis.yml

apis.yml Raw ↑
name: CrateDB HTTP SQL Endpoint
description: 'CrateDB''s native developer interface: a JSON-over-HTTP SQL endpoint. Clients POST a JSON
  body ({"stmt": "...", "args": [...], "bulk_args": [[...]]}) to /_sql (default port 4200) and receive
  cols/rows/rowcount/col_types. PostgreSQL wire protocol is also supported. Errors return a structured
  {"error": {"code": N, "message": "..."}} envelope with codes in the 4000-5035 range.'
humanURL: https://cratedb.com/docs/crate/reference/en/latest/interfaces/http.html
baseURL: https://console.cratedb.cloud
tags:
- SQL
- HTTP
- Database
properties:
- type: Documentation
  url: https://cratedb.com/docs/crate/reference/en/latest/interfaces/http.html