Materialize Docs
Materialize documentation for SQL syntax, data ingestion, concepts, and best practices. Use when users ask about Materialize queries, sources, sinks, views, or clusters.
Specification
- Skill ID
- materializeinc/agent-skills/materialize-docs
- Publisher
- materializeinc
- Repository
- agent-skills
- Installs
- 0
- Files
- 562
- Synced
- Sep 23, 2026
How to use it
Open any RiverX project, open the Skills panel in the chat, and search for this identifier. The files are fetched from the source repository at install time.
materializeinc/agent-skills/materialize-docsInstalls these files- README.md
- SKILL.md
- administration/billing/index.md
- administration/index.md
- administration/usage/index.md
- architecture-patterns/index.md
- architecture-patterns/live-context-graph/index.md
- architecture-patterns/ontology/index.md
- concepts/clusters/index.md
- concepts/hydration/index.md
- concepts/index.md
- concepts/indexes/index.md
- concepts/namespaces/index.md
- concepts/reaction-time/index.md
- concepts/sinks/index.md
- concepts/snapshotting/index.md
- concepts/sources/index.md
- concepts/views/index.md
- console/admin/index.md
- console/clusters/index.md
- console/connect/index.md
- console/create-new/index.md
- console/data/index.md
- console/index.md
- console/integrations/index.md
- console/monitoring/index.md
- console/sql-shell/index.md
- console/user-profile/index.md
- customer-responsibilities/index.md
- faqs/index.md
- get-started/arrangements/index.md
- get-started/index.md
- get-started/install-materialize-emulator/index.md
- get-started/install/index.md
- get-started/quickstart/index.md
- ingest-data/cdc-cockroachdb/index.md
- ingest-data/debezium/index.md
- ingest-data/fivetran/index.md
- ingest-data/index.md
- ingest-data/kafka/amazon-msk/index.md
- ingest-data/kafka/confluent-cloud/index.md
- ingest-data/kafka/index.md
- ingest-data/kafka/kafka-self-hosted/index.md
- ingest-data/kafka/source-versioning/index.md
- ingest-data/kafka/warpstream/index.md
- ingest-data/mongodb/index.md
- ingest-data/monitoring-data-ingestion/index.md
- ingest-data/mysql/amazon-aurora/index.md
- ingest-data/mysql/amazon-rds/index.md
- ingest-data/mysql/azure-db/index.md
- ingest-data/mysql/google-cloud-sql/index.md
- ingest-data/mysql/index.md
- ingest-data/mysql/mysql-debezium/index.md
- ingest-data/mysql/received-out-of-order-gtids/index.md
- ingest-data/mysql/self-hosted/index.md
- ingest-data/mysql/snapshot-parallelism/index.md
- ingest-data/mysql/source-versioning/index.md
- ingest-data/mysql/troubleshooting/index.md
- ingest-data/network-security/privatelink/index.md
- ingest-data/network-security/ssh-tunnel/index.md
- ingest-data/network-security/static-ips/index.md
- ingest-data/patterns/index.md
- ingest-data/patterns/upstream-schema-changes/index.md
- ingest-data/postgres/alloydb/index.md
- ingest-data/postgres/amazon-aurora/index.md
- ingest-data/postgres/amazon-rds/index.md
- ingest-data/postgres/azure-db/index.md
- ingest-data/postgres/cloud-sql/index.md
- ingest-data/postgres/connection-closed/index.md
- ingest-data/postgres/faq/index.md
- ingest-data/postgres/index.md
- ingest-data/postgres/logical-replica/index.md
- ingest-data/postgres/neon/index.md
- ingest-data/postgres/partitioned-tables/index.md
- ingest-data/postgres/postgres-debezium/index.md
- ingest-data/postgres/replication-slot-active/index.md
- ingest-data/postgres/self-hosted/index.md
- ingest-data/postgres/slot-overcompacted/index.md
- ingest-data/postgres/source-versioning/index.md
- ingest-data/postgres/troubleshooting/index.md
- ingest-data/redpanda/index.md
- ingest-data/redpanda/redpanda-cloud/index.md
- ingest-data/sql-server/azure-db/index.md
- ingest-data/sql-server/index.md
- ingest-data/sql-server/self-hosted/index.md
- ingest-data/sql-server/source-versioning/index.md
- ingest-data/striim/index.md
- ingest-data/troubleshooting/index.md
- ingest-data/webhooks/amazon-eventbridge/index.md
- ingest-data/webhooks/change-included-headers/index.md
- ingest-data/webhooks/hubspot/index.md
- ingest-data/webhooks/rudderstack/index.md
- ingest-data/webhooks/segment/index.md
- ingest-data/webhooks/snowcatcloud/index.md
- ingest-data/webhooks/stripe/index.md
- ingest-data/webhooks/webhook-quickstart/index.md
- integrations/adbc/index.md
- integrations/cli/configuration/index.md
- integrations/cli/index.md
- integrations/cli/installation/index.md
- integrations/cli/reference/app-password/index.md
- integrations/cli/reference/config/index.md
- integrations/cli/reference/index.md
- integrations/cli/reference/profile/index.md
- integrations/cli/reference/region/index.md
- integrations/cli/reference/secret/index.md
- integrations/cli/reference/sql/index.md
- integrations/cli/reference/user/index.md
- integrations/client-libraries/golang/index.md
- integrations/client-libraries/index.md
- integrations/client-libraries/java-jdbc/index.md
- integrations/client-libraries/node-js/index.md
- integrations/client-libraries/php/index.md
- integrations/client-libraries/python/index.md
- integrations/client-libraries/ruby/index.md
- integrations/client-libraries/rust/index.md
- integrations/coding-agent-skills/index.md
- integrations/connection-pooling/index.md
- integrations/fdw/index.md
- integrations/http-api/index.md
- integrations/index.md
- integrations/mcp-server/index.md
- integrations/mcp-server/mcp
- integrations/mcp-server/mcp-agent-config/index.md
- integrations/mcp-server/mcp-agent-tools/index.md
- integrations/mcp-server/mcp-agent/index.md
- integrations/mcp-server/mcp-developer-config/index.md
- integrations/mcp-server/mcp-developer-tools/index.md
- integrations/mcp-server/mcp-developer/index.md
- integrations/mcp-server/mcp-server-troubleshooting/index.md
- integrations/mz-debug/emulator/index.md
- integrations/mz-debug/index.md
- integrations/mz-debug/self-managed/index.md
- integrations/sql-clients/index.md
- integrations/websocket-api/index.md
- license/index.md
- manage/appendix-alternative-cluster-architectures/index.md
- manage/dbt/blue-green-deployments/index.md
- manage/dbt/development-workflows/index.md
- manage/dbt/get-started/index.md
- manage/dbt/index.md
- manage/dbt/slim-deployments/index.md
- manage/disaster-recovery/index.md
- manage/disaster-recovery/recovery-characteristics/index.md
- manage/index.md
- manage/monitor/appendix-metrics/index.md
- manage/monitor/cloud/alerting/index.md
- manage/monitor/cloud/datadog/index.md
- manage/monitor/cloud/grafana/index.md
- manage/monitor/cloud/index.md
- manage/monitor/essential-metrics/index.md
- manage/monitor/index.md
- manage/monitor/replica-resource-usage/index.md
- manage/monitor/self-managed/alerting/index.md
- manage/monitor/self-managed/datadog/index.md
- manage/monitor/self-managed/google-cloud-monitoring/index.md
- manage/monitor/self-managed/grafana/index.md
- manage/monitor/self-managed/honeycomb/index.md
- manage/monitor/self-managed/index.md
- manage/monitor/self-managed/opentelemetry/index.md
- manage/monitor/self-managed/prometheus-remote-write/index.md
- manage/monitor/self-managed/storage/index.md
- manage/mz-deploy/agent-setup/index.md
- manage/mz-deploy/deployments/index.md
- manage/mz-deploy/editor-setup/index.md
- manage/mz-deploy/get-started/index.md
- manage/mz-deploy/index.md
- manage/mz-deploy/infrastructure/index.md
- manage/mz-deploy/local-development/index.md
- manage/mz-deploy/profiles/index.md
- manage/mz-deploy/project-structure/index.md
- manage/mz-deploy/stable-apis/index.md
- manage/operational-guidelines/index.md
- manage/terraform/appendix-secret-stores/index.md
- manage/terraform/get-started/index.md
- manage/terraform/index.md
- manage/terraform/manage-cloud-modules/index.md
- manage/terraform/manage-rbac/index.md
- manage/terraform/manage-resources/index.md
- reference/explain-plan-operators/index.md
- reference/index.md
- reference/isolation-level/index.md
- reference/m1-cc-mapping/index.md
- reference/performance/index.md
- reference/system-catalog/index.md
- reference/system-catalog/information_schema/index.md
- reference/system-catalog/mz_catalog/index.md
- reference/system-catalog/mz_internal/index.md
- reference/system-catalog/mz_introspection/index.md
- reference/system-catalog/pg_catalog/index.md
- reference/system-clusters/index.md
- references/README.md
- releases/index.md
- releases/schedule/index.md
- releases/v0.100/index.md
- releases/v0.101/index.md
- releases/v0.106/index.md
- releases/v0.107/index.md
- releases/v0.108/index.md
- releases/v0.27/index.md
- releases/v0.28/index.md
- releases/v0.29/index.md
- releases/v0.30/index.md
- releases/v0.31/index.md
- releases/v0.32/index.md
- releases/v0.33/index.md
- releases/v0.36/index.md
- releases/v0.37/index.md
- releases/v0.38/index.md
- releases/v0.39/index.md
- releases/v0.40/index.md
- releases/v0.41/index.md
- releases/v0.42/index.md
- releases/v0.43/index.md
- releases/v0.44/index.md
- releases/v0.45/index.md
- releases/v0.46/index.md
- releases/v0.47/index.md
- releases/v0.48/index.md
- releases/v0.49/index.md
- releases/v0.50/index.md
- releases/v0.51/index.md
- releases/v0.52/index.md
- releases/v0.53/index.md
- releases/v0.54/index.md
- releases/v0.55/index.md
- releases/v0.56/index.md
- releases/v0.57/index.md
- releases/v0.58/index.md
- releases/v0.59/index.md
- releases/v0.60/index.md
- releases/v0.61/index.md
- releases/v0.62/index.md
- releases/v0.63/index.md
- releases/v0.64/index.md
- releases/v0.65/index.md
- releases/v0.66/index.md
- releases/v0.67/index.md
- releases/v0.68/index.md
- releases/v0.69/index.md
- releases/v0.70/index.md
- releases/v0.71/index.md
- releases/v0.72/index.md
- releases/v0.73/index.md
- releases/v0.74/index.md
- releases/v0.75/index.md
- releases/v0.76/index.md
- releases/v0.77/index.md
- releases/v0.78/index.md
- releases/v0.79/index.md
- releases/v0.80/index.md
- releases/v0.81/index.md
- releases/v0.82/index.md
- releases/v0.83/index.md
- releases/v0.84/index.md
- releases/v0.85/index.md
- releases/v0.86/index.md
- releases/v0.87/index.md
- releases/v0.88/index.md
- releases/v0.89/index.md
- releases/v0.90/index.md
- releases/v0.91/index.md
- releases/v0.92/index.md
- releases/v0.93/index.md
- releases/v0.94/index.md
- releases/v0.95/index.md
- releases/v0.96/index.md
- releases/v0.97/index.md
- releases/v0.98/index.md
- releases/v0.99/index.md
- security/appendix/appendix-built-in-roles/index.md
- security/appendix/appendix-command-privileges/index.md
- security/appendix/appendix-privileges/index.md
- security/appendix/index.md
- security/cloud/access-control/index.md
- security/cloud/access-control/manage-roles/index.md
- security/cloud/index.md
- security/cloud/manage-network-policies/index.md
- security/cloud/users-service-accounts/create-service-accounts/index.md
- security/cloud/users-service-accounts/index.md
- security/cloud/users-service-accounts/invite-users/index.md
- security/cloud/users-service-accounts/sso/index.md
- security/cloud/users-service-accounts/sync-idp-groups/index.md
- security/index.md
- security/self-managed/access-control/index.md
- security/self-managed/access-control/manage-roles/index.md
- security/self-managed/authentication/index.md
- security/self-managed/index.md
- security/self-managed/sso-migration/index.md
- security/self-managed/sso/index.md
- self-managed-deployments/appendix/appendix-cluster-sizes/index.md
- self-managed-deployments/appendix/index.md
- self-managed-deployments/appendix/upgrade-to-swap/index.md
- self-managed-deployments/configuration-system-parameters/index.md
- self-managed-deployments/deployment-guidelines/aws-deployment-guidelines/index.md
- self-managed-deployments/deployment-guidelines/azure-deployment-guidelines/index.md
- self-managed-deployments/deployment-guidelines/gcp-deployment-guidelines/index.md
- self-managed-deployments/deployment-guidelines/gke-node-pool-upgrades/index.md
- self-managed-deployments/deployment-guidelines/index.md
- self-managed-deployments/deployment-guidelines/resize-node-pools/index.md
- self-managed-deployments/faq/index.md
- self-managed-deployments/index.md
- self-managed-deployments/installation/index.md
- self-managed-deployments/installation/install-on-aws/index.md
- self-managed-deployments/installation/install-on-azure/index.md
- self-managed-deployments/installation/install-on-gcp/index.md
- self-managed-deployments/installation/install-on-local-kind/index.md
- self-managed-deployments/materialize-crd-field-descriptions/index.md
- self-managed-deployments/materialize-crd-field-descriptions/v1/index.md
- self-managed-deployments/materialize-crd-field-descriptions/v1alpha1/index.md
- self-managed-deployments/operator-configuration/index.md
- self-managed-deployments/release-versions/index.md
- self-managed-deployments/troubleshooting/index.md
- self-managed-deployments/upgrading/adopting-the-v1-crd/index.md
- self-managed-deployments/upgrading/index.md
- self-managed-deployments/upgrading/upgrade-on-aws/index.md
- self-managed-deployments/upgrading/upgrade-on-azure/index.md
- self-managed-deployments/upgrading/upgrade-on-gcp/index.md
- self-managed-deployments/upgrading/upgrade-on-kind/index.md
- self-managed-deployments/upgrading/version-notes/index.md
- serve-results/bi-tools/deepnote/index.md
- serve-results/bi-tools/excel/index.md
- serve-results/bi-tools/hex/index.md
- serve-results/bi-tools/index.md
- serve-results/bi-tools/looker/index.md
- serve-results/bi-tools/metabase/index.md
- serve-results/bi-tools/power-bi/index.md
- serve-results/bi-tools/tableau/index.md
- serve-results/fdw/index.md
- serve-results/index.md
- serve-results/query-results/index.md
- serve-results/sink/census/index.md
- serve-results/sink/elasticsearch/index.md
- serve-results/sink/iceberg-aws/index.md
- serve-results/sink/iceberg-databricks/index.md
- serve-results/sink/iceberg-gcp/index.md
- serve-results/sink/iceberg/index.md
- serve-results/sink/index.md
- serve-results/sink/kafka/index.md
- serve-results/sink/opensearch/index.md
- serve-results/sink/s3/index.md
- serve-results/sink/s3_compatible/index.md
- serve-results/sink/sink-troubleshooting/index.md
- serve-results/sink/snowflake/index.md
- serve-results/sink/turbopuffer/index.md
- sql/alter-cluster-replica/index.md
- sql/alter-cluster/index.md
- sql/alter-connection/index.md
- sql/alter-database/index.md
- sql/alter-default-privileges/index.md
- sql/alter-index/index.md
- sql/alter-materialized-view/index.md
- sql/alter-network-policy/index.md
- sql/alter-role/index.md
- sql/alter-schema/index.md
- sql/alter-secret/index.md
- sql/alter-sink/index.md
- sql/alter-source/index.md
- sql/alter-system-reset/index.md
- sql/alter-system-set/index.md
- sql/alter-table/index.md
- sql/alter-type/index.md
- sql/alter-view/index.md
- sql/begin/index.md
- sql/close/index.md
- sql/comment-on/index.md
- sql/commit/index.md
- sql/copy-from/index.md
- sql/copy-to/index.md
- sql/create-cluster-replica/index.md
- sql/create-cluster/index.md
- sql/create-connection/index.md
- sql/create-database/index.md
- sql/create-index/index.md
- sql/create-materialized-view/index.md
- sql/create-network-policy/index.md
- sql/create-role/index.md
- sql/create-schema/index.md
- sql/create-secret/index.md
- sql/create-sink/iceberg/index.md
- sql/create-sink/index.md
- sql/create-sink/kafka/index.md
- sql/create-source/index.md
- sql/create-source/kafka-v2/index.md
- sql/create-source/kafka/index.md
- sql/create-source/load-generator/index.md
- sql/create-source/mysql-v2/index.md
- sql/create-source/mysql/index.md
- sql/create-source/postgres-v2/index.md
- sql/create-source/postgres/index.md
- sql/create-source/sql-server-v2/index.md
- sql/create-source/sql-server/index.md
- sql/create-source/webhook/index.md
- sql/create-table/index.md
- sql/create-table/kafka/index.md
- sql/create-table/mysql/index.md
- sql/create-table/postgres/index.md
- sql/create-table/sql-server/index.md
- sql/create-table/user-populated/index.md
- sql/create-type/index.md
- sql/create-view/index.md
- sql/deallocate/index.md
- sql/declare/index.md
- sql/delete/index.md
- sql/discard/index.md
- sql/drop-cluster-replica/index.md
- sql/drop-cluster/index.md
- sql/drop-connection/index.md
- sql/drop-database/index.md
- sql/drop-index/index.md
- sql/drop-materialized-view/index.md
- sql/drop-network-policy/index.md
- sql/drop-owned/index.md
- sql/drop-role/index.md
- sql/drop-schema/index.md
- sql/drop-secret/index.md
- sql/drop-sink/index.md
- sql/drop-source/index.md
- sql/drop-table/index.md
- sql/drop-type/index.md
- sql/drop-user/index.md
- sql/drop-view/index.md
- sql/execute-unit-test/index.md
- sql/execute/index.md
- sql/explain-analyze/index.md
- sql/explain-filter-pushdown/index.md
- sql/explain-plan/index.md
- sql/explain-schema/index.md
- sql/explain-timestamp/index.md
- sql/fetch/index.md
- sql/functions/array_agg/index.md
- sql/functions/cast/index.md
- sql/functions/coalesce/index.md
- sql/functions/csv_extract/index.md
- sql/functions/date-bin/index.md
- sql/functions/date-part/index.md
- sql/functions/date-trunc/index.md
- sql/functions/datediff/index.md
- sql/functions/encode/index.md
- sql/functions/extract/index.md
- sql/functions/filters/index.md
- sql/functions/index.md
- sql/functions/jsonb_agg/index.md
- sql/functions/jsonb_object_agg/index.md
- sql/functions/justify-days/index.md
- sql/functions/justify-hours/index.md
- sql/functions/justify-interval/index.md
- sql/functions/length/index.md
- sql/functions/list_agg/index.md
- sql/functions/map_agg/index.md
- sql/functions/normalize/index.md
- sql/functions/now_and_mz_now/index.md
- sql/functions/pushdown/index.md
- sql/functions/string_agg/index.md
- sql/functions/substring/index.md
- sql/functions/table-functions/index.md
- sql/functions/timezone-and-at-time-zone/index.md
- sql/functions/to_char/index.md
- sql/grant-privilege/index.md
- sql/grant-role/index.md
- sql/identifiers/index.md
- sql/index.md
- sql/insert/index.md
- sql/namespaces/index.md
- sql/prepare/index.md
- sql/reassign-owned/index.md
- sql/reset/index.md
- sql/revoke-privilege/index.md
- sql/revoke-role/index.md
- sql/rollback/index.md
- sql/select/index.md
- sql/select/join/index.md
- sql/select/recursive-ctes/index.md
- sql/set/index.md
- sql/show-cluster-replicas/index.md
- sql/show-clusters/index.md
- sql/show-columns/index.md
- sql/show-connections/index.md
- sql/show-create-cluster/index.md
- sql/show-create-connection/index.md
- sql/show-create-index/index.md
- sql/show-create-materialized-view/index.md
- sql/show-create-sink/index.md
- sql/show-create-source/index.md
- sql/show-create-table/index.md
- sql/show-create-type/index.md
- sql/show-create-view/index.md
- sql/show-databases/index.md
- sql/show-default-privileges/index.md
- sql/show-indexes/index.md
- sql/show-materialized-views/index.md
- sql/show-network-policies/index.md
- sql/show-objects/index.md
- sql/show-privileges/index.md
- sql/show-role-membership/index.md
- sql/show-roles/index.md
- sql/show-schemas/index.md
- sql/show-secrets/index.md
- sql/show-sinks/index.md
- sql/show-sources/index.md
- sql/show-subsources/index.md
- sql/show-tables/index.md
- sql/show-types/index.md
- sql/show-views/index.md
- sql/show/index.md
- sql/subscribe/index.md
- sql/table/index.md
- sql/types/array/index.md
- sql/types/boolean/index.md
- sql/types/bytea/index.md
- sql/types/date/index.md
- sql/types/float/index.md
- sql/types/index.md
- sql/types/integer/index.md
- sql/types/interval/index.md
- sql/types/jsonb/index.md
- sql/types/list/index.md
- sql/types/map/index.md
- sql/types/mz_aclitem/index.md
- sql/types/mz_timestamp/index.md
- sql/types/numeric/index.md
- sql/types/oid/index.md
- sql/types/record/index.md
- sql/types/text/index.md
- sql/types/time/index.md
- sql/types/timestamp/index.md
- sql/types/uint/index.md
- sql/types/uuid/index.md
- sql/update/index.md
- sql/validate-connection/index.md
- sql/values/index.md
- support/index.md
- transform-data/dataflow-troubleshooting/index.md
- transform-data/dictionary-compression/index.md
- transform-data/faq/index.md
- transform-data/freshness-troubleshooting/index.md
- transform-data/idiomatic-materialize-sql/any/index.md
- transform-data/idiomatic-materialize-sql/appendix/example-orders/index.md
- transform-data/idiomatic-materialize-sql/appendix/idiomatic-sql-chart/index.md
- transform-data/idiomatic-materialize-sql/appendix/index.md
- transform-data/idiomatic-materialize-sql/appendix/window-function-to-materialize/index.md
- transform-data/idiomatic-materialize-sql/first-value/index.md
- transform-data/idiomatic-materialize-sql/index.md
- transform-data/idiomatic-materialize-sql/lag/index.md
- transform-data/idiomatic-materialize-sql/last-value/index.md
- transform-data/idiomatic-materialize-sql/lead/index.md
- transform-data/idiomatic-materialize-sql/mz_now/index.md
- transform-data/idiomatic-materialize-sql/not-in/index.md
- transform-data/idiomatic-materialize-sql/top-k/index.md
- transform-data/index.md
- transform-data/monitor-freshness/index.md
- transform-data/optimization/index.md
- transform-data/patterns/durable-subscriptions/index.md
- transform-data/patterns/index.md
- transform-data/patterns/partition-by/index.md
- transform-data/patterns/percentiles/index.md
- transform-data/patterns/refresh-strategies/index.md
- transform-data/patterns/rules-engine/index.md
- transform-data/patterns/temporal-filters/index.md
- transform-data/troubleshooting/index.md
- transform-data/updating-materialized-views/index.md
- transform-data/updating-materialized-views/replace-materialized-view/index.md
What this skill tells the agent
Materialize Documentation
This skill provides comprehensive documentation for Materialize, a streaming database for real-time analytics.
How to Use This Skill
When a user asks about Materialize:
- For SQL syntax/commands: Read files in the
sql/directory - For core concepts: Read files in the
concepts/directory - For data ingestion: Read files in the
ingest-data/directory - For transformations: Read files in the
transform-data/directory
Documentation Sections
Administrations
- Usage (Self-Managed):
administration/usage/index.md - Usage & billing (Cloud):
administration/billing/index.md
Architecture Patterns
Patterns for building with Materialize.
- Live Context Graph:
architecture-patterns/live-context-graph/index.md - Use an ontology table:
architecture-patterns/ontology/index.md
Concepts
Learn about the core concepts in Materialize.
- Namespaces:
concepts/namespaces/index.md - Clusters:
concepts/clusters/index.md - Hydration:
concepts/hydration/index.md - Indexes:
concepts/indexes/index.md - Reaction Time, Freshness, and Query Latency:
concepts/reaction-time/index.md - Sinks:
concepts/sinks/index.md - Snapshotting:
concepts/snapshotting/index.md - Sources:
concepts/sources/index.md - Views:
concepts/views/index.md
Ingest data
Best practices for ingesting data into Materialize from external systems.
- Amazon EventBridge:
ingest-data/webhooks/amazon-eventbridge/index.md - AWS PrivateLink connections (Cloud-only):
ingest-data/network-security/privatelink/index.md - Change a webhook source's included headers:
ingest-data/webhooks/change-included-headers/index.md - CockroachDB CDC using Kafka and Changefeeds:
ingest-data/cdc-cockroachdb/index.md - Debezium:
ingest-data/debezium/index.md - Fivetran:
ingest-data/fivetran/index.md - HubSpot:
ingest-data/webhooks/hubspot/index.md - Kafka:
ingest-data/kafka/index.md - MongoDB:
ingest-data/mongodb/index.md - Monitoring data ingestion:
ingest-data/monitoring-data-ingestion/index.md - _(and 14 more files in this section)_
Manage Materialize
- Appendix: Alternative cluster architectures:
manage/appendix-alternative-cluster-architectures/index.md - Disaster recovery (Cloud):
manage/disaster-recovery/index.md - Monitoring and alerting:
manage/monitor/index.md - Operational guidelines:
manage/operational-guidelines/index.md - Use dbt to manage Materialize:
manage/dbt/index.md - Use mz-deploy to manage Materialize:
manage/mz-deploy/index.md - Use Terraform to manage Materialize:
manage/terraform/index.md
Materialize console
Introduction to the Materialize Console, user interface for Materialize
- Admin (Cloud-only):
console/admin/index.md - Clusters:
console/clusters/index.md - Connect (Cloud-only):
console/connect/index.md - Create new:
console/create-new/index.md - Database object explorer:
console/data/index.md - Integrations:
console/integrations/index.md - Monitoring:
console/monitoring/index.md - SQL Shell:
console/sql-shell/index.md - User profile:
console/user-profile/index.md
Overview
Learn how to efficiently transform data using Materialize SQL.
- Dataflow troubleshooting:
transform-data/dataflow-troubleshooting/index.md - Dictionary compression:
transform-data/dictionary-compression/index.md - FAQ: Indexes:
transform-data/faq/index.md - Freshness troubleshooting:
transform-data/freshness-troubleshooting/index.md - How to monitor freshness in Materialize:
transform-data/monitor-freshness/index.md - Idiomatic Materialize SQL:
transform-data/idiomatic-materialize-sql/index.md - Optimization:
transform-data/optimization/index.md - Patterns:
transform-data/patterns/index.md - Troubleshooting:
transform-data/troubleshooting/index.md - Updating materialized views:
transform-data/updating-materialized-views/index.md
References
- Explain plan operators:
reference/explain-plan-operators/index.md - Ingestion performance:
reference/performance/index.md - Isolation levels:
reference/isolation-level/index.md - M.1 to cc size mapping:
reference/m1-cc-mapping/index.md - System catalog:
reference/system-catalog/index.md - System clusters:
reference/system-clusters/index.md
Security
- Appendix:
security/appendix/index.md - Cloud:
security/cloud/index.md - Self-managed:
security/self-managed/index.md
Self-Managed Deployments
Learn about the key components and architecture of self-managed Materialize deployments.
- Appendix:
self-managed-deployments/appendix/index.md - Configuring System Parameters:
self-managed-deployments/configuration-system-parameters/index.md - Deployment guidelines:
self-managed-deployments/deployment-guidelines/index.md - FAQ:
self-managed-deployments/faq/index.md - Installation:
self-managed-deployments/installation/index.md - Materialize CRD Field Descriptions:
self-managed-deployments/materialize-crd-field-descriptions/index.md - Materialize Operator Configuration:
self-managed-deployments/operator-configuration/index.md - Self-managed release versions:
self-managed-deployments/release-versions/index.md - Troubleshooting:
self-managed-deployments/troubleshooting/index.md - Upgrading:
self-managed-deployments/upgrading/index.md
Serve results
Serving results from Materialize
- `SELECT` and `SUBSCRIBE`:
serve-results/query-results/index.md - Sink results:
serve-results/sink/index.md - Use BI/data collaboration tools:
serve-results/bi-tools/index.md - Use foreign data wrapper (FDW):
serve-results/fdw/index.md
SQL commands
SQL commands reference.
- Namespaces:
sql/namespaces/index.md - ALTER CLUSTER:
sql/alter-cluster/index.md - ALTER CLUSTER REPLICA:
sql/alter-cluster-replica/index.md - ALTER CONNECTION:
sql/alter-connection/index.md - ALTER DATABASE:
sql/alter-database/index.md - ALTER DEFAULT PRIVILEGES:
sql/alter-default-privileges/index.md - ALTER INDEX:
sql/alter-index/index.md - ALTER MATERIALIZED VIEW:
sql/alter-materialized-view/index.md - ALTER NETWORK POLICY (Cloud):
sql/alter-network-policy/index.md - ALTER ROLE:
sql/alter-role/index.md - _(and 109 more files in this section)_
Tools and integrations
Get details about third-party tools and integrations supported by Materialize
- ADBC (Arrow Database Connectivity):
integrations/adbc/index.md - Agent Skills:
integrations/coding-agent-skills/index.md - Client libraries:
integrations/client-libraries/index.md - Connect to Materialize via HTTP:
integrations/http-api/index.md - Connect to Materialize via WebSocket:
integrations/websocket-api/index.md - Connection Pooling:
integrations/connection-pooling/index.md - Foreign data wrapper (FDW) :
integrations/fdw/index.md - MCP Servers and agent skills:
integrations/mcp-server/index.md - mz - Materialize CLI:
integrations/cli/index.md - mz-debug:
integrations/mz-debug/index.md - _(and 1 more files in this section)_
Quick Reference
Common SQL Commands
| Command | Description |
|---|---|
CREATE SOURCE | Connect to external data sources (Kafka, PostgreSQL, MySQL) |
CREATE MATERIALIZED VIEW | Create incrementally maintained views |
CREATE INDEX | Create indexes on views for faster queries |
CREATE SINK | Export data to external systems |
SELECT | Query data from sources, views, and tables |
Key Concepts
- Sources: Connections to external data systems that stream data into Materialize
- Materialized Views: Views that are incrementally maintained as source data changes
Use this skill in a project
Open any RiverX project, search the Skills panel for materializeinc/agent-skills/materialize-docs, and install it in one click.