Materialize

Materialize HTTP API

Session-less HTTP API for executing SQL statements against a Materialize region. Authenticates with HTTP Basic (email + app password). Supports a simple mode with a single query and an extended mode that submits an array of queries, each with optional parameters. Does not support session-bound statements such as SUBSCRIBE, DECLARE, FETCH, or COPY.

GitHub

Documentation

📖
Documentation
https://materialize.com/docs/integrations/http-api/
📖
Authentication
https://materialize.com/docs/manage/access-control/

API entry from apis.yml

apis.yml Raw ↑ 
aid: materialize:materialize-http-api
name: Materialize HTTP API
humanURL: https://materialize.com/docs/integrations/http-api/
baseURL: https://{mz_host}/api/sql
tags:
- SQL
- HTTP
- Streaming
description: Session-less HTTP API for executing SQL statements against a Materialize region. Authenticates
  with HTTP Basic (email + app password). Supports a simple mode with a single query and an extended mode
  that submits an array of queries, each with optional parameters. Does not support session-bound statements
  such as SUBSCRIBE, DECLARE, FETCH, or COPY.
properties:
- type: Documentation
  url: https://materialize.com/docs/integrations/http-api/
- type: Authentication
  url: https://materialize.com/docs/manage/access-control/