majiayu000 {{- /* 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:
- 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
{{- 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
| 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
- 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