Materialize Documentation
Join the Community github/materialize

System catalog

Materialize exposes a system catalog that contains metadata about the running Materialize instance.

The system catalog consists of four schemas that are implicitly available in all databases. These schemas contain sources, tables, and views that expose different types of metadata.

These schemas contain sources, tables, and views that expose metadata like:

Whenever possible, applications should prefer to query mz_catalog over pg_catalog. The mapping between Materialize concepts and PostgreSQL concepts is not one-to-one, and so the data in pg_catalog cannot accurately represent the particulars of Materialize.