{{- /* Home page template - generates SKILL.md for Claude */ -}}

name: materialize-docs description: Materialize documentation for SQL syntax, data ingestion, concepts, and best practices. Use when users ask about Materialize queries, sources, sinks, views, or clusters.

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:

1. For SQL syntax/commands: Read files in the

   sql/

   directory
2. For core concepts: Read files in the

   concepts/

   directory
3. For data ingestion: Read files in the

   ingest-data/

   directory
4. For transformations: Read files in the

   transform-data/

   directory

Documentation Sections

{{- range .Site.Sections }} {{- $sectionName := .Section }} {{- if not (in (slice "releases" "self-managed" "about" "get-started") $sectionName) }}

{{ .Title }}

{{- with .Description }} {{ . }} {{- end }} {{ range .Pages | first 10 }}

• {{ .Title }}:

  {{ strings.TrimPrefix "/" .RelPermalink }}

  {{- end }} {{- if gt (len .Pages) 10 }}
• (and {{ sub (len .Pages) 10 }} more files in this section) {{- end }} {{- end }} {{- end }}

Quick Reference

Common SQL Commands

CREATE SOURCE

CREATE MATERIALIZED VIEW

CREATE INDEX

CREATE SINK

SELECT

Key Concepts

• Sources: Connections to external data systems that stream data into Materialize
• Materialized Views: Views that are incrementally maintained as source data changes
• Indexes: Arrangements of data in memory for fast point lookups
• Clusters: Isolated compute resources for running dataflows
• Sinks: Connections that export data from Materialize to external systems