Skip to main content

Real-time data views,
powered by SQL

Materialize is a streaming SQL database that maintains up-to-the-second views of your data with strong consistency guarantees. Connect your data sources and query them with standard PostgreSQL.

Get StartedLearn Core Concepts
$ psql “postgres://materialize…”
CREATE SOURCE
orders FROM KAFKA
CONNECTION kafka_conn
TOPIC ‘orders’;
CREATE MATERIALIZED VIEW
revenue_by_region AS
SELECT region, SUM(amount)
FROM orders GROUP BY region;

Quick Start

Get up and running with Materialize in minutes

1

Sign up for Materialize Cloud

Create a free account at materialize.com/register or download the self-managed Community edition. Cloud accounts include 14 days of free trial credits.
2

Connect your data sources

Use native CDC connectors to stream data from PostgreSQL, MySQL, or Kafka into Materialize:
CREATE SOURCE pg_source
  FROM POSTGRES
  CONNECTION pg_connection
  FOR ALL TABLES;
3

Create materialized views

Define incrementally maintained views that stay fresh automatically:
CREATE MATERIALIZED VIEW order_totals AS
  SELECT 
    customer_id,
    COUNT(*) as order_count,
    SUM(total_amount) as lifetime_value
  FROM orders
  GROUP BY customer_id;
4

Query your data

Connect with any PostgreSQL-compatible client and query your live views:
psql "postgres://your-materialize-url"

SELECT * FROM order_totals 
WHERE lifetime_value > 1000
ORDER BY lifetime_value DESC;

Explore by Topic

Deep dive into Materialize capabilities

Core Concepts

Understand sources, materialized views, indexes, sinks, and clusters

Ingest Data

Connect PostgreSQL, MySQL, Kafka, and webhook sources to stream data

Transform Data

Use SQL to join, aggregate, and transform streaming data in real-time

Serve Results

Query results via PostgreSQL protocol or stream to Kafka sinks

SQL Reference

Complete SQL command reference with DDL, DML, and functions

Operations

Manage clusters, indexes, monitoring, and performance tuning

Deploy

Deploy on Materialize Cloud or self-manage with Kubernetes

Integrations

Work with dbt, BI tools, and PostgreSQL client libraries

Key Features

What makes Materialize different

Incremental Updates

Views update incrementally as new data arrives, processing only what changed instead of recomputing from scratch.

Strong Consistency

Query results are always correct and consistent, even when joining data from multiple sources.

Standard SQL

Use PostgreSQL-compatible SQL with support for complex joins, aggregations, window functions, and more.

Horizontal Scalability

Scale compute independently across multiple clusters to handle growing data volumes and query workloads.

Ready to get started?

Start building real-time data applications with Materialize today

Get StartedJoin Community