Materialize is an operational data warehouse that uses streaming SQL views maintained with sub-second latency. It exposes a PostgreSQL wire-compatible interface and a session-less HTTP API for SQL execution.
APIs.json: https://raw.githubusercontent.com/api-evangelist/materialize/refs/heads/main/apis.yml
- Streaming
- Data Warehouse
- SQL
- Real-Time
- PostgreSQL Compatible
- Created: 2026-05-08
- Modified: 2026-05-29
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.
- Human URL: https://materialize.com/docs/integrations/http-api/
- Base URL:
https://{mz_host}/api/sql
- SQL
- HTTP
- Streaming
- Documentation
- Authentication
- Postman Collection — Postman Collection 2.1
- Open Collection — Open Collection 1.0
Materialize speaks the PostgreSQL wire protocol on port 6875, so any psql or libpq-based client (Go, Java, Node.js, PHP, Python, Ruby, Rust) can connect and run streaming SQL.
- Human URL: https://materialize.com/docs/integrations/
- Base URL:
postgres://{user}@{mz_host}:6875/materialize
- SQL
- PostgreSQL
- psql
- Wire Protocol
AsyncAPI 2.6 description of Materialize's event-driven integration surface: Kafka sources (CREATE SOURCE ... FROM KAFKA), Kafka sinks (CREATE SINK ... INTO KAFKA), and HTTP webhook sources (CREATE SOURCE ... FROM WEBHOOK). SUBSCRIBE is documented in the spec as an informational pgwire server only; AsyncAPI 2.6 has no standard binding for the PostgreSQL wire protocol, so it is intentionally not modelled as a channel.
- Human URL: https://materialize.com/docs/sql/create-source/
- Base URL:
https://materialize.com/docs/
- Streaming
- Kafka
- Webhooks
- AsyncAPI
- Sources
- Sinks
- AsyncAPI — AsyncAPI Specification
- Documentation
- Documentation
- Documentation
- Documentation
- Postman Collection — Postman Collection 2.1
- Open Collection — Open Collection 1.0
FN: Kin Lane Email: kin@apievangelist.com