Materialize

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.

3 APIs 0 Features

StreamingData WarehouseSQLReal-TimePostgreSQL Compatible

APIs

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...

Materialize PostgreSQL Wire Protocol

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.

Materialize Streaming Sources and Sinks (AsyncAPI)

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 webh...

Collections

Materialize HTTP API

OPEN

Pricing Plans

Materialize Plans Pricing

3 plans

PLANS

Rate Limits

Materialize Rate Limits

5 limits

RATE LIMITS

FinOps

Materialize Finops

FINOPS

Event Specifications

Materialize Streaming Sources and Sinks

AsyncAPI description of Materialize's streaming integration surface. Materialize is an operational data warehouse that ingests events from external message brokers and HTTP webh...

ASYNCAPI

Resources

👥

GitHubOrganization

Sources

opencollection: 1.0.0
info:
  name: Materialize HTTP API
  version: v1
request:
  auth:
    type: basic
    username: '{{username}}'
    password: '{{password}}'
items:
- info:
    name: Execute SQL statements
    type: http
  http:
    method: POST
    url: https://{mz_host}/api/sql
    params:
    - name: options
      value: ''
      type: query
      description: 'URL-encoded JSON object of session configuration parameters

        (e.g. `cluster`, `application_name`).

        '
    body:
      type: json
      data: '{}'
  docs: Execute SQL statements
bundled: true