Materialize

aid: materialize
url: https://raw.githubusercontent.com/api-evangelist/materialize/refs/heads/main/apis.yml
name: Materialize
kind: company
description: 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.
accessModel:
  pricing: freemium
  onboarding: self-serve
  trial: false
  try_now: true
  public: false
  label: Freemium · Self-serve signup
  confidence: high
  source:
  - plans
  - authentication
  generated: '2026-07-22'
  method: derived
image: https://kinlane-images.s3.amazonaws.com/shared/apis-json/icons/materialize.png
tags:
- Streaming
- Data Warehouse
- SQL
- Real-Time
- PostgreSQL Compatible
created: '2026-05-08'
modified: '2026-05-29'
specificationVersion: '0.19'
apis:
- 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/
- aid: materialize:materialize-pgwire
  name: Materialize PostgreSQL Wire Protocol
  humanURL: https://materialize.com/docs/integrations/
  baseURL: postgres://{user}@{mz_host}:6875/materialize
  tags:
  - SQL
  - PostgreSQL
  - psql
  - Wire Protocol
  description: 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.
  properties:
  - type: Documentation
    url: https://materialize.com/docs/integrations/
- aid: materialize:materialize-streaming-asyncapi
  name: Materialize Streaming Sources and Sinks (AsyncAPI)
  humanURL: https://materialize.com/docs/sql/create-source/
  baseURL: https://materialize.com/docs/
  tags:
  - Streaming
  - Kafka
  - Webhooks
  - AsyncAPI
  - Sources
  - Sinks
  description: '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.'
  properties:
  - type: AsyncAPI
    url: asyncapi/materialize-asyncapi.yml
  - type: Documentation
    url: https://materialize.com/docs/sql/create-source/kafka/
  - type: Documentation
    url: https://materialize.com/docs/sql/create-sink/kafka/
  - type: Documentation
    url: https://materialize.com/docs/sql/create-source/webhook/
  - type: Documentation
    url: https://materialize.com/docs/sql/subscribe/
- aid: materialize:materialize-sql-api
  name: Materialize Sql API
  description: The Sql API from Materialize — 1 operation(s) for sql.
  humanURL: https://materialize.com/docs/integrations/http-api/
  baseURL: https://{mz_host}/api/sql
  tags:
  - Sql
  properties:
  - type: OpenAPI
    url: openapi/materialize-sql-api-openapi.yml
common:
- type: AgenticAccess
  url: agentic-access/materialize-agentic-access.yml
- type: TrustCenter
  url: security/materialize-trust-center.yml
- type: DomainSecurity
  url: security/materialize-domain-security.yml
- type: Authentication
  url: authentication/materialize-authentication.yml
- type: GitHubOrganization
  url: https://github.com/MaterializeInc
- type: LinkedIn
  url: https://www.linkedin.com/company/materializeinc
- type: Website
  url: https://materialize.com/
- type: Portal
  url: https://materialize.com/docs/
- type: Pricing
  url: https://materialize.com/pricing
- type: Plans
  url: plans/materialize-plans-pricing.yml
- type: RateLimits
  url: rate-limits/materialize-rate-limits.yml
- type: FinOps
  url: finops/materialize-finops.yml
- url: https://materialize.com/rss.xml
  type: Blog
maintainers:
- FN: Kin Lane
  email: kin@apievangelist.com