7,363 open-source and SaaS tools, with GitHub stats refreshed every day.

Materialize

Open source

Materialize is a streaming SQL database that keeps views over live data continuously up to date, for operational dashboards, AI context and read offload.

materialize.com
Materialize homepage screenshot
GitHub stars
6.4k
Last commit
today
Repository age
7 years
Version
v26.43.0
Licence
Custom
Self-hosted
Yes

About Materialize

Materialize is a streaming data platform that builds incrementally updated, consistent views over transactional data from across an organization. Users define views in SQL, and Materialize keeps the results fresh as new data arrives, so applications and AI agents can read current answers without custom pipelines.

It speaks a PostgreSQL-compatible SQL dialect and ingests change data from sources such as Kafka, PostgreSQL, MySQL and SQL Server through change data capture. The README names common adoption patterns, including query offload in a CQRS style, where complex reads move off the main database, plus fresh context for AI and RAG pipelines, operational dashboards and more dynamic customer experiences. The engine is written in Rust.

The source is published under terms that GitHub lists as 'Other', which reflects a source-available model rather than a standard open-source license, and Materialize can be deployed wherever your infrastructure runs. A managed cloud service from the vendor is also available.

Key features

  • Incrementally maintained materialized views in SQL
  • PostgreSQL-compatible SQL interface
  • Change data capture from Postgres, MySQL and SQL Server
  • Kafka streaming ingestion
  • Query offload from transactional databases
  • Fresh data for AI and RAG pipelines

Good fit for

  • →Live operational dashboards
  • →Offloading heavy read queries
  • →Real-time context for AI agents
Tags
streaming
sql
materialized-views
cdc
kafka
database
real-time
rust

Materialize: questions and answers

What is Materialize used for?
Materialize is a streaming SQL database that keeps views over live data continuously up to date, for operational dashboards, AI context and read offload. It is a good fit for live operational dashboards, offloading heavy read queries and real-time context for AI agents.
Is Materialize open source?
Yes. Materialize is open source under a custom licence. Its source code is on GitHub at MaterializeInc/materialize and is written mainly in Rust.
Is Materialize free?
Yes. Materialize is open source, so the software itself is free to use under the terms of its own licence. A managed cloud version is also available.
Can I self-host Materialize?
Yes. Materialize can be self-hosted on your own server or infrastructure.
What are some alternatives to Materialize?
Similar open-source tools in the Databases category include ClickHouse, SurrealDB and QuestDB. SaaS products in the same category include Aerospike, Cloudflare D1 and Instaclustr.
Is Materialize actively maintained?
Yes. The most recent commit to Materialize was on 2 October 2026, and the latest release is v26.43.0, published on 24 September 2026. The project has 6.4k stars on GitHub.

Open-source alternatives to Materialize

See all

SaaS alternatives to Materialize

See all